The course is designed to acquire the practical knowledge of MS Excel and its application at workplace using different excel tools, reporting tools (such as Pivot Table/ Charts/ Dashboard etc.) along with different excel formulas (like VLOOKUP, INDEX, MATCH, IF, SUMIF, COUNTIF and so on) , so that the students will be able to fulfill the management's reporting requirements and may lead in their respective career.
The entire course is divided in 3 modules (different levels).
1st module- Focus on Speed using different excel short keys and speedy tools so you can understand the basic terminology in excel and can get the comfort level in using excel.
2nd module- Focus on Logic i.e. Formulae in Excel. This module teaches you how to write Formula in excel. At the end of this module you will be able to write complex logic/ combined formulae in excel to be in line with the reportig requirement. You will also learn various controls available in excel like validation controls, security controls etc.
3rd module- Focus on Reporting & Analysis using Pivot Table , Charts , Dashboard etc. Here you will learn the default reporting capabilities in excel, the different analysis and models using various excel formulae, formatting, pivots, charts all at one place to make the report meaningful.