Certificate in Excel Functions for Data Analysts II

Starts:  Oct 7, 2024 10:00 (ET)
Ends:  Oct 11, 2024 18:00 (ET)
Associated with  MORS Community

The MORS Certificate in Excel Functions for Data Analysts II 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


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
Event Image


Tina Yan