Aim
This course gives advanced excel skills with participants being able to apply complex functions within Excel to manage, manipulate, analyze and visualize data. 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.
Course Objectives
At the end of this training you 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 PowerPivots.
target Participants
This course is aimed at professionals who have basic to intermediate Excel skills and want to advance those skills.
Course Duration
5 Days
Topics are:
Data Validation; Referencing in Excel; Working with Structured tables; Formulas and Functions; What If Analysis; Pivot Tables and Pivot Charts; Excel Macros; Charts and Visualizations; Working External Data
Detailed Course Description
For detailed course description and content write to training@ic4rd.org
Registration
To register, please download the application form below and submit to training@ic4rd.org
Training topics can be requested by writing to training@ic4rd.org
Cost: USD 750 for individuals; 650 for groups above 10 participants.
Training fee includes conference package (training venue, tea/coffee, lunch, snacks, wifi etc)