- Basic
- Intermediate
- Advanced
Module 1: Mastering the Excel Interface for Fast and Efficient Navigation
Understanding the Excel Interface: Title Bar, Ribbon, and Worksheet Area
How to Navigate the Excel Ribbon: Tabs, Groups, and Commands Explained
Customizing the Quick Access Toolbar for Faster and More Efficient Workflow
How to Use the Formula Bar and Name Box Effectively in Excel
Understanding Sheet Tabs, Status Bar, and Zoom Controls in Excel
Understanding Excel View Modes: Normal, Page Layout, and Page Break Preview
How to Manage Excel Files: Formats, Saving, and Exporting to PDF
35 Essential Excel Keyboard Shortcuts to Boost Productivity (By Category)
How to Customize Excel Options: General, Formulas, and Advanced Settings
Excel Version Differences Explained: Excel 2016 vs 2019 vs 2021 vs Microsoft 365
Module 2: Understanding Core Excel Terminology and Concepts
Excel Basics Explained: Cells, Ranges, Rows, Columns, Sheets, and Workbooks
Formula vs Function in Excel: What’s the Key Difference?
Understanding Cell References in Excel: Absolute, Relative, and Mixed
Understanding Arrays, Constants, Arguments, Syntax, and Parameters in Excel
How to Use Named Ranges and Structured References in Excel
Understanding Volatile Functions and Circular References in Excel
How to Trace Precedent and Dependent Cells in Excel
Understanding Excel Data Types: Number, Text, Date/Time, Boolean, and Errors
Introduction to Dynamic Arrays and Spill Ranges in Excel
Common Excel Errors Explained and How to Fix Them (#DIV/0!, #VALUE!, #REF!, etc.)
Module 3: Organizing and Managing Data Effectively in Excel
How to Enter Data in Excel: Text, Numbers, Dates, and Common Mistakes
How to Use Fill Handle, Flash Fill, and AutoFill in Excel
Using Copy, Cut, and Paste Special in Excel (Complete Guide)
How to Use Find and Replace in Excel (Including Wildcards)
How to Sort and Filter Data in Excel for Better Analysis
How to Freeze Panes, Split Screens, and Hide or Unhide Data in Excel
Complete Guide to Cell Formatting in Excel (Number, Alignment, Font, Border, Fill)
How to Use Conditional Formatting in Excel (Beginner Guide)
How to Create Data Validation Rules and Dropdown Lists in Excel
How to Manage Worksheets in Excel (Rename, Move, Copy, Group Sheets)
Module 4: Applying Essential Formulas for Automated Calculations
Understanding Excel Operators: Mathematical, Comparison, and Text Operators
Understanding Order of Operations in Excel (PEMDAS) with Examples
How to Use SUM, AVERAGE, COUNT, COUNTA, and COUNTBLANK in Excel
How to Use MAX, MIN, LARGE, and SMALL Functions in Excel
How to Use the IF Function in Excel (Single and Nested IF Explained)
Using AND, OR, and NOT Functions in Excel for Logical Conditions
How to Combine Text in Excel: CONCATENATE, CONCAT, and & Operator
Essential Excel Text Functions: LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER
Working with Dates in Excel: TODAY, NOW, DATE, YEAR, MONTH, DAY, and More
Essential Math Functions in Excel: ROUND, INT, MOD, ABS, CEILING, FLOOR, TRUNC
Module 5: Retrieving and Combining Data with Lookup Functions
How to Use VLOOKUP in Excel (Complete Guide with Examples)
How to Use HLOOKUP in Excel (Horizontal Lookup Explained)
Using INDEX and MATCH in Excel as a Better Alternative to VLOOKUP
How to Use MATCH Function with Different Match Types (0, 1, -1)
How to Perform Two-Way Lookup Using INDEX and MATCH in Excel
Understanding CHOOSE, OFFSET, and INDIRECT Functions in Excel
Using ROW, COLUMN, ROWS, COLUMNS, ADDRESS, and TRANSPOSE in Excel
How to Reference Data from Other Sheets and Workbooks in Excel
How to Create and Use Named Ranges in Excel
Module 6: Analyzing Data with Logical and Statistical Functions
How to Use COUNTIF and COUNTIFS in Excel (With Multiple Criteria)
How to Use SUMIF and SUMIFS in Excel
How to Use AVERAGEIF and AVERAGEIFS in Excel
Using MAXIFS and MINIFS in Excel for Conditional Analysis
How to Handle Errors in Excel Using IFERROR and IFNA
How to Use IFS Function in Excel as a Replacement for Nested IF
How to Use SWITCH Function in Excel for Multiple Conditions
Understanding PERCENTILE, PERCENTRANK, and QUARTILE in Excel
Understanding STDEV, VAR, MEDIAN, and MODE in Excel
Module 7: Cleaning and Transforming Text Data Efficiently
FIND vs SEARCH in Excel: What’s the Difference?
How to Use SUBSTITUTE Function in Excel (Replace All or Specific Text)
How to Use REPLACE Function in Excel (Position-Based Replacement)
How to Format Text, Numbers, and Dates Using TEXT Function in Excel
How to Use TEXTJOIN in Excel to Combine Data with Delimiters
How to Convert Text to Numbers Using VALUE and NUMBERVALUE
How to Extract Data from Text Using MID, FIND, and LEN Functions
Module 8: Summarizing Data with Pivot Tables and Pivot Charts
Preparing Data for Pivot Tables: Requirements and Best Practices
How to Create a Pivot Table in Excel from Scratch
Understanding Pivot Table Fields: Rows, Columns, Values, and Filters
How to Customize Value Field Settings in Pivot Tables
How to Group Dates in Pivot Tables (Day, Month, Quarter, Year)
How to Use Calculated Fields and Calculated Items in Pivot Tables
How to Use Slicers and Timeline in Pivot Tables
How to Create Pivot Charts in Excel
How to Refresh and Change Pivot Table Data Source
Module 9: Visualizing Data with Professional Charts
How to Choose the Right Chart Type in Excel
How to Create Column, Bar, Line, and Pie Charts in Excel
How to Use Scatter, Bubble, and Combo Charts in Excel
How to Create Advanced Charts: Histogram, Waterfall, Funnel, Box Plot
How to Format Chart Elements: Axis, Title, Legend, Data Labels
How to Use Sparklines in Excel (Line, Column, Win-Loss)
How to Create Dynamic Charts Using Tables or Named Ranges
Best Practices for Designing Professional Excel Charts
Module 10: Using Data Tools for Validation and Advanced Analysis
How to Use Text to Columns in Excel (Delimiter and Fixed Width)
How to Remove Duplicates in Excel (Step-by-Step Guide)
Advanced Data Validation in Excel (Dropdowns and Custom Rules)
How to Protect Sheets and Workbooks in Excel
How to Allow Editing in Specific Ranges in Excel
How to Consolidate Data from Multiple Sheets in Excel
How to Use Goal Seek in Excel for What-If Analysis
How to Use Data Tables in Excel (One and Two Variables)
How to Use Scenario Manager in Excel
How to Use Subtotals and Outline Features in Excel
How to Use Conditional Formatting with Custom Formulas
Module 11: Leveraging Dynamic Arrays and Modern Excel Functions
Understanding Dynamic Arrays and Spill Behavior in Excel
How to Use XLOOKUP in Excel (Complete Guide)
How to Use XMATCH in Excel
How to Use FILTER Function with Multiple Conditions
How to Use SORT and SORTBY Functions in Excel
How to Use UNIQUE Function in Excel
How to Generate Sequences Using SEQUENCE Function
How to Use LET Function to Simplify Complex Formulas
How to Create Custom Functions Using LAMBDA in Excel
Using MAP, REDUCE, SCAN, BYROW, and BYCOL in Excel
Combining Dynamic Array Functions for Advanced Solutions
Module 12: Transforming Data with Power Query (ETL Process)
What Is Power Query in Excel and Why It Matters
How to Import Data into Power Query from Multiple Sources
Understanding the Power Query Editor Interface
Key Data Transformation Techniques in Power Query
How to Merge Queries in Power Query (All Join Types Explained)
How to Append Queries in Power Query
How to Use Group By in Power Query for Data Aggregation
How to Add Custom and Conditional Columns in Power Query
Introduction to M Language in Power Query (Syntax and Basics)
Intermediate M Language: Lists, Tables, and Parameters
Best Practices and Reusable Functions in Power Query
Module 13: Building Data Models with Power Pivot and DAX
Power Pivot vs Pivot Tables: What’s the Difference?
How to Load Data into the Excel Data Model
Understanding Table Relationships in Power Pivot
Understanding Star Schema and Snowflake Schema in Excel
Basic DAX Functions: SUM, COUNT, DIVIDE, RELATED
Intermediate DAX: CALCULATE, ALL, FILTER, VALUES Explained
Row Context vs Filter Context in DAX (Core Concept)
Advanced DAX Time Intelligence Functions Explained
Measures vs Calculated Columns in Power Pivot
How to Create KPIs and Hierarchies in Power Pivot
Module 14: Automating Workflows with Macros and VBA
What Are Macros and VBA in Excel? (Beginner Guide)
How to Record Macros in Excel (Absolute vs Relative Reference)
Understanding the VBA Editor (VBE) Interface
Working with Variables and Data Types in VBA
Using Conditional Statements in VBA (If and Select Case)
Understanding Loops in VBA (For, Do While, Do Until)
How to Work with Cells and Ranges Using VBA
How to Control Worksheets and Workbooks with VBA
Using MsgBox and InputBox in VBA
How to Create UserForms in Excel VBA
Error Handling in VBA (On Error and Debugging Techniques)
How to Create User-Defined Functions (UDF) in Excel
Debugging VBA Code (Breakpoints, Step Into, Watch Window)
Module 15: Designing Interactive Dashboards and Professional Reports
Advanced Conditional Formatting Techniques in Excel
Custom Number Formatting for Better Data Presentation
How to Build Interactive Excel Dashboards Step-by-Step
How to Use the Camera Tool in Excel
Using Form Controls (Dropdown, Slider, Buttons) in Excel
How to Prepare Print-Ready Reports in Excel
Using Themes and Styles for Consistent Design
How to Protect and Secure Excel Dashboards
Module 16: Optimizing Performance, Auditing, and Integration
Why Excel Files Become Slow and How to Fix Them
Excel Performance Optimization Techniques (Best Practices)
How to Trace Precedents and Dependents in Excel
How to Use Evaluate Formula for Step-by-Step Debugging
Using Watch Window and Error Checking Tools in Excel
How to Use Show Formulas Mode in Excel
How to Use Solver Add-in for Optimization Problems
How to Use Analysis ToolPak for Statistical Analysis
How to Integrate Excel with Word, PowerPoint, and Teams
Using Excel as a Data Source for Power BI
Best Practices for File Management and Collaboration in Excel