Advanced Excel

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

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, to solve real-world business problems efficiently
Create and manage dynamic dashboards with sparklines, mapping, and data visualization techniques for insightful reporting
Automate repetitive tasks using macros and VBA to enhance productivity and streamline workflows
Work seamlessly across multiple worksheets and workbooks with external references and links for comprehensive data management
Implement data forecasting and trend analysis techniques to support strategic decision-making
Protect and share workbooks securely, applying best practices for collaboration and data integrity
Audit and troubleshoot complex formulas to ensure accuracy and optimize Excel models for business applications

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

Show More

Course Content

المحتوى

  • Advanced Excel Power Query Introduction
    00:00
  • Advanced Excel Power Query Installation
    00:00
  • Advanced Excel Power Query Text Functions Part 1
    00:00
  • Advanced Excel Power Query Date Functions Calculate Age
    00:00
  • Advanced Excel Power Query Append 100 Excel Tables
    00:00
  • Advanced Excel Power Query Merge Queries NO VLOOKUP
    00:00
  • Advanced Excel Power Query Merge Queries from two Excel Files
    00:00
  • Advanced Excel Power Query Merge Queries with 3 Lookup Columns
    00:00
  • Advanced Excel Power Query M Function Date Previous N and Next N
    00:00
  • Advanced Excel Power Query Case Study 3 Find only Working Days
    00:00
  • Advanced Excel Power Query Case Study 5 Clean Financial data
    00:00
  • Tutorix Simply Easy Learning Steps
    00:00
  • Tutorix Brings Simply Easy Learning
    00:00
  • Final Exam – Advanced Excel

A course by

A

Student Ratings & Reviews

No Review Yet
No Review Yet

Course Includes:

  • Price:Free
  • Instructor:admin
  • Lessons:13
  • 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
68f6b5cb36c72
Excel avançado e revisão dos conceitos
(0.0/ 0 Rating)
Free
  • 18 Lessons
  • 0 Students
Excel avançado e revisão dos conceitos
(0.0/ 0 Rating)
Free

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...

  • 18 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
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?

✕