Skip to main content
MindLeap AI MindLeap AI
Advanced Level

Microsoft Excel - Excel from Beginner to Advanced

★ 4.8 (300 learners) 60 hrs total 20 modules
Microsoft Excel
Only 6 seats left · Next batch starts 12 Sept 2026
Download Curriculum
60 hrs
of content
20 modules
in curriculum
16 projects
hands-on builds
Advanced
difficulty

Curriculum covers

Frameworks you'll master

1 tools & frameworks
Microsoft Excel

Course Curriculum

20 modules · 60 hours · 24 live sessions

Microsoft Excel Fundamentals 1 sessions
  • Microsoft Excel Fundamentals
  • Launching Excel
  • Microsoft Excel Startup Screen
  • Introduction to the Excel Interface
TIP Hide Excel Ribbon 1 sessions
  • TIP Hide Excel Ribbon
  • TIP Customizing the Excel Quick Access Toolbar
  • More on the Excel Interface (Workbook and Status Bar)
  • Understanding the Structure of an Excel Workbook
Saving an Excel Document 1 sessions
  • Saving an Excel Document
  • Opening an Existing Excel Document
  • Common Excel Shortcut Keys
  • Entering and Editing Text and Formulas
Entering Text to Create Excel Spreadsheet Titles 1 sessions
  • Entering Text to Create Excel Spreadsheet Titles
  • Working with Numeric Data in Excel
  • Entering Date Values in Excel
  • Working with Cell References
Creating Basic Formulas in Excel 1 sessions
  • Creating Basic Formulas in Excel
  • Relative Versus Absolute Cell References in Formulas
  • Understanding the Order of Operation
  • Working with Basic Excel Functions
The structure of an Excel Function 1 sessions
  • The structure of an Excel Function
  • Working with the SUM() Function
  • Working with the MIN () and MAX () Functions
  • Working with the AVERAGE() Function
Working with the COUNT() Function 1 sessions
  • Working with the COUNT() Function
  • Adjacent Cells Error in Excel Calculations
  • Using the AutoSum Command
  • Excel's AutoSum Shortcut Key
Using the AutoFill Command to Copy Formulas 1 sessions
  • Using the AutoFill Command to Copy Formulas
  • Modify an Excel Worksheet
  • Working with Font Formatting Commands
  • Changing the Background Color of a Cell
Adding Borders to Cells 1 sessions
  • Adding Borders to Cells
  • Excel Cell Borders Continued
  • Formatting Data as Currency Values
  • Formatting Percentages
Using Excel's Format Painter 1 sessions
  • Using Excel's Format Painter
  • Creating Styles to Format Data
  • Merging and Centering Cells
  • Using Conditional Formatting
Editing Excel Conditional Formatting 1 sessions
  • Editing Excel Conditional Formatting
  • Inserting Images and Shapes into an Excel Worksheet
  • Inserting Images
  • Inserting Excel Shapes
Formatting Excel Shapes 1 sessions
  • Formatting Excel Shapes
  • Working with Excel SmartArt
  • Create Basic Charts in Excel
  • Creating an Excel Column Chart
Working with the Excel Chart Ribbon 1 sessions
  • Working with the Excel Chart Ribbon
  • Adding and Modifying Data on an Excel Chart
  • Formatting an Excel Chart
  • Moving a Chart to another Worksheet
Working with Excel Pie Charts 1 sessions
  • Working with Excel Pie Charts
  • Microsoft Excel Charts Quick Guide
  • Printing an Excel Worksheet
  • Viewing your Document in Print Preview
Changing the Margins, Scaling and Orientation 1 sessions
  • Changing the Margins, Scaling and Orientation
  • Excel Worksheet Margins
  • Working with Page Layout View
  • Adding Header and Footer Content
Printing a Specific Range of Cells 3 sessions
  • Printing a Specific Range of Cells
  • Intro to Excel Templates
  • Opening an Existing Template
  • Creating a Custom Template
  • Understanding Excel List Structure
  • Sorting a List Using Single Level Sort
  • Sorting a List Using MultiLevel Sorts
  • Using Custom Sorts in an Excel List
  • Filter an Excel List Using the AutoFilter Tool
  • Creating Subtotals in a List
  • Format a List as a Table
  • Using Conditional Formatting to Find Duplicates
  • Removing Duplicates
  • Introduction to Excels Function: DSUM()
  • Excel DSUM Function Single Criteria Continued
  • Excel DSUM Function with OR Criteria
  • Excel DSUM Function with AND Criteria
  • Excel Function: DAVERAGE()
  • Excel Function: DCOUNT()
  • Excel Function: SUBTOTAL()
Excel Data Validation 4 sessions
  • Understanding the Need for Excel Data Validation
  • Creating an Excel Data Validation List
  • Excel Decimal Data Validation
  • Adding a Custom Excel Data Validation Error
  • Dynamic Formulas by Using Excel Data Validation Techniques
  • Importing Data into Microsoft Excel
  • Importing Data from Text Files
  • Importing Data from Microsoft Access
  • NEW VERSION Import Data from Text Files into Excel
  • NEW VERSION Import Data from a Database into Excel
  • Microsoft Excel Legacy Import Options for New Excel Versions
  • Exporting Data to a Text File
  • Understanding Excel PivotTables
  • Creating an Excel PivotTable
  • Modifying Excel PivotTable Calculations
  • Grouping PivotTable Data
  • Formatting PivotTable Data
  • Modifying PivotTable Calculations
  • Drilling Down into PivotTable Data
  • Creating Pivot Charts
  • Filtering PivotTable Data
  • Filtering with the Slicer Tool
  • Introduction to Excel Power Pivot
  • Why PowerPivot?
  • Activating the Excel PowerPivot AddIn
  • Creating Data Models with PowerPivot
  • Excel Power Pivot Data Model Relationships
  • Creating PivotTables based on Data Models
  • Excel Power Pivot KPIs
Working with Large Sets of Excel Data 4 sessions
  • Using the Freeze Panes Tool
  • Grouping Data (Columns and/or Rows)
  • Print Options for Large Sets of Data
  • Linking Worksheets (3D Formulas)
  • Consolidating Data from Multiple Worksheets
  • Microsoft Excel Managing Large Excel Datasets Quick Guide
  • Working with Excel Name Ranges
  • Advantages and Disadvantages of Excel Name Ranges
  • Editing an Excel Name Range
  • Using Excel's IF() Function
  • Excel's IF() Function with a Name Range
  • Nesting Functions with Excel
  • Nesting Excels AND() Function within the IF() Function
  • Using Excel's COUNTIF() Function
  • Using Excel's SUMIF() Function
  • Using Excel's IFERROR() Function
  • Microsoft Excel VLOOKUP() Function
  • Microsoft Excel HLOOKUP() Function
  • Microsoft Excel INDEX() Function
  • Microsoft Excel MATCH() Function
  • Microsoft Excel INDEX() and MATCH() Function Combined
  • Microsoft Excel INDEX() and MATCH() Function Combined Continued
  • Creating a Dynamic HLOOKUP() with the MATCH() Function
  • Using Excel's LEFT(), RIGHT() and MID() Functions
  • Using Excel's LEN() Function
  • Using Excel's SEARCH() Function
  • Using Excel's CONCATENATE() Function
  • Microsoft Excel Adv. Functions and Formulas Quick Guide
New Excel Functions for Excel 2019 and Microsoft 365 Excel Editions 3 sessions
  • Introduction to New Excel Functions
  • Microsoft Excel 365 FILTER() Function
  • Microsoft Excel 365 SORT() Function
  • Microsoft Excel 365 UNIQUE() Function
  • Microsoft Excel Dynamic FILTER() Function with Data Validation
  • Microsoft Excel 365 XLOOKUP() Function
  • EXERCISE: Dynamic Employee Order List
  • Microsoft Excel 365 SWITCH() Function
  • TRUE Expressions with Microsoft Excel 365 SWITCH() Function
  • Microsoft Excel 365 TEXTJOIN() Function
  • TEXTJOIN() Function with Criteria
  • Microsoft Excel 365 TEXTSPLIT() Function
  • Tracing Precedents in Excel Formulas
  • Tracing Dependents in Excel Formulas
  • Working with the Watch Window
  • Showing Formulas
  • Protecting Specific Cells in a Worksheet
  • Protecting the Structure of a Workbook
  • Adding a Workbook Password
  • Working with Excel's Goal Seek Tool
  • Working with Excel's Solver Tool
  • Building Effective Data Tables in Excel
  • Creating Scenarios in Excel
Automating Repetitive Tasks in Excel with Macros 1 sessions
  • Understanding Excel Macros
  • Activating the Developer Tab in Excel
  • Creating a Macro with the Macro Recorder
  • Editing a Macro with VBA
  • Creating Buttons to Run Macros
  • Understanding the why and how Excel Macros
  • Introduction to Project #1: Inserting and Formatting Text
  • Activating the Excel Developer Tab
  • Running a Microsoft Excel Macro
  • Project #1: Running an Excel Macro with a Button
  • Create a Custom Button Using Excel Shapes
  • Adding the Excel Macro to the Quick Access Toolbar
  • Project #1: Editing the VBA Recorded by the Macro Recorder
  • Save a Workbook with a Macro/VBA Code
  • Practical Uses of Excel Macros
  • Intro to Excel VBA Concepts
  • Intro to Excel VBA Object Oriented Programming Concepts
  • The Visual Basic Editor (VBE)
  • Introduction to the Excel VBA Immediate Window
  • Excel VBA Modules
  • Creating an Excel VBA Procedure
  • Adding Code to a VBA Procedure
  • Including Excel VBA Comments
  • Excel VBA MSGBOX Function
  • Excel VBA MsgBox Microsoft Help Information
  • Understanding and working with Excel VBA Variables
Download Full Curriculum

Batch Schedule

⚡ Seats filling fast — only 6 remaining across all batches

Available Batches
Batch Type Schedule Duration Next Start Date Availability
Weekend Sat & Sun, 10am–1pm 10 weeks 12 Sept 2026 Available
Weekday Mon–Fri, 7–9pm 8 weeks 14 Sept 2026 Available
Fast-track Mon–Sun, 6 hours/day 2 weeks 21 Sept 2026 Available

Ready to Get Started?

Download the curriculum to see every module, batch dates and fees. Book a free 30-minute session with our advisors to get your questions answered.

Book Free Demo

Download the Full Curriculum

See every module, capstone project, and tool covered — free, instant access.

Similar Courses You Might Like

View Course →
Microsoft Azure
microsoft azure

Azure Kubernetes Service with Azure DevOps and Terraform

★ 4.8 · 300 learners · Intermediate
Starts 8 Aug 2026 · ~1–2 months
View Course →
Microsoft Azure
microsoft azure

Microsoft Certified - Security, Compliance & Identity Fundamentals - SC-900

★ 4.8 · 300 learners · Beginner
Starts 15 Aug 2026 · ~1–2 months
View Course →
Microsoft Azure
microsoft azure

Microsoft Certified Azure Administrator Associate (AZ-104)

★ 4.8 · 300 learners · Intermediate
Starts 22 Aug 2026 · ~1–2 months
View Course →
Microsoft Azure
microsoft azure

Microsoft Certified Azure AI Engineer Associate (AI-102)

★ 4.8 · 300 learners · Intermediate
Starts 29 Aug 2026 · ~1–2 months
Book Free Demo