Menu
Advanced MS Excel for Business Modelling
Excel remains the main tool for financial analysis, and advanced skills save time and improve accuracy. This programme trains accountants and finance teams in macros, data visualisation, dashboards and advanced formulas for business modelling. Focus Area: Macros, data visualization, dashboard creation, and advanced financial formula
Features
- Advanced formulas and lookup functions
- Introduction to macros for automation
- Interactive dashboards and charts
- Practice files and ready-to-use templates
- Certificate of Training on completion
- Live, interactive online sessions with discussion and group work
Target audiences
- Accountants & Finance Teams
Requirements
- Intermediate Excel skills
- Laptop with a recent version of Microsoft Excel
- Interest in automating routine finance tasks
- Laptop, tablet or smartphone with a stable internet connection
- Ability to attend all five days of live online sessions
Curriculum
- 4 Sections
- 15 Lessons
- 7 Hours
Expand all sectionsCollapse all sections
- Advanced Formulas4
- Data Analysis Tools4
- Macros and Automation4
- Dashboards and Visualisation3
FAQs
No. Macros are introduced by recording and simple editing.
A recent desktop version of Excel is recommended, as some features are not available in older versions or online editions.
The programme runs for 7.5 hours (5 days) and is delivered online.
Yes. Participants who complete the programme receive a Certificate of Training in Advanced MS Excel for Business Modelling.
The programme is designed for Accountants & Finance Teams.
Instructor
