Microsoft Excel: Beginner to Advanced Masterclass

Welcome to your comprehensive guide to mastering Microsoft Excel! Whether you are completely new to spreadsheets or looking to upgrade your everyday skills, this course will take you step-by-step from foundational tools to advanced automation.

📂 Course Materials

📥 Download Exercise Files: Click here to access practice workbooks

🎯 Who Should Take This Course

• Beginners looking for a clear, structured introduction to Excel.

• Intermediate & Everyday Users aiming to increase workplace efficiency and sharpen their data analysis skills.

• Professionals wanting to master modern features like XLOOKUP, Pivot Tables, and basic Macros/VBA.

💡 What You Will Learn

• Foundations: Master the Excel interface, smooth navigation, data entry, and core layout techniques.

• Essential Calculations: Build reliable formulas using relative/absolute references and fundamental functions.

• Data Organization: Sort, filter, and structure raw data efficiently using Tables, Slicers, and Dynamic Array functions.

• Visualizations: Create polished Charts, Sparklines, and visual reports to present key insights.

• Data Analysis: Summarize massive datasets effortless with Pivot Tables and conditional formatting.

• Advanced Automation & Functions: Leverage modern functions like XLOOKUP, database formulas, Goal Seek, and an introduction to Macros & VBA.

⏱️ Course Outline & Timestamps

Module 1: Excel Foundations

• 0:00 – Start & Introduction

• 1:16 – What is Excel?

• 2:40 – Excel Interface Overview

• 9:06 – Search & Help Features

• 11:48 – Navigating & Selecting Cells

• 16:05 – Entering, Replacing, and Deleting Data

• 25:56 – Adjusting Cells

• 30:29 – Calculations, Formulas, and Functions

• 43:31 – Basic Functions

• 50:39 – AutoFill

• 55:05 – Relative & Absolute Cell References

• 1:01:13 – Saving & Sharing Workbooks

• 1:05:11 – Adding & Managing Comments

• 1:07:39 – Inserting Rows and Columns

• 1:10:33 – Cut, Copy, and Paste

• 1:14:35 – Formatting Data with Cell Styles

• 1:20:28 – Managing Worksheets

• 1:25:04 – Hiding Rows and Columns

• 1:26:57 – Creating Custom Views

• 1:30:24 – Reviewing Worksheets

• 1:33:37 – Printing Worksheets

• 1:38:19 – Module Conclusion

Module 2: Intermediate Data Analysis & Visualization

• 1:38:27 – Module Introduction

• 1:38:43 – Creating & Managing Tables

• 1:45:43 – Flash Fill

• 1:49:50 – Introduction to Sorting Data

• 1:56:35 – SORT Function

• 1:59:21 – SORTBY Function

• 2:01:10 – UNIQUE Function

• 2:03:33 – Working with Filters

• 2:09:00 – Using Slicers

• 2:12:42 – Subtotals

• 2:17:51 – Quick Analysis Tool

• 2:19:00 – Inserting Charts

• 2:21:22 – Formatting Charts

• 2:27:19 – Creating Chart Templates

• 2:29:04 – Printing Charts

• 2:30:18 – Using Sparklines

• 2:34:17 – Introduction to Pivot Tables

• 2:42:32 – Pivot Charts

• 2:45:29 – Using Slicers with Pivot Tables

• 2:49:42 – Data Validation

• 3:01:25 – Conditional Formatting

• 3:05:05 – Custom Conditional Formatting

• 3:09:40 – Linking Data across Sheets

• 3:11:28 – Module Conclusion

Module 3: Advanced Formulas & Automation

• 3:12:00 – Module Introduction

• 3:12:14 – Named Ranges

• 3:16:53 – Multiple Named Ranges

• 3:19:23 – Masterclass: XLOOKUP

• 3:27:30 – Data Mining with XLOOKUP

• 3:35:23 – Logical IF Functions

• 3:42:37 – Database Functions

• 3:51:01 – What-If Analysis: Goal Seek

• 3:55:23 – PMT & Data Tables

• 4:00:24 – Introduction to Macros

• 4:07:00 – VBA: IF-THEN Statements

• 4:14:48 – VBA: Do Until Loops

• 4:21:12 – Practical Application: Creating Games with Excel VBA

• 4:28:04 – Course Conclusion