Detailed course of 18 classes each 60 mins of length via online sessions with more stress on industry related topics for microsoft exceland its application.

1) This will cover both basic and advanced excel methods for performing various task ( for e.g. lookups, Unique values, Cleansing functions, Report Designing etc.)

2) This will also cover Pivot tables in details.

3) Charts and Graphs using sample data

4) Summarization using Advanced formulas 

5) Drawing Data Insights and Data Analysis

6) Industry specific examples

7) How can we automate maximum portion of reporting process.

8) Error handling of bulk data.

9) Time and date calulations. 

10) How to build reports as per Query of client.

11) Import data from CSV files or Text files.

12) Identify repeated occuring tasks that can be automated by formulas.

13) An Introduction to Macros. Purpose of Macros.

14) My First automated task.

15) Table and Named Range concept in Excel

16) Formulas approach while working with mutiple Tables / Sheets

17 Introdution and details of most common objects of Microsoft Excel object Model (No Programming Experience required).