Dynamic Data Concepts using Advanced Lookup & Reference functions
Duration: Half day program – 4 hours
Investment: PCKP 400
Objective: Transform your most-troublesome Excel reports and analysis for quick updating and easy analysis. Add dynamism to your standard reports, get explored to extensive usage of these excel functions
Target Audience:
- Anybody and Everyday who is using or wish to use MS Excel for their Reporting and Data Management activities.
Course Outline:
Lookup Methods
The working science behind vlookup and hlookup, Right Approach, Application and Methodology behind using lookups, vlookup and hlookup
Functions-n-Fusion
Effective usage and logical grouping of Index, Match, Choose, Address, Indirect, Offset functions and more…
Being Dynamic
Creating Dynamic Name Ranges, Customizing formula ranges, Dynamic Charts and Summary Dashboards
Case Study
A live Data Management Report creation case-study to implement all of above