Curso Excel Avancado 2010 - SL-Institute

SL-Institute

Cette leçon contient

Expand All

2 – SEGUNDA PARTE 6 Chapitres

Expand

Leçon Content

0% complété 0/6 étapes

Vínculos com outras planilhas ou arquivos

PROCV com CONCATENAR (duas chaves)

Formatação Condicional

Nome em células

3 – TERCEIRA PARTE 5 Chapitres

Expand

Leçon Content

0% complété 0/5 étapes

Uso do comando FILTRAR

Função SUBTOTAL no modo Filtrar

Classificação do Banco de Dados

Tabela Dinâmica

5 – QUINTA PARTE 9 Chapitres

Expand

Leçon Content

0% complété 0/9 étapes

Macros e Programação VBA

Filtro Avançado

Criação de Macros

Do que é feito uma macro?

Operações com Macros

Para excluir uma macro siga os seguintes passos:

Associar botões com Macros

Para associar um botão com uma macro siga os seguintes passos:

Exercícios alunos

SL-Institute

Smart Learning Institute est une école d’apprentissage en ligne proposant des cours, des tutoriels, des eBooks qui aide les étudiants à élargir leurs connaissances. Grâce à une technologie innovante, chaque étudiant peut apprendre 24/7 et développer ses propres compétences.

Explorer

SL-Institute

SL-Institute © 2021

body .is-layout-flow > .alignleft{float:left;margin-inline-start:0;margin-inline-end:2em;}body .is-layout-flow > .alignright{float:right;margin-inline-start:2em;margin-inline-end:0;}body .is-layout-flow > .aligncenter{margin-left:auto !important;margin-right:auto !important;}body .is-layout-constrained > .alignleft{float:left;margin-inline-start:0;margin-inline-end:2em;}body .is-layout-constrained > .alignright{float:right;margin-inline-start:2em;margin-inline-end:0;}body .is-layout-constrained > .aligncenter{margin-left:auto !important;margin-right:auto !important;}body .is-layout-constrained > :where(:not(.alignleft):not(.alignright):not(.alignfull)){max-width:var(--wp--style--global--content-size);margin-left:auto !important;margin-right:auto !important;}body .is-layout-constrained > .alignwide{max-width:var(--wp--style--global--wide-size);}body .is-layout-flex{display:flex;}body .is-layout-flex{flex-wrap:wrap;align-items:center;}body .is-layout-flex > *{margin:0;}.has-black-color{color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-color{color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-color{color:var(--wp--preset--color--white) !important;}.has-pale-pink-color{color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-color{color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-color{color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-color{color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-color{color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-color{color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-color{color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-color{color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-color{color:var(--wp--preset--color--vivid-purple) !important;}.has-black-background-color{background-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-background-color{background-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-background-color{background-color:var(--wp--preset--color--white) !important;}.has-pale-pink-background-color{background-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-background-color{background-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-background-color{background-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-background-color{background-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-background-color{background-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-background-color{background-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-background-color{background-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-background-color{background-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-background-color{background-color:var(--wp--preset--color--vivid-purple) !important;}.has-black-border-color{border-color:var(--wp--preset--color--black) !important;}.has-cyan-bluish-gray-border-color{border-color:var(--wp--preset--color--cyan-bluish-gray) !important;}.has-white-border-color{border-color:var(--wp--preset--color--white) !important;}.has-pale-pink-border-color{border-color:var(--wp--preset--color--pale-pink) !important;}.has-vivid-red-border-color{border-color:var(--wp--preset--color--vivid-red) !important;}.has-luminous-vivid-orange-border-color{border-color:var(--wp--preset--color--luminous-vivid-orange) !important;}.has-luminous-vivid-amber-border-color{border-color:var(--wp--preset--color--luminous-vivid-amber) !important;}.has-light-green-cyan-border-color{border-color:var(--wp--preset--color--light-green-cyan) !important;}.has-vivid-green-cyan-border-color{border-color:var(--wp--preset--color--vivid-green-cyan) !important;}.has-pale-cyan-blue-border-color{border-color:var(--wp--preset--color--pale-cyan-blue) !important;}.has-vivid-cyan-blue-border-color{border-color:var(--wp--preset--color--vivid-cyan-blue) !important;}.has-vivid-purple-border-color{border-color:var(--wp--preset--color--vivid-purple) !important;}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background:var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important;}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background:var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important;}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important;}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important;}.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background:var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important;}.has-cool-to-warm-spectrum-gradient-background{background:var(--wp--preset--gradient--cool-to-warm-spectrum) !important;}.has-blush-light-purple-gradient-background{background:var(--wp--preset--gradient--blush-light-purple) !important;}.has-blush-bordeaux-gradient-background{background:var(--wp--preset--gradient--blush-bordeaux) !important;}.has-luminous-dusk-gradient-background{background:var(--wp--preset--gradient--luminous-dusk) !important;}.has-pale-ocean-gradient-background{background:var(--wp--preset--gradient--pale-ocean) !important;}.has-electric-grass-gradient-background{background:var(--wp--preset--gradient--electric-grass) !important;}.has-midnight-gradient-background{background:var(--wp--preset--gradient--midnight) !important;}.has-small-font-size{font-size:var(--wp--preset--font-size--small) !important;}.has-medium-font-size{font-size:var(--wp--preset--font-size--medium) !important;}.has-large-font-size{font-size:var(--wp--preset--font-size--large) !important;}.has-x-large-font-size{font-size:var(--wp--preset--font-size--x-large) !important;}.wp-block-navigation a:where(:not(.wp-element-button)){color:inherit;}.wp-block-pullquote{font-size:1.5em;line-height:1.6;}.woocommerce form .form-row .required{visibility:visible;}.country-selector.weglot-dropdown .wgcurrent a{display:none;}.bb-style-primary-bgr-color{background-color:#fe4a55;}.bb-style-border-radius{border-radius:7px;}.site-header-container #site-logo .bb-logo img,.site-header-container #site-logo .site-title img.bb-logo,.site-title img.bb-mobile-logo{max-height:76px;}.sticky-header .site-header{position:fixed;z-index:610;width:100%;}.sticky-header .bp-search-ac-header{position:fixed;}body.buddypress.sticky-header .site-content,.bb-buddypanel.sticky-header .site-content,.single-sfwd-quiz.bb-buddypanel.sticky-header .site-content,.single-sfwd-lessons.bb-buddypanel.sticky-header .site-content,.single-sfwd-topic.bb-buddypanel.sticky-header .site-content{padding-top:76px;}.site-header .site-header-container,.header-search-wrap,.header-search-wrap input.search-field,.header-search-wrap form.search-form{height:76px;}.sticky-header .bp-feedback.bp-sitewide-notice{top:76px;}[data-bp-tooltip]:after{background-color:rgba(30,33,50,1);box-shadow:none;}[data-bp-tooltip]:before{background:no-repeat url("data:image/svg+xml;charset=utf-8,%3Csvg%20xmlns%3D%22http://www.w3.org/2000/svg%22%20width%3D%2236px%22%20height%3D%2212px%22%3E%3Cpath%20fill%3D%22rgba( 30,33,50,1 )%22%20transform%3D%22rotate(0)%22%20d%3D%22M2.658,0.000%20C-13.615,0.000%2050.938,0.000%2034.662,0.000%20C28.662,0.000%2023.035,12.002%2018.660,12.002%20C14.285,12.002%208.594,0.000%202.658,0.000%20Z%22/%3E%3C/svg%3E");background-size:100% auto;}[data-bp-tooltip][data-bp-tooltip-pos="right"]:before,[data-balloon][data-balloon-pos='right']:before{background:no-repeat url("data:image/svg+xml;charset=utf-8,%3Csvg%20xmlns%3D%22http://www.w3.org/2000/svg%22%20width%3D%2212px%22%20height%3D%2236px%22%3E%3Cpath%20fill%3D%22rgba( 30,33,50,1 )%22%20transform%3D%22rotate(90 6 6)%22%20d%3D%22M2.658,0.000%20C-13.615,0.000%2050.938,0.000%2034.662,0.000%20C28.662,0.000%2023.035,12.002%2018.660,12.002%20C14.285,12.002%208.594,0.000%202.658,0.000%20Z%22/%3E%3C/svg%3E");background-size:100% auto;}[data-bp-tooltip][data-bp-tooltip-pos="left"]:before,[data-balloon][data-balloon-pos='left']:before{background:no-repeat url("data:image/svg+xml;charset=utf-8,%3Csvg%20xmlns%3D%22http://www.w3.org/2000/svg%22%20width%3D%2212px%22%20height%3D%2236px%22%3E%3Cpath%20fill%3D%22rgba( 30,33,50,1 )%22%20transform%3D%22rotate(-90 18 18)%22%20d%3D%22M2.658,0.000%20C-13.615,0.000%2050.938,0.000%2034.662,0.000%20C28.662,0.000%2023.035,12.002%2018.660,12.002%20C14.285,12.002%208.594,0.000%202.658,0.000%20Z%22/%3E%3C/svg%3E");background-size:100% auto;}[data-bp-tooltip][data-bp-tooltip-pos="down-left"]:before,[data-bp-tooltip][data-bp-tooltip-pos="down"]:before,[data-balloon][data-balloon-pos='down']:before{background:no-repeat url("data:image/svg+xml;charset=utf-8,%3Csvg%20xmlns%3D%22http://www.w3.org/2000/svg%22%20width%3D%2236px%22%20height%3D%2212px%22%3E%3Cpath%20fill%3D%22rgba( 30,33,50,1 )%22%20transform%3D%22rotate(180 18 6)%22%20d%3D%22M2.658,0.000%20C-13.615,0.000%2050.938,0.000%2034.662,0.000%20C28.662,0.000%2023.035,12.002%2018.660,12.002%20C14.285,12.002%208.594,0.000%202.658,0.000%20Z%22/%3E%3C/svg%3E");background-size:100% auto;}html[dir="rtl"] .learndash_next_prev_link a.next-link,html[dir="rtl"] .learndash_next_prev_link span.next-link{border-radius:px 0 0 px;}html[dir="rtl"] .learndash_next_prev_link a.prev-link,html[dir="rtl"] .learndash_next_prev_link span.prev-link{border-radius:0 px px 0;}a.bb-close-panel i{top:21px;}p.custom-indent{text-indent:60px;}.site-header .site-title{font-family:Nunito;font-weight:500;font-style:normal;font-size:30px;font-display:swap;}h3{font-family:Nunito;font-weight:400;font-style:normal;font-size:20px;font-display:swap;}h5{font-family:Nunito;font-weight:400;font-style:normal;font-size:16px;font-display:swap;}h6{font-family:Nunito;font-weight:500;font-style:normal;font-size:12px;font-display:swap;}.e-my-account-tab .woocommerce-message--info{border-top-color:#fe4a55;color:#333;}.e-my-account-tab .woocommerce-message--info a{background-color:#fe4a55;color:#fff !important;}.e-my-account-tab .woocommerce-Message--info{border-top-color:#fe4a55;font-size:16px;}.e-my-account-tab .woocommerce-Message--info a{background-color:#fe4a55;color:#fff !important;font-weight:500;font-size:16px;}#course-dir-list .bb-course-items .course-fee{color:#1e2132;font-weight:300;font-size:14px;}#course-dir-list .bb-course-items .bb-cover-list-item{padding-bottom:0px;}.elementor-nav-menu--main .sm-nowrap .wpml-ls-flag{padding-right:5px;}.wpml-ls-legacy-list-horizontal ul a{color:#2d2d2d !important;font-size:16px;}.wpml-ls-legacy-list-horizontal ul .wpml-ls-flag{padding-right:5px;}.wpml-tf-feedback-icon{display:none;}.elementor-element-0e393d6 .elementor-container .elementor-row .elementor-top-column .elementor-column-wrap .elementor-widget-wrap .elementor-cta--ldprogress-left .elementor-widget-container .bb-ldactivity--ismy .bb-la-composer div div div div .bb-la-slide .bb-la-block{height:auto !important;}#content .container .bb-grid .elementor-location-archive .elementor-section-wrap .elementor-element-0e393d6 .elementor-container .elementor-row .elementor-top-column .elementor-column-wrap .elementor-widget-wrap .elementor-cta--ldprogress-left .elementor-widget-container .bb-ldactivity--ismy .bb-ldactivity__blank{height:auto !important;}.ld-tabs p strong{color:#fe4a55;}.ld-tabs .wp-block-code{background-color:#000;}.ld-tabs .wp-block-code code{color:#fff;}#wc-stripe-new-payment-method{display:none !important;}#wc_checkout_add_ons .wc-checkout-add-ons-input-file-plupload{border-style:solid;border-color:#fe4a55;border-top-left-radius:5px;border-top-right-radius:5px;border-bottom-left-radius:5px;border-bottom-right-radius:5px;}#wc_checkout_add_ons .wc-checkout-add-ons-input-file-plupload .wc-checkout-add-ons-dropzone{color:#fe4a55;}#place_order{background-color:#fe4a55;}#wc_checkout_add_ons .wc_checkout_add_ons_fileupload{display:none !important;}.woocommerce-error li strong{color:#333 !important;font-weight:500 !important;}#course-dir-list .bb-cover-wrap .ld-status-incomplete{background-color:#fe4a55;}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px;}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px;}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px;}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px;}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px;}.elementor-widget-divider .elementor-divider__text{font-size:15px;line-height:1;max-width:95%;}.elementor-widget-divider .elementor-divider__element{margin:0 var(--divider-element-spacing);flex-shrink:0;}.elementor-widget-divider .elementor-icon{font-size:var(--divider-icon-size);}.elementor-widget-divider--view-line_icon .elementor-divider-separator,.elementor-widget-divider--view-line_text .elementor-divider-separator{align-items:center;}.elementor-widget-divider--view-line_icon .elementor-divider-separator:after,.elementor-widget-divider--view-line_icon .elementor-divider-separator:before,.elementor-widget-divider--view-line_text .elementor-divider-separator:after,.elementor-widget-divider--view-line_text .elementor-divider-separator:before{display:block;content:"";border-bottom:0;flex-grow:1;border-top:var(--divider-border-width) var(--divider-border-style) var(--divider-color);}.elementor-widget-divider--element-align-left .elementor-divider .elementor-divider-separator>.elementor-divider__svg:first-of-type{flex-grow:0;flex-shrink:100;}.elementor-widget-divider--element-align-left .elementor-divider-separator:before{content:none;}.elementor-widget-divider--element-align-left .elementor-divider__element{margin-left:0;}.elementor-widget-divider--element-align-right .elementor-divider .elementor-divider-separator>.elementor-divider__svg:last-of-type{flex-grow:0;flex-shrink:100;}.elementor-widget-divider--element-align-right .elementor-divider-separator:after{content:none;}.elementor-widget-divider--element-align-right .elementor-divider__element{margin-right:0;}.elementor-widget-divider--separator-type-pattern{--divider-border-style:none;}.elementor-widget-divider--separator-type-pattern.elementor-widget-divider--view-line .elementor-divider-separator,.elementor-widget-divider--separator-type-pattern:not(.elementor-widget-divider--view-line) .elementor-divider-separator:after,.elementor-widget-divider--separator-type-pattern:not(.elementor-widget-divider--view-line) .elementor-divider-separator:before,.elementor-widget-divider--separator-type-pattern:not([class*=elementor-widget-divider--view]) .elementor-divider-separator{width:100%;min-height:var(--divider-pattern-height);-webkit-mask-size:var(--divider-pattern-size) 100%;mask-size:var(--divider-pattern-size) 100%;-webkit-mask-repeat:var(--divider-pattern-repeat);mask-repeat:var(--divider-pattern-repeat);background-color:var(--divider-color);-webkit-mask-image:var(--divider-pattern-url);mask-image:var(--divider-pattern-url);}.elementor-widget-divider--no-spacing{--divider-pattern-size:auto;}.elementor-widget-divider--bg-round{--divider-pattern-repeat:round;}.rtl .elementor-widget-divider .elementor-divider__text{direction:rtl;}.e-con-inner>.elementor-widget-divider,.e-con>.elementor-widget-divider{width:var(--container-widget-width,100%);--flex-grow:var(--container-widget-flex-grow);}.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#818a91;color:#fff;}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#818a91;border:3px solid;background-color:transparent;}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px;}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em;}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px;}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block;}