Advance MS-Excel 2007 / 2010

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.