Prepare for the Microsoft Excel Specialist exam at your own pace with this comprehensive self-paced program. You’ll begin by mastering the basics of Excel, then progress to more advanced functions and features, building the skills needed for exam success. Throughout the course, you’ll focus on practical applications, making sure you're ready to take on real-world Excel challenges.
The program includes three Excel courses (18 hours total), two hours of private tutoring, and the Microsoft Excel Specialist exam with a free retake. Additional video resources will further support your exam preparation. You can also choose to replace the exam with an extra hour of private tutoring if preferred.
What You Will Learn
- Calculations, basic functions, graph creation, formatting, and printing
- Functions like VLOOKUP and SUMIFS
- Summarizing data with PivotTables
- Sorting and filtering databases
- Working with text: splitting, joining, and using drop-down menus
- Advanced lookup functions such as INDEX and MATCH
- Creating basic macros
- Using What-If Analysis for Goal Seek and Data Tables
This program is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
