Excel Bootcamp Online (Self-Paced)

Self-paced online training with expert support 3 modules

Progress from beginner to advanced in Microsoft Excel. Learn functions, formulas, Pivot Tables, macros, and time-saving techniques.

$549 18 clock hours Live Support Start anytime

This course includes

  • 18 hours of project-based training from experts
  • 62 training videos
  • Learn from a Microsoft Certified Trainer
  • 1-on-1 bonus training
  • Proprietary workbooks included
  • Supplemental refresher video suite
  • Verified digital certificate of completion

This course is self-paced. For live online or in-person instruction, take the Excel Bootcamp.

This self-paced Excel Bootcamp takes you from complete beginner to advanced user, packaging three courses into one convenient bundle. You'll start with Excel Fundamentals, where you'll get comfortable with the essentials: calculations, basic functions, charts, formatting, and printing. Intermediate Excel builds on that foundation, introducing more complex functions such as VLOOKUP and SUMIFS, teaching you how to summarize data with PivotTables, and showing you how to sort and filter databases, split text, and join it back together.

The final course is where your skills really expand. Advanced Excel covers powerful database functions such as INDEX and MATCH, walks you through creating basic macros, and introduces What-If Analysis tools like Goal Seek and Data Tables. Because the bootcamp is fully self-paced, you can work through each level on your own schedule, moving as quickly or gradually as you need.

Read more

Courses & Videos in This Package

Download Syllabus PDF

Unit 1 6 Hours

Excel Level I: Fundamentals Course Online (Self-Paced)

In this beginner Excel workshop, you’ll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This basic Excel class is perfect for those with limited experience looking to expand their proficiency.

  • Become familiar with the interface and data entry
  • Learn essential formulas and functions
  • Format and print your work
  • Create charts, including line, column, and pie charts
  • Learn tips and tricks for easy workbook management
  • Review key concepts in a final project
Lesson 1: Introduction
Lesson 2: Formulas
Lesson 3: Formatting
Lesson 4: Charts & Tables
Lesson 5: Workbook Management

Unit 2 6 Hours

Excel Level II: Intermediate Course Online (Self-Paced)

Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.

  • Learn to split and join text, apply data validation, and create named ranges
  • Use database functions such as VLOOKUP and HLOOKUP
  • Write logical formulas using AND, OR, and IF functions
  • Create Pivot Tables to efficiently summarize and analyze large datasets
  • Apply statistical functions such as RANK, COUNTIFS, and SUMIFS
  • Build advanced combo charts by combining multiple chart types
  • Reinforce key concepts through a guided final project

Lesson 5: Workbook Management
Lesson 1: Worksheet Management
Lesson 2: Working with Text
Lesson 3: Cell Ranges
Lesson 4: Database Functions
Lesson 5: Pivot Tables
Lesson 6: Logical Functions
Lesson 7: Statistical Functions
Lesson 8: Advanced Charts

Unit 3 6 Hours

Excel Level III: Advanced Course Online (Self-Paced)

Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.

  • Cell management including cell locking, auditing,  and hot keys
  • Special formatting for calculating dates
  • Use advanced functions and advanced analytical tools 
  • Record macros and relative reference macros for ad hoc reporting
Lesson 1: Cell Management
Lesson 2: Special Formatting
Lesson 3: Advanced Functions
Lesson 4: What If Analysis
Lesson 5: Advanced Analytical Tools
Lesson 6: Advanced Database Functions
Lesson 7: Introduction to Macros
Lesson 8: Dynamic Arrays

Related Courses: Compare to Excel Bootcamp Online (Self-Paced)

These related courses share skills and topics with Excel Bootcamp Online (Self-Paced). Select up to two and tap Compare selected courses to view a side-by-side comparison.

  • Excel Level I: Fundamentals Course Online (Self-Paced)
    6 hours $249

    Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.

    How does it compare?

    Take Excel Level I: Fundamentals first if you're new to Excel; it covers the interface, basic formulas, formatting, and charts that this bootcamp builds on before moving into VLOOKUP, PivotTables, and macros.

  • Excel Level III: Advanced Course Online (Self-Paced)
    6 hours $249

    Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.

    How does it compare?

    Choose Excel Level III: Advanced Course Online (Self-Paced) if you already have intermediate skills and want to focus on nested IFs, INDEX-Double MATCH, pivot charts, and macro recording rather than starting from the basics this bootcamp covers.

  • Excel Programming with VBA
    12 hours $549

    In this hands-on course, learn how to automate repetitive tasks in Microsoft Excel using VBA programming. Develop macros, custom commands, and new worksheet functions to streamline your Excel workflow and increase productivity.

    How does it compare?

    Unlike this bootcamp, Excel Programming with VBA focuses on writing code to automate Excel with variables, loops, logic statements, user forms, and error trapping rather than teaching general spreadsheet skills.

  • Excel for Data Analytics Course Online (Self-Paced)
    18 hours $595

    Improve your data analysis skills with our Excel for Data Analytics class. Learn essential functions, formulas, and advanced techniques like Pivot Tables and VLOOKUP. Gain hands-on experience and optimize your workflow for efficient data analysis.

    How does it compare?

    Excel for Data Analytics Course Online (Self-Paced) is a shorter path to Excel skills aimed specifically at data analysis workflows, while this bootcamp covers a broader progression from beginner basics through macros and What-If Analysis.