Introduction:
Organisations today have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. Data analysis & representation is indispensable to facilitate decision making and strategy development. It’s very challenging to turn a huge amount of data into useful information without the help of Excel.

The Advanced Excel Course is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, data analysis and formulas.

Demonstration will be based on the MS Office version.

Prerequisites:
Participants should be familiar with basic excel that contains a few functions like sum, max, min etc, formatting like borders, fonts, merge, etc, saving, printing techniques. This program is for anyone who is already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

Program Objectives:
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 analyzing large volumes of data.
Creating MIS reports.
Designing and using templates.
Consolidating and managing data from multiple workbooks.

Course Contents:
Functions
Calculating Data with Advanced Formula
Apply Cell and Range Names
Calculate Data across Worksheets
Use Specialized Functions
Analyze Data with Logical and Lookup Functions
Organizing Worksheet and Table Data
Create and Modify Tables
Format Tables
Use Functions to Calculate Data
Pivots
Analyzing Data Using PivotTables
Slicers
Pivot Charts
Create a PivotTable Report
Filter Data Using Slicers
Analyze Data Using Pivot Charts
Update Workbook Properties
Create a Macro
Edit a Macro
Writing simple VBA codes
Interacting with other application

IITD Sr. Expert Faculty: Highly experienced faculty from Indian Institute of Training & Development will conduct this training. The training sessions will provide participants an opportunity to discuss specific problems with the expert faculty.

Medium: English/ Hindi

Fees and Registration:
Rs. 2,800 + GST 18% per person.
Rs. 2,600 + GST 18% per person for a group of Three to Four participants.
Rs. 2,400 + GST 18% per person for a group of Five or more participants.
Kindly provide details for registration to Email: iitdpune@gmail.com & rajiv@iitdworld.com; Name of the Program, name of the participants, company name, GST no., contact details.
Certification:
Digital Certificate of Participation will be provided to all the participants.