Microsoft Excel: From Beginner to Advanced Microsoft Excel

Name: Microsoft Excel: From Beginner to Advanced Microsoft Excel
Rating: 5.0 (9 reviews)

Learn Excel 365 from beginner to advanced with formulas, PivotTables, charts, Power Query, VBA, dashboards & AI tools

New

Created byMind Stack

Last updated 5/2026

English

What you'll learn

Master Excel 365 fundamentals, formulas, functions, and productivity shortcuts
Analyze data using PivotTables, PivotCharts, dashboards, and visual reports
Clean, organize, and automate workflows with Power Query and VBA macros
Use advanced Excel tools like XLOOKUP, dynamic arrays, Power Pivot, and Excel Copilot AI

Course content

7 sections • 68 lectures • 30h 49m total length

Welcome to the Excel 365 Master Class2:03
Who This Course Is (And Isn't) For2:16
How to get the most out of this course2:38
The Origin of Excel1:35
Getting Started with Excel 3653:59
Your First Excel Workbook14:26
Core Excel Features Refresher17:52
Introduction to Functions20:03
Getting Started with Excel Copilot (AI in Excel)12:23
Keyboard Shortcuts & Productivity Tips14:16
Mini Project20:01

Introduction to Data Cleaning19:47
Define dirty data, overview of cleaning process (display clear “before/after” examples)
Removing Duplicates21:42
Identifying and eliminating duplicate values (display clear “before/after” examples)
Handling Missing Data32:04
Techniques to identify and fill/remove missing data (display clear “before/after” examples)
Fixing Inconsistent Data Formats26:53
Unifying date, number, text, and case formats
Text-to-Columns and Data Splitting18:01
Separating merged data into usable fields
Using Flash Fill & Autofill for Patterns21:59
Recognizing and automating patterns
Data Validation & Error Checking25:50
Set rules for clean input & catch errors
Cleaning with Power Query21:57
Using Power Query for large-scale cleaning
Standardizing Categorical Data27:15
Unifying category names (e.g., USA vs. U.S.A vs. US)
Mini Project23:30
Real-world dirty dataset to clean using learned tools

Mastering Logical Functions39:54
Deep dive into IF, IFS, AND, OR, NOT functions
Lookup & Reference Magic43:14
Mastering VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH
Dynamic Arrays & Spill Functions35:20
Exploring FILTER, SORT, UNIQUE, SEQUENCE, RANDARRAY
Text Functions for Data Cleaning35:29
Using TEXTSPLIT, TEXTJOIN, LEFT, RIGHT, MID, LEN, FIND, SUBSTITUTE
Working with Date and Time Functions31:43
Functions like TODAY, NOW, DATEDIF, EOMONTH, NETWORKDAYS
Advanced Math & Statistical Functions25:52
Learn SUMPRODUCT, AGGREGATE, LARGE/SMALL, STDEV, MEDIAN, FORECAST
Creating Nested and Hybrid Formulas35:50
Nesting IFs, combining INDEX/MATCH with other logic
Auditing, Troubleshooting, and Formula Debugging42:52
Evaluate, Trace Precedents/Dependents, Error Checking Tools
Mini Project59:03
Apply all functions in business scenarios (e.g. dashboards, reports)

Introduction to PivotTables20:21
What is a PivotTable, how and why to use it
Creating Your First PivotTable20:48
Building a basic PivotTable from raw data - Start with a story-driven example
Customizing PivotTables28:23
Formatting, sorting, filtering, and calculated fields
Grouping & Drill Down31:36
Grouping dates, numbers, and using drill-downGrouping dates, numbers, and using drill-down
Using Slicers & Timelines34:18
Interactive data filtering with slicers and timelines
Introduction to PivotCharts25:39
Convert PivotTables into charts, basics of visualization
Customizing PivotCharts28:53
Chart types, formatting, and interactivity with slicers
Analyzing Trends & Patterns35:03
Use PivotTables & PivotCharts for business insights
Building a Dashboard with PivotTables & Charts32:28
Create a mini-dashboard using learned tools
Mini Project21:14
Wrap-up, use cases, next steps

Introduction to Data Visualization27:46
Purpose of charts, choosing visuals, visualization principles - Focus on when to use each chart
Bar and Column Charts – Comparison Made Easy27:42
Comparing categories, grouped vs. stacked visuals
Line and Area Charts – Visualizing Trends32:31
Showing trends over time, smoothing, cumulative data
Pie and Donut Charts – Showing Proportions27:22
Displaying part-to-whole relationships, avoiding clutter
Combo Charts – Dual Axis and Mixed Insights29:10
Comparing different data types (e.g., revenue & margins)
Scatter and Bubble Charts – Correlation & Distribution26:53
Discovering relationships, identifying outliers
Dynamic Charts with Tables and Slicers32:40
Interactive visuals, filtering, real-time updates
Formatting for Impact – Colors, Layout, and Labels32:28
Chart readability, color schemes, minimalism
Advanced Visualization Techniques44:26
Financial charts, KPI displays, small-scale dashboards
Mini Project47:10
Capstone project: build a visual story from raw data

Intro to Macros and VBA31:46
What macros are, recording macros, opening the VBA editor
Understanding the VBA Editor31:50
Project Explorer, Code Window, writing your first Sub
Variables, Logic & Loops26:55
Declaring variables, IF logic, For/While loops
Working with Ranges and Worksheets28:09
Range object, working across worksheets, reading/writing cells
Automating Common Excel Tasks29:45
Automating reports, user buttons, file operations
Error Handling and Debugging30:21
Catching and handling errors, breakpoints, stepping through code
Real-World Automation Scenarios31:23
Automating invoices, emailing reports, cleaning CSV data
Mini Project30:12
Student-designed automation project
Pre-Lesson: Getting Comfortable with Macros & VBA20:53
Purpose: Orientation, confidence-building, and mental framing (not coding yet)

Introduction to Power Tools in Excel30:56
Overview of tools, key differences, use cases
Getting Started with Power Query27:14
Loading data, navigating the UI, basic transformations
Data Cleaning with Power Query35:46
Removing errors, duplicates, blanks, standardizing formats
Combining Data from Multiple Sources33:08
Append and merge queries; importing from folders/files
Intro to Power Pivot & Data Modeling32:51
Building relationships, data model structure, schema design
Creating DAX Measures & KPIs32:04
DAX syntax, calculated columns, KPIs, time intelligence
Power Query + Power Pivot Integration35:50
End-to-end workflow from query to model
Mini Project34:18
Real-world project combining Power Query and Power Pivot
Pre-Lesson: Getting Comfortable with Excel Power Tools19:30
Purpose: Orientation, confidence-building, and mental framing (not coding yet)

Requirements

No prior Excel experience is required. You only need a computer with Excel 365 and a willingness to practice and learn.

Description

If you have ever opened Excel and felt overwhelmed, confused, or unsure where to start, this course is for you.

This Excel 365 Masterclass is designed to take you from beginner to confident Excel user through a practical, modern, and hands-on learning experience. Whether you want to improve your job skills, analyze data, build reports, automate tasks, or simply become faster and more organized, this course will guide you step by step.

We start with the foundations of Excel 365, helping you understand workbooks, spreadsheets, formulas, formatting, shortcuts, and productivity techniques before gradually moving into more advanced topics. You will not just memorize tools. You will learn how to actually think and work inside Excel like a professional.

Throughout the course, you will work on practical examples, mini projects, and real-world business scenarios so every lesson connects to something useful and applicable.

You will learn how to:

• Clean and organize messy real-world data
• Use powerful formulas and functions with confidence
• Master VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, SORT, and dynamic arrays
• Build PivotTables and PivotCharts for data analysis
• Create professional charts, dashboards, and visual reports
• Automate repetitive work with Macros and VBA
• Use Power Query and Power Pivot for advanced workflows
• Work faster using keyboard shortcuts and productivity systems
• Use modern AI tools like Excel Copilot to improve workflows and analysis

This course also focuses heavily on clarity and real understanding. Instead of throwing random features at you, we explain when to use tools, why they matter, and how professionals apply them in real situations.

By the end of the course, you will feel comfortable working with large datasets, building reports, analyzing trends, automating tasks, and creating professional Excel workflows that save time and improve decision-making.

Whether you are a student, professional, business owner, analyst, freelancer, or complete beginner, the skills in this course will continue to help you throughout your career.

Let’s open Excel and start building real skills together.

Who this course is for:

Anyone who wants to learn Excel 365 for work, business, data analysis, reporting, automation, or everyday productivity, from beginners to advanced users.

Microsoft Excel: From Beginner to Advanced Microsoft Excel

What you'll learn

Explore related topics

Course content

Excel Foundations & Getting Started with Excel 365 + Copilot11 lectures • 1hr 52min

Data Cleaning and Preparation10 lectures • 3hr 59min

Advanced Formulas and Functions9 lectures • 5hr 49min

PivotTables and PivotCharts10 lectures • 4hr 39min

Charts and Data Visualization10 lectures • 5hr 28min

Automation with Macros (Intro to VBA)9 lectures • 4hr 21min

Excel Power Tools (Intro to Power Query & Power Pivot)9 lectures • 4hr 42min

Requirements

Description

Who this course is for: