NEW Advanced e
xcel® Course available now

This comprehensive course covers both the basic and advanced features and functions of Excel. Students will learn, practice, apply, and test their skills in real-world business scenarios, preparing them for certifications and professional careers.

This course provides 100% coverage of the objectives for the following certification exams:

  • TestOut Pro Certified: Microsoft Excel® Advanced
  • MO-200: Microsoft Excel Associate
  • MO-201: Microsoft Excel Expert

This engaging, hands-on training builds confidence through a streamlined learn-by-doing experience that develops basics to advanced skills. Learners will be proficient using Excel features such as nested functions, What-If analysis, PivotTables, and dual-axis charts.

This all-in-one online curriculum includes instruction, practice labs, and certification prep together on one platform. Microsoft Office Specialist certification exams are easier to prepare for with MOS Practice Exams, Domain Practice Labs, and Readiness Reports. Try it out for yourself.

 

AdvExcel Image 3 copy-2

View of 10.2.6 Skills Lab: Create and Modify PivotTables


5.21. Conditional Formatting

View of Conditional Formatting Demonstration