Microsoft Excel Basic to Advanced: Ultimate Excel Mastery

Name: Microsoft Excel Basic to Advanced: Ultimate Excel Mastery
Rating: 4.1 (100 reviews)

Become an Excel expert: learn essential skills and advanced techniques in one course.

Created byBright Path

Last updated 7/2025

English

What you'll learn

Working with Date and Time Functions
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
Introduction to Pivot Tables and Pivot Charts
Using Excel for Basic Data Analysis
Advanced Lookup and Reference Functions (INDEX, MATCH)
Array Formulas and Dynamic Arrays
Advanced Conditional Formatting and Data Highlighting
Working with Complex Text Functions
Creating and Customizing Charts and Graphs
Building Interactive Dashboards
Advanced Data Visualization Techniques
Recording and Running Basic Macros
Using Solver for Optimization Problems

Course content

1 section • 16 lectures • 2h 11m total length

Working with Date and Time Functions8:35
Introduction to Pivot Tables and Pivot Charts6:10
Using Excel for Basic Data Analysis6:35
Explore how Excel enables basic data analysis through sorting, filtering, and calculating metrics on a sales dataset. Create a table, then generate charts to reveal insights and support decision making.
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)12:43
Advanced Lookup and Reference Functions (INDEX, MATCH)8:00
Learn advanced lookup and reference functions in Excel using INDEX and MATCH as flexible alternatives to VLOOKUP. Apply them to an employee salary dataset to retrieve salaries and identify positions.
Array Formulas and Dynamic Arrays6:33
Working with Complex Text Functions7:56
Advanced Conditional Formatting and Data Highlighting6:11
Explore advanced conditional formatting in Excel using color scales, data bars, and icon sets to visualize sales data, highlight trends and top performers in a simple dataset.
Creating and Customizing Charts and Graphs8:55
Using Sparklines for Data Trends7:18
Building Interactive Dashboards8:25
Advanced Data Visualization Techniques8:21
Introduction to VBA Programming in Excel5:51
Recording and Running Basic Macros6:29
Using Solver for Optimization Problems9:49
What-If Analysis Tools (Goal Seek, Scenario Manager)13:21

Requirements

No prior Excel experience needed
A computer with Microsoft Excel installed (preferably Excel 2016 or later)

Description

Unlock the full potential of Microsoft Excel and become a spreadsheet power user with "Microsoft Excel Basic to Advanced: Ultimate Excel Mastery." Whether you're a complete beginner or an experienced user looking to sharpen your skills, this comprehensive course is your one-stop guide to mastering Excel from the ground up.

Designed for learners of all levels, this course takes you on a structured journey through the most essential and advanced features of Excel, including data entry, formatting, formulas, functions, data analysis, pivot tables, charts, and automation using macros.

What You’ll Learn:

Excel Fundamentals: Interface overview, workbook navigation, data types, and best practices
Data Entry & Formatting: Efficient data input, formatting tips, and workbook organization
Formulas & Functions: From basic arithmetic to advanced functions like VLOOKUP, INDEX & MATCH, IF statements, and nested functions
Data Management: Sorting, filtering, data validation, and conditional formatting
Data Analysis Tools: PivotTables, PivotCharts, What-If Analysis, and Goal Seek
Charts & Graphs: Visualizing data using column, line, pie, combo charts, and more
Excel Automation: Introduction to macros and basic VBA scripting

By the end of this course, you'll confidently handle any Excel task—whether it's organizing data, performing complex analysis, creating dynamic reports, or automating workflows.

Enroll now and become an Excel expert with Ultimate Excel Mastery!

Who this course is for:

Beginners with no prior Excel knowledge
Intermediate users who want to expand their skill set
Students, professionals, accountants, data analysts, or business managers
Anyone preparing for jobs that require Excel proficiency or certification