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.

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 few functions like sum, max, min etc, formatting like borders, fonts, merge, etc, saving, printing techniques.

Participants need to bring their own laptop with MS Office installed, for better understanding and practical experience. The participants may also bring with them live data pertaining to their organisation, so that these can be studied during the workshop, as to how it can be worked out with better solutions.

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, use various Excel functions.
Organizing and analyzing large volumes of data.
Creating MIS reports.
Designing and using templates.
Consolidating and managing data from multiple workbooks.

Contents:
Advanced Formulas and Functions:
Advanced Logical
Advanced Lookup & Reference Functions

What-If Analysis (Data Analysis)
Scenario Analysis
Goal Seek
Data Table

Advanced Conditional Formatting

Advanced Filters

Working on the large size files

Sparklines, Slicers & Timelines

Advanced Pivot Tables
PivotTable calculations
Using slicers in PivotTables
Conditional formatting in PivotTables
Creating PivotCharts

Advanced Charting

Importing data from different sources

Avoid manual data entry – User restrictions with Data Validation

Macros
Recognizing situations ideal for creating macros
How to create a macro by recording, and why this is usually the best way to create a macro
Four ways to run a macro: keystroke shortcut, toolbar button, command, or graphic
Ways to work with macro code (in the language called Visual Basic), created when you record
command sequences
How to use the step method to test a macro slowly
Understanding when you need to add code to a macro and efficient ways to do it
Ways to extend the power of macros to perform tasks you cannot achieve with standard Excel features
Tips & Tricks

Benefits of this Advanced Excel Workshop:
Perform complex calculations more efficiently, using various Excel functions.
Create Dashboards and MIS reports.
Consolidate and manage data from multiple workbooks.
Save Time by Automating Repetitive Tasks with Simple-to-Use Macros

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

Medium: English/ Hindi/ Marathi

Fees & Registration Details:
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 the details of registration on email: iitdpune@gmail.com &/or rajiv@iitdworld.com
For registration, please provide us the following information:
Name of the program:
Name of the participant(s):
Participants email id for sending venue details:
Name of the company:
GST number:

Certification: Participation certificate will be provided to all the participants.