Excel Bootcamp (Self-Paced)
IDCXAM

Self-paced online training with expert support 3 modules

Master essential Excel skills—from formulas and functions to Pivot Tables and VLOOKUP—through hands-on projects and real-world datasets. You’ll progress from beginner to advanced techniques, including macros and advanced data analysis tools, at your own pace.

$549 18 clock hours Live Support Start anytime

This course includes

  • 18 hours of project-based training from experts
  • 61 training videos
  • Learn from a Microsoft Certified Trainer
  • Retake for free within 1 year
  • Access to class recordings (30 days)
  • Verified digital certificate of completion
  • Learn at an accredited institution

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

Advance from beginner to pro with our self-paced Excel Bootcamp. This package includes three Excel courses—Fundamentals, Intermediate, and Advanced:

Read more

Courses & Videos in This Package

Download Syllabus PDF

Unit 1 6 Hours

Excel Level I: Fundamentals (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
Video Training Preview
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 (Self-Paced)
  • 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
Video Training Preview
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 (Self-Paced)
  • 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
Video Training Preview
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
A group of adult learners sits in a classroom, smiling and engaged in a government training session.
A government training instructor in a suit gestures while teaching in front of a whiteboard covered with notes and diagrams.
A person in professional attire holds a Graduate School USA folder, symbolizing participation in government training programs.

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

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

  • Beginner Excel Course
    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.

  • Advanced Excel Course
    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.

  • Excel VBA Course
    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.

  • Excel Level II: Intermediate (Self-Paced)
    6 hours $249

    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.