MS Excel Masterclass

Objective -    

The objective of the Certification Course is as below:   

1. Getting practical knowledge of MS Excel.   
2. Developing skill sets to work with various tools of MS Excel.   
3. Examples based on the prominent issues being or likely to be faced by the professional.
4. Getting ready to be a thorough skilled professional.

Approach – 

Live sessions on a weekly basis (Friday and Saturday), considering our speakers’ and the participants’ daily work responsibilities. Each day will consist of 2 sessions of roughly 1.5-2 Hours each.    

Hours – 18 to 20 hours 

Certification – Certificate of Pursuance to be handed over upon completion of course. 

Coverage -

1. Basic Level - Fundamentals of MS Excel, Basic Excel Functions, Managing the Work Area, Formatting Data, Images & Shapes in Worksheets, Basic Charts, Print and Excel Worksheet, Templates.
2. Intermediate Level - Lists, DSUM(), DAVERAGE(), DCOUNT(), Data Validation, Pivot Tables, Power Pivot, Large Sets of Excel Data. 
3. Advanced Level - Conditional Functions, Lookup function, Text-based functions, Auditing a Spreadsheet, Protecting Excel Sheets & Workbooks. 
4. Superior Level - Data formats and functions, Top hacks to increase productivity, MS Excel Macros and VBA Tab, Data Analysis.