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.
Don’t miss this upcoming session
Fri – Sat
JUN 15 – JUN 16, 2018
After 40 Hotel, Nairobi