Microsoft Excel is the most commonly used analytics, reporting and strategy software. Becoming an expert data analyst requires you to have mastery of advanced Excel skills. This course on Advanced Data Modelling and Analytics Using Excel is aimed at taking your Excel skills to the next level. You will be able to apply complex functions within Excel to manage, manipulate, analyze and visualize data.
Target ParticipantsThis course on Advanced Data Modelling and Analytics Using Excel is aimed at professionals who have basic to intermediate Excel skills and want to advance those skills.
Course DurationOnline 7 Days
Classroom – Based 5 Days
What you will learnBy the end of this course the participants will be able to:
- Master advanced formulas and functions
- Consolidate data, link and export data
- Create sophisticated outputs including tables, charts, and graph
- Use What-If Analysis tools such as Goal Seek, Solver and Scenarios
- Increase interactivity by automating spreadsheets with macros and VBA
- Turn raw data into ‘must make’ decisions using PivotTables and Power Pivots.
Course Fee:
Classroom Training: USD 1150 (Includes tuition, tea refreshments, and lunch. Accommodation and travel not included.)
Virtual Training: USD 700
Registration:Secure your spot today by registering: HERE
Note:
Explore more courses HERE for details on additional courses tailored to your needs.
📞 Contact us at training@devimpactinstitute.com or +254 714349537 | +254 700115705
📍 In-person, in-house & online training available!
