Advanced Excel – 3 months

This hands-on program develops the fundamental MS Excel skills essential for a wide variety of roles in finance and related disciplines.

Candidates can design sophisticated spreadsheets, including professional dashboards, and perform complex calculations using advanced Excel features and techniques. Learners have acquired the skills to manage large datasets efficiently, extract meaningful information from datasets, present data and extract information effectively. In addition, learners have mastered the skills needed to validate data and prevent errors in spreadsheets, create automation, apply advanced formulas and conditional logic to help make decisions and create spreadsheets that help forecast and model data. You will learn advanced formula techniques, sophisticated lookups, and pivot tables.