Curso Excel 2010 Principiante - SL-Institute

SL-Institute

Cette leçon contient

Expand All

Módulo 1 – CRIAÇÃO DE TABELAS 7 Chapitres

Expand

Leçon Content

0% complété 0/7 étapes

Atalhos Indispensáveis

Inserção de Dados

Formatar Tabelas Automaticamente

Formatação Manual de Tabelas

Trabalho com linhas e colunas

Trabalho com Folhas

Impressão em Excel

Módulo 2 – OPERAÇÕES ESSENCIAIS 3 Chapitres

Expand

Leçon Content

0% complété 0/3 étapes

Filtro automático

Ordenar Informação

Cópia e Transferência de Células

Módulo 3 – CÁLCULOS MANUAIS EM EXCEL 2 Chapitres

Expand

Leçon Content

0% complété 0/2 étapes

Cálculos Manuais

Eliminar passos intermédios de um cálculo complexo

Módulo 4 – GRÁFICOS 2 Chapitres

Expand

Leçon Content

0% complété 0/2 étapes

Criação de Gráficos

Gráficos Sparkline

Módulo 5 – FUNÇÕES EM EXCEL 9 Chapitres

Expand

Leçon Content

0% complété 0/9 étapes

Funções de Texto

Converter valores guardados como texto em valores

Texto Para Colunas (Text To Columns)

Gerir Duplicados

Funções Condicionais

PROCV (VLOOKUP)

PROCV com SE.ERRO (VLOOKUP com IFERROR)

Módulo 6 – TABELAS DE CONVERSÃO 1 Chapitre

Expand

Leçon Content

0% complété 0/1 étapes

Módulo 7 – FORMATAÇÃO CONDICIONAL

Módulo 8 – TABELAS DINÂMICAS 6 Chapitres

Expand

Leçon Content

0% complété 0/6 étapes

Tabelas dinâmicas: Questões Iniciais

Criar tabelas dinâmicas

Configurações iniciais

Analisar dados com a tabela dinamica

Trabalho com dados da tabela original

Configurações avançadas

Módulo 9 – INTRODUÇÃO AOS DASHBOARDS 5 Chapitres

Expand

Leçon Content

0% complété 0/5 étapes

Características de um bom dashboard

Passos de criação de um dashboard

Passos de criação de dashboards

Módulo 10 – PROTECÇÃO DE DADOS 4 Chapitres

Expand

Leçon Content

0% complété 0/4 étapes

Primeiro Passo: Definição de Validações

Segundo Passo: Proteger Células e ocultar Fórmulas

Terceiro Passo: Proteção da Estrutura do Livro

Quarto Passo: Proteção do Ficheiro

Módulo 11 – INTRODUÇÃO ÀS MACROS 8 Chapitres

Expand

Leçon Content

0% complété 0/8 étapes

Quando é altura de gravar uma Macro?

Procedimento Conceptual para Gravar Macros

Gravação de Macros

Atribuir a uma Macro um botão da Barra de Ferramentas de Acesso Rápido

Juntar Várias Macros numa Só

Truques de selecção em Macros com referências relativas

Códigos VBA Uteis

Macros de Função

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;}