Ready to learn more?
Next Cohort: Dec 2-Mar 2
Dec 2-Mar 2
Jan 13 - Apr 13 2021
Feb 3 - May 3 2021
Mar 3 - Jun 3 2021
Apr 7 - Jul 7 2021
Take your knowledge to the next level and become an Excel expert! Learn in-demand skills such as VLOOKUP and Pivot Tables to analyze and summarize data.
This course prepares you for the Excel Expert Microsoft Office Specialist (MOS) certification exam and includes one attempt at the exam.
What You’ll Learn
- Manage advanced workbook options and settings
- Format workbooks with advanced tools
- Generate formulas using conditional functions, logical operations, and data look up functions
- Troubleshoot formulas using advanced error checking tools
- Create charts with advanced functionality
- Manage and define named tables and ranges
- Perform what-if analysis using the Goal Seek tool
- Create and manage pivot tables and pivot charts with advanced functionality
- Enable and create macros