This program is designed for executives, managers who are already familiar with the basics of Microsoft Excel, and would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analysing data, creating MIS reports, and automating various tasks, is also useful for the power excel usages for data or financial modelling and statistical methods using MS-Excel.

Topics Covered

Module 1 Overview of the Basics Module 2 Working with Functions Module 3 Data Validation Module 4 Working with Templates Module 5 Sorting and Filtering Data Module 6 Working with Reports Module 7 More Functions Module 8 What-If Analysis Module 9 Formatting Module 10 Data Forms Module 11 Workbook Sharing and Auditing Module 12 Working with External Data Module 13 Using Macros

Who should attend

Executives, Managers who have already been using Microsoft Excel, but now feel the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently.

Pre-requisites

Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.

What you need to bring

Laptop or Desktop.

Key Takeaways

This Advanced Excel training program will empower the participants to be able to do the following: Performing complex calculations more efficiently, using various Excel functions, Organizing and analysing large volumes of data, Creating MIS reports, Designing and using templates, Consolidating and managing data from multiple workbooks.