Business Analytics and Modelling using MS Excel
Course Information
2 Days Course
Fee: $1280 (before GST)
Course Dates:
- 13 & 14 March 2025
- 14 & 15 April 2025
- 15 & 16 May 2025
- 09 & 10 June 2025
Time: 9.15am – 5pm
Contact: [email protected]
Venue: Hotel (near MRT)
Note:
- Tea breaks and buffet lunch will be served. Car park coupons are available upon request.
- For 3 pax and above, 10% discount across the board
Course Introduction
Business analytics is the methodology or tool that breaks down past performances to draw the plan for the future and make informed decisions. It essentially comprises of quantitative and statistical analysis, predictive modelling, data mining, multivariate testing, and more.
This course aims to equip managers and business executives with the tools and framework to make data driven decisions. Participants will learn about visualising the insights in a way that’s relatable, making it easier to see what actions needs to be taken and ultimately how this information can be used in the business.
Learning Outcome
- Develop strategic critical thinking and problem-solving skills using data analytics and MS Excel Tools
- Learn to build business models using MS Excel
- Learn to tell a story with data to influence human behaviour and improve the decision-making process
- Build high-performing teams that make better informed decisions as a group rather than as separate individuals
- Become a more strategic leader and decision-maker by understanding the long-term impact your decisions can have on your organisation
Course Outlines
- Topic 1. Intro to business analytics
- Topic 2. Business use case discussion
- Topic 3. Intro to MS Excel and useful functions
- Topic 4. Business Analytics pipeline with Excel
- Topic 5. Business Modelling with Excel
- Topic 6. A use case with Operations analytics using Excel
- Topic 7. A use case with Credit risk modelling with Excel
- Topic 8. Building business dashboard with excel