About the Course
This class is applicable for participants who want to learn advanced excel in details. Class is aiming to professional people who work in corporate and looking to learn advanced excel which can be used in their day to day activities. This workshop will enhance efficiency and power use of Excel in daily activities. It will improve productivity and speed of work.
Topics CoveredIntroduction to new version and Ribbon Interface
References and 3d formulas in excel
If, And, Or, Nested If
Lookup functions like Vlookup, Match, Iferror, Index
Data validation and Protection
Date, Text, Financial and Database Functions
Sort, Filter, Subtotal, Pivot, Charts
What if analysis like goal seek, scenario, data table
Tracking and sharing concept
Recording and running macros
and other user required functions and features and many more...
Who should attendAny person who has basic and intermediate understanding of excel and looking for advanced functions and features in excel. Workshop can be customized as per need of participation
Pre-requisitesSome basic knowledge about excel but not necessary
What you need to bringLaptop, Notepad, Pen and pen drive to carry and copy training material (all optional)"
Key TakeawaysFair idea about interface
All useful shortcut keys knowledge
Usage of right tool and function in urgent scenario and situation
Analysis and calculation techniques of Excel
Power tips and tricks
Recording and running of macros