Microsoft Excel

Microsoft Excel (MS Excel) is a very powerful analytical tool used to consolidate, analyze, and report financial information about the organisation/company. In the module created by us the we train every student advanced techniques to enable him to generate information with increased accuracy, timeliness, and usefulness leading to better decision-making.

In the course duration of six weeks, use of additional analytical tools provided by Excel add-ins are also taught. The student becomes skilled in the use of validation to protect the integrity of the worksheets from other, less experienced users.

He would impress his coworkers by learning how to add functional and eye-catching controls to any worksheet and how to use scenarios and data tables to quickly perform multiple what-if analyses.

He'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. He'll become adept at consolidating and importing data from other sources, and he'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.