Course Objectives

At the end of the training the participants would learn/use/acquire the following techniques/knowledge:

•    Excel Advancements – some amazing features incorporated only in last 5 years
•    Using Lookup & reverse Lookup techniques – easy demo of VLOOKUP, HLOOKUP, INDEX and MATCH    
•    Advanced Data Sorting and Filtering techniques
•    Generating Pivot Tables and Charts from complex datasets, instantly                
•    Implementing Slicers and Sparklines to build interactive dashboards
•    Exploring Data Validation techniques and creating dynamic lists
•    Using ‘What-If-Analysis’ and Data representation techniques

Scope of Learning:

• User able to manage data independently

• User able to do reports (eg: Financial, Banking, Insurance, Pharmaceutical, Retail, Educational, small shops etc)

• User will become data analyst

• User will able to do MIS reports

• Maximum organization will use the excel

• It requires day to day activities to manage & analyse the data

• High impact, proven training – 30000+ professionals trained globally

• Experienced, expert instructors – Our Instructors come with a rich, 10+ years of industry experience.

For any query give a miss call:

08587999769