Excel Specialist Certification (Self-Paced)
IDCVRN

Self-paced online training with expert support Certificate with 3 courses

Master key Excel skills such as formulas, functions, PivotTables, and data analysis tools at your own pace. Gain practical experience through real-world projects, and prepare for the Microsoft Excel Specialist Exam with expert guidance and hands-on exercises.

$959 19 clock hours Live Support Start anytime

This program includes

  • 19 hours of project-based training from experts
  • 62 training videos
  • Excel Specialist exam with retake
  • Answers from real instructors
  • Retake for free within 1 year
  • Access to class recordings (30 days)
  • Verified digital certificate of completion
  • Learn at an accredited institution

Prepare for the Microsoft Excel Specialist exam with this comprehensive self-paced program. This course covers essential Excel skills, from the basics to advanced functions, ensuring you're fully equipped to tackle the exam. You'll benefit from 18 hours of instructional content across three Excel courses, along with two hours of private tutoring to reinforce your learning.

The program also includes the Microsoft Excel Specialist exam with a free retake and additional exam prep videos. You have the flexibility to replace the exam with one extra hour of private tutoring if needed. Choose from preset course dates or customize your schedule for maximum convenience.

Read more

We also offer an Excel Expert Certification package, which includes the classes above, four hours of private training, and the Excel Expert Exam with a free retake.

Courses & Videos in This Certificate Program

Download Syllabus PDF

Unit 1 6 Hours

Beginner Excel Course (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

Intermediate Excel Course (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
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

Advanced Excel Course (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
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

Exam

This certificate includes this certification exam as well as the exam proctoring. The exam is optional.

Microsoft Office Specialist: Excel Expert Exam

The Microsoft Office Specialist: Excel Expert (Office 2019) exam is designed for experienced Excel users who possess advanced skills in data analysis, automation, and dynamic reporting. This certification is ideal for financial analysts, data professionals, and business managers looking to validate their expertise in complex formulas, macros, and interactive dashboards.

Exam details
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 Specialist Certification (Self-Paced)

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

  • Excel Expert Certification Online
    21 hours $1,149

    Master advanced Excel skills including PivotTables, VLOOKUP, macros, and data analysis techniques. Prepare for the Microsoft Excel Expert Certification with hands-on training and step-by-step projects designed to build real-world proficiency.

  • Microsoft Master Certification Online
    56 hours $2,599

    Gain advanced skills in Excel, Word, PowerPoint, and Outlook through hands-on projects and expert-led instruction. You’ll gain proficiency in data analysis, document formatting, presentation design, and email management—preparing you for Microsoft Office Specialist certification exams.

  • Excel Bootcamp
    18 hours $549

    Become proficient in Microsoft Excel and go from beginner to pro with this hands-on bootcamp. Learn functions, Pivot Tables, macros, and time-saving techniques to conquer all the key skills needed to excel in Excel.

  • 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.