The MORS Certificate in Advanced Excel Functions for Data Analysts is a five-day course that builds on the first Excel course. Designed for beginner to mid-level analysts, it presents additional Excel capabilities to manipulate data and conduct analyses. The course concludes with a Capstone Project that lets students put together everything they have learned.
Requirements: Computer equipped with Excel 2019 or beyond (anything before 2019 will not work), plus three add-ins that will be used in the course: Data Analysis Toolpak, Solver, and Visual Basic Editor
Objectives:
Through a combination of lectures and hands-on work, participants will learn a variety of different Excel tools and functions including how to:
- Organize, sort, and filter data
- Create PM charts, in-cell charts, and Sparklines
- Perform additional data query
- Create reports and dashboards with Power BI