Excel avançado e revisão dos conceitos

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape

Master advanced Excel formulas like PROCV, ÍNDICE, CORRESP, SOMASES, and DESLOC for complex data analysis and automation
Create dynamic tables and interactive charts to visualize data insights effectively in Excel
Utilize Power Query and Power Pivot to streamline data import, transformation, and modeling processes
Develop and implement macros to automate repetitive tasks, increasing productivity and accuracy
Apply cell referencing techniques, including absolute and relative references, for precise formula management
Design professional reports, dashboards, and data analysis tools using Excel’s advanced features
Enhance data organization and analysis skills to support decision-making and business intelligence
Troubleshoot and optimize complex Excel spreadsheets for improved performance and reliability

كورسات من نفس التصنيف

Course Content

المحتوى

  • Curso de Excel Avançado II Ferramenta de Dados Parte 1
    05:57
  • Curso de Excel Avançado II Ferramenta de Dados Parte 2
    04:55
  • Curso de Excel Avançado II Ferramenta de Dados Parte 3
    07:38
  • Curso de Excel Avançado II Filtro Avançado
    15:43
  • Curso de Excel Avançado II Filtro Avançado Continuação
    05:33
  • Curso de Excel Avançado II Introdução aos Macros
    12:26
  • Curso de Excel Avançado II Macros Parte 01
    13:30
  • Curso de Excel Avançado II Tabelas Dinâmicas Parte 1
    15:26
  • Curso de Excel Avançado II Tabelas Dinâmicas Parte 2
    06:29
  • Curso de Excel Avançado II Macros Parte 2 e 3
    11:37
  • Curso de Excel Avançado II Macros Parte 4
    17:34
  • Curso de Excel Avançado II Macros Parte 5
    08:15
  • Curso de Excel Avançado II Macros Parte 5 Continuação
    19:07
  • Curso de Excel Avançado II Macros Parte 6
    05:29
  • Curso de Excel Avançado II Macros Parte 7
    12:08
  • Curso de Excel Avançado II Dashboard Parte 1
    14:32
  • Curso de Excel Avançado II Dashboard Parte 2
    21:08
  • Curso de Excel Avançado II Dashboard Parte 3
    16:05
  • Final Exam – Excel avançado e revisão dos conceitos

A course by

A

Student Ratings & Reviews

No Review Yet
No Review Yet

Course Includes:

  • Price:Free
  • Instructor:admin
  • Lessons:18
  • Students:0
  • Certifications:No

Courses You May Like

68ed73c46582d
Teclas de Atalho e Produtividade no excel
(0.0/ 0 Rating)
Free
  • 6 Lessons
  • 0 Students
Teclas de Atalho e Produtividade no excel
(0.0/ 0 Rating)
Free

Master keyboard shortcuts for efficient navigation and cell selection in Excel for increased productivity Apply formatting shortcuts to quickly enhance spreadsheet appearance and readability in...

  • 6 Lessons
  • 0 Students
Enroll Now
68ed798871dd4
Microsoft powerPoint básicos
(0.0/ 0 Rating)
Free
  • 16 Lessons
  • 0 Students
Microsoft powerPoint básicos
(0.0/ 0 Rating)
Free

Create professional PowerPoint presentations with effective slide layouts and design principles Insert and format texts, images, tables, and charts to enhance visual communication Apply themes,...

  • 16 Lessons
  • 0 Students
Enroll Now
68ed7aa3eed99
Movimento e fluxo de caixa no excel
(0.0/ 0 Rating)
Free
  • 5 Lessons
  • 0 Students
Movimento e fluxo de caixa no excel
(0.0/ 0 Rating)
Free

Create Excel spreadsheets to record cash inflows and outflows for accurate financial tracking Apply formulas to calculate daily, weekly, and monthly cash balances in Excel...

  • 5 Lessons
  • 0 Students
Enroll Now
68ed7e0b01dc1
Excel VIP básico de intermediário
(0.0/ 0 Rating)
Free
  • 1 Lessons
  • 0 Students
Excel VIP básico de intermediário
(0.0/ 0 Rating)
Free

Master creating and formatting Excel spreadsheets for professional reports and data management Apply essential formulas and functions to analyze financial, inventory, and project data efficiently...

  • 1 Lessons
  • 0 Students
Enroll Now
68ed87a9c5399
Excel básico
(0.0/ 0 Rating)
Free
  • 20 Lessons
  • 0 Students
Excel básico
(0.0/ 0 Rating)
Free

Create and format spreadsheets using Microsoft Excel for various practical applications Insert and organize data efficiently in Excel worksheets for improved data management Apply basic...

  • 20 Lessons
  • 0 Students
Enroll Now
68ed8acda44c3
Excel avançado
(0.0/ 0 Rating)
Free
  • 23 Lessons
  • 0 Students
Excel avançado
(0.0/ 0 Rating)
Free

Create complex formulas using PROCV, ÍNDICE, CORRESP, SOMASES, and logical functions for data analysis Design dynamic tables and interactive charts to visualize large datasets effectively...

  • 23 Lessons
  • 0 Students
Enroll Now
68ee646cac540
Análise de dados com o excel
(0.0/ 0 Rating)
Free
  • 8 Lessons
  • 0 Students
Análise de dados com o excel
(0.0/ 0 Rating)
Free

Master data organization, filtering, and sorting techniques to enhance Excel data analysis skills and efficiency Create professional reports using pivot tables, charts, and advanced Excel...

  • 8 Lessons
  • 0 Students
Enroll Now
68f63cd887bb6
Fundamentos de Power BI
(0.0/ 0 Rating)
Free
  • 16 Lessons
  • 0 Students
Fundamentos de Power BI
(0.0/ 0 Rating)
Free

Master data import, transformation, and modeling in Power BI for effective business analysis and decision-making Create interactive reports and dynamic dashboards using Power BI visualizations...

  • 16 Lessons
  • 0 Students
Enroll Now
68f6a51788648
Gráfico no excel
(0.0/ 0 Rating)
Free
  • 24 Lessons
  • 0 Students
Gráfico no excel
(0.0/ 0 Rating)
Free

Create various types of charts in Excel, including column, bar, line, and pie charts for data visualization Customize chart elements such as colors, labels, titles,...

  • 24 Lessons
  • 0 Students
Enroll Now
68f6c6f694532
Fundamentos de PowerPoint
(0.0/ 0 Rating)
Free
  • 24 Lessons
  • 0 Students
Fundamentos de PowerPoint
(0.0/ 0 Rating)
Free

Create visually appealing PowerPoint slides with effective layout and design principles Navigate PowerPoint interface efficiently for seamless presentation creation and editing Insert and format texts,...

  • 24 Lessons
  • 0 Students
Enroll Now
68f6ceb047364
Fundamentos de microsoft word
(0.0/ 0 Rating)
Free
  • 29 Lessons
  • 0 Students
Fundamentos de microsoft word
(0.0/ 0 Rating)
Free

Create professional documents using Microsoft Word’s formatting, styles, and layout tools effectively Insert and customize tables, images, charts, and visual elements to enhance document presentation...

  • 29 Lessons
  • 0 Students
Enroll Now
68f6d192ab61e
Microsoft excel avançado
(0.0/ 0 Rating)
Free
  • 20 Lessons
  • 0 Students
Microsoft excel avançado
(0.0/ 0 Rating)
Free

Master advanced Excel formulas like PROCV, ÍNDICE, CORRESP, SOMASES, and DESLOC for complex data analysis Create dynamic reports and dashboards using PivotTables, Power Query, and...

  • 20 Lessons
  • 0 Students
Enroll Now
68f6d318304d7
Fundamentos de informática
(0.0/ 0 Rating)
Free
  • 15 Lessons
  • 0 Students
Fundamentos de informática
(0.0/ 0 Rating)
Free

Develop skills to operate computers efficiently using hardware, software, and operating systems for daily tasks Apply best practices in digital security, data storage, and safe...

  • 15 Lessons
  • 0 Students
Enroll Now
68f6d68ac4c01
Microsoft excel
(0.0/ 0 Rating)
Free
  • 21 Lessons
  • 0 Students
Microsoft excel
(0.0/ 0 Rating)
Free

Master Excel formulas and functions like SUM, AVERAGE, IF, and VLOOKUP for data analysis and reporting Create and format spreadsheets to organize financial data, control...

  • 21 Lessons
  • 0 Students
Enroll Now
68f8ec2ae2746
Raspberry Pi
(0.0/ 0 Rating)
Free
  • 36 Lessons
  • 0 Students
Raspberry Pi
(0.0/ 0 Rating)
Free

Master Raspberry Pi setup, configuration, and installation of operating systems for diverse projects Utilize Linux commands and terminal skills to manage Raspberry Pi efficiently in...

  • 36 Lessons
  • 0 Students
Enroll Now
68f8ef16b8d38
Fundamentos de linux
(0.0/ 0 Rating)
Free
  • 14 Lessons
  • 0 Students
Fundamentos de linux
(0.0/ 0 Rating)
Free

Configure and install Linux distributions for server and development environments effectively Navigate and manipulate Linux directory structures using essential commands and tools accurately Manage user...

  • 14 Lessons
  • 0 Students
Enroll Now
68f92db75e312
Fundamentos de hardware
(0.0/ 0 Rating)
Free
  • 35 Lessons
  • 0 Students
Fundamentos de hardware
(0.0/ 0 Rating)
Free

Identify computer hardware components such as motherboard, CPU, RAM, ROM, HDD, SSD, and peripherals accurately Perform computer assembly, disassembly, and upgrades with confidence and precision...

  • 35 Lessons
  • 0 Students
Enroll Now
68f9468844f98
Microsoft word essencial
(0.0/ 0 Rating)
Free
  • 22 Lessons
  • 0 Students
Microsoft word essencial
(0.0/ 0 Rating)
Free

Create professional documents using Microsoft Word’s basic formatting tools and features Apply styles, headers, footers, and page numbering to enhance document structure and readability Insert...

  • 22 Lessons
  • 0 Students
Enroll Now
68f956c020909
Como Faz soma no excel
(0.0/ 0 Rating)
Free
  • 7 Lessons
  • 0 Students
Como Faz soma no excel
(0.0/ 0 Rating)
Free

Master basic and advanced Excel sum functions like =SOMA(), SOMASE, and SUBTOTAL for efficient data analysis and financial management Apply Excel autosum (Σ) and work...

  • 7 Lessons
  • 0 Students
Enroll Now
68f957ffcae66
Pacote office
(0.0/ 0 Rating)
Free
  • 9 Lessons
  • 0 Students
Pacote office
(0.0/ 0 Rating)
Free

Create professional documents using Word with advanced formatting, styles, and images for business and academic needs Organize, analyze, and visualize data efficiently in Excel through...

  • 9 Lessons
  • 0 Students
Enroll Now
68f9595707b7a
Microsoft word
(0.0/ 0 Rating)
Free
  • 6 Lessons
  • 0 Students
Microsoft word
(0.0/ 0 Rating)
Free

Create professional documents using advanced formatting and styles in Microsoft Word Insert and customize tables, images, headers, and footers for comprehensive document design Utilize automatic...

  • 6 Lessons
  • 0 Students
Enroll Now
68f95ac07761f
Como mexer no word
(0.0/ 0 Rating)
Free
  • 59 Lessons
  • 0 Students
Como mexer no word
(0.0/ 0 Rating)
Free

Create and format professional documents using Microsoft Word tools and features effectively Navigate the Word interface confidently to access essential functions and commands Insert and...

  • 59 Lessons
  • 0 Students
Enroll Now
68f95c80063cf
Como Criar planilha no excel
(0.0/ 0 Rating)
Free
  • 8 Lessons
  • 0 Students
Como Criar planilha no excel
(0.0/ 0 Rating)
Free

Create organized spreadsheets in Excel using data entry and formatting techniques Apply basic formulas like SUM, AVERAGE, and IF for data analysis and calculations Design...

  • 8 Lessons
  • 0 Students
Enroll Now
68f95e202be66
Como mexer e usar o microsoft excel
(0.0/ 0 Rating)
Free
  • 9 Lessons
  • 0 Students
Como mexer e usar o microsoft excel
(0.0/ 0 Rating)
Free

Create and organize spreadsheets using Microsoft Excel for personal and professional tasks Apply basic formulas and functions like SUM, AVERAGE, and IF to analyze data...

  • 9 Lessons
  • 0 Students
Enroll Now
68f960b5bd315
Como aprender a usar o Pacote office
(0.0/ 0 Rating)
Free
  • 60 Lessons
  • 0 Students
Como aprender a usar o Pacote office
(0.0/ 0 Rating)
Free

Create professional documents using Microsoft Word with advanced formatting and editing skills Organize, analyze, and visualize data effectively in Excel using formulas, functions, and data...

  • 60 Lessons
  • 0 Students
Enroll Now
6907b5e641cc3
Cómo instalar windows server 11
(0.0/ 0 Rating)
Free
  • 135 Lessons
  • 0 Students
Cómo instalar windows server 11
(0.0/ 0 Rating)
Free

Master Windows Server 11 installation, configuration, and setup for enterprise and lab environments using best practices and security measures Configure BIOS/UEFI settings and prepare installation...

  • 135 Lessons
  • 0 Students
Enroll Now
6924affe978cb
Microsoft power pages
(0.0/ 0 Rating)
Free
  • 40 Lessons
  • 0 Students
Microsoft power pages
(0.0/ 0 Rating)
Free

Create secure, professional low-code websites using Microsoft Power Pages for business applications and data management Design and customize website layouts, themes, and pages with Power...

  • 40 Lessons
  • 0 Students
Enroll Now
6924b235aeec9
Uploading files to teraBox
(0.0/ 0 Rating)
Free
  • 22 Lessons
  • 0 Students
Uploading files to teraBox
(0.0/ 0 Rating)
Free

Create and manage TeraBox accounts for seamless cloud storage access Navigate TeraBox interface to upload and organize photos, videos, and documents efficiently Utilize automatic backup...

  • 22 Lessons
  • 0 Students
Enroll Now
6924b51ee129e
Handbrake
(0.0/ 0 Rating)
Free
  • 44 Lessons
  • 0 Students
Handbrake
(0.0/ 0 Rating)
Free

Master video transcoding using HandBrake for optimal quality and file size reduction Apply HandBrake presets and customize settings for various devices and platforms effectively Implement...

  • 44 Lessons
  • 0 Students
Enroll Now
6924b694917b7
VLC media payer
(0.0/ 0 Rating)
Free
  • 59 Lessons
  • 0 Students
VLC media payer
(0.0/ 0 Rating)
Free

Master navigating VLC media player interface for efficient media management and playback control Apply VLC’s advanced features such as playlist creation, media conversion, and online...

  • 59 Lessons
  • 0 Students
Enroll Now
6924ba2cb079c
Microsoft planner
(0.0/ 0 Rating)
Free
  • 34 Lessons
  • 0 Students
Microsoft planner
(0.0/ 0 Rating)
Free

Create and organize task plans using Microsoft Planner for effective project management and team collaboration Build and customize task boards with buckets, labels, and due...

  • 34 Lessons
  • 0 Students
Enroll Now
6924bc53f2326
Google Photos Interface
(0.0/ 0 Rating)
Free
  • 59 Lessons
  • 0 Students
Google Photos Interface
(0.0/ 0 Rating)
Free

Master how to navigate Google Photos interface including Photos, Search, Library, and Sharing tabs for efficient media management Utilize AI-powered organization features to automatically categorize...

  • 59 Lessons
  • 0 Students
Enroll Now
6924beab79669
Accessing Kimi AI
(0.0/ 0 Rating)
Free
  • 49 Lessons
  • 0 Students
Accessing Kimi AI
(0.0/ 0 Rating)
Free

Master how to create and manage a Kimi AI account for seamless platform access and security. Navigate Kimi AI’s interface efficiently to utilize chat, research,...

  • 49 Lessons
  • 0 Students
Enroll Now
6924e1003c71d
Accessing structured web
(0.0/ 0 Rating)
Free
  • 26 Lessons
  • 0 Students
Accessing structured web
(0.0/ 0 Rating)
Free

Identify structured data formats like Schema.org, JSON-LD, Microdata, and RDFa for web content analysis Extract structured web data efficiently using parsing tools and techniques for...

  • 26 Lessons
  • 0 Students
Enroll Now
6924ecdb3b2bc
Setting up thunderbird
(0.0/ 0 Rating)
Free
  • 121 Lessons
  • 0 Students
Setting up thunderbird
(0.0/ 0 Rating)
Free

Configure Mozilla Thunderbird installation for optimal performance and security using latest software versions and system settings Set up and manage multiple email accounts with IMAP...

  • 121 Lessons
  • 0 Students
Enroll Now
669e8624d4a92
Microsoft word advanced skills
(0.0/ 0 Rating)
Free
  • 3 Lessons
  • 0 Students
Microsoft word advanced skills
(0.0/ 0 Rating)
Free

Master advanced formatting, styles, and templates to create consistent, professional documents in Microsoft Word Utilize tables of contents, indexes, bibliographies, and layout techniques for efficient...

  • 3 Lessons
  • 0 Students
Enroll Now
665108bc3207c
Excel Power Query in excel for beginners
(0.0/ 0 Rating)
Free
  • 65 Lessons
  • 0 Students
Excel Power Query in excel for beginners
(0.0/ 0 Rating)
Free

Master importing data from diverse sources like databases, text files, and web pages using Excel Power Query Transform and clean raw data efficiently to prepare...

  • 65 Lessons
  • 0 Students
Enroll Now
6575f6f5a4fe7
Microsoft Word
(0.0/ 0 Rating)
Free
  • 46 Lessons
  • 0 Students
Microsoft Word
(0.0/ 0 Rating)
Free

Create professional documents, reports, and letters using advanced formatting and layout tools in Microsoft Word Apply spell check, grammar check, and editing features to ensure...

  • 46 Lessons
  • 0 Students
Enroll Now
6575f6f5aebd9
Microsoft Excel
(0.0/ 0 Rating)
Free
  • 49 Lessons
  • 0 Students
Microsoft Excel
(0.0/ 0 Rating)
Free

Master data entry and storage techniques using Microsoft Excel for efficient business operations Apply Excel functions and formulas to verify and analyze business data accurately...

  • 49 Lessons
  • 0 Students
Enroll Now
6575f6fa704c8
Advanced Excel
(0.0/ 0 Rating)
Free
  • 13 Lessons
  • 0 Students
Advanced Excel
(0.0/ 0 Rating)
Free

Master advanced Excel functions like macros, pivot tables, and lookup formulas for data analysis and automation skills Utilize complex formulas, including arrays and conditional lists,...

  • 13 Lessons
  • 0 Students
Enroll Now
6575f6f696c69
Power BI
(0.0/ 0 Rating)
Free
  • 31 Lessons
  • 0 Students
Power BI
(0.0/ 0 Rating)
Free

Create interactive dashboards and reports using Power BI’s visualization tools and data modeling features Connect and integrate diverse data sources, including ERP systems, for comprehensive...

  • 31 Lessons
  • 0 Students
Enroll Now
6575f6f64026e
Computers skills
(0.0/ 0 Rating)
Free
  • 25 Lessons
  • 0 Students
Computers skills
(0.0/ 0 Rating)
Free

Master effective typing, mouse skills, and fundamental computer operations for daily tasks and productivity Utilize productivity software like word processors, spreadsheets, and presentation tools efficiently...

  • 25 Lessons
  • 0 Students
Enroll Now
hqdefault-101
MS Excel
(0.0/ 0 Rating)
Free
  • 94 Lessons
  • 0 Students
MS Excel
(0.0/ 0 Rating)
Free

Spreadsheets, files and memos are necessary documents in most businesses. … Microsoft Excel and Microsoft Word are part of the Microsoft Office package of …...

  • 94 Lessons
  • 0 Students
Enroll Now
hqdefault-24
Excel Course Basic to Advanced
(0.0/ 0 Rating)
Free
  • 26 Lessons
  • 1 Students
Excel Course Basic to Advanced
(0.0/ 0 Rating)
Free

What is Excel mean? : to be superior to : surpass in accomplishment or achievement. intransitive verb. : to be distinguishable by superiority : surpass...

  • 26 Lessons
  • 1 Students
Enroll Now

Want to receive push notifications for all major on-site activities?

✕