In this course, our experts will walk you through important hands-on experiences on how to segment your data for further reporting using VLOOKUP, and how to present the most relevant data with dynamic pivot reports and charts that inspire management action.
In this module you will learn:
- Data cleansing techniques
- Prepping your data for analysis
- Data mining and analysis techniques
- Visual presentation of data (charts and pre-built conditional formatting)
A good foundation in Excel is essential for this course. Participants should not just be regular users of Excel but must be able to write basic formulae taught in the foundational level principles in the previous module.
What you get:
12 hours instructor-led, practical sessions
Comprehensive study materials
After-course instructor support
Certificate of participation
Do you have 8 or more staff who could benefit from this program?