Indian Institute of Training and Development (IITD)

Presents One Full Day Interactive Training on

Advanced Excel

Date: 25th April 2023 (Tuesday)

Timing: 09:30 am to 05:30 pm

Venue: Hall/ Hotel in Pune/ PCMC

Please send nomination(s) to EM: iitdpune@gmail.com; rajiv@iitdworld.com

Certificates will be issued to the participants!

 

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.

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

Contents:

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 program. The training sessions will provide participants an opportunity to discuss specific problems with the expert faculty.

Medium: English/ Hindi/ Marathi 

Fees:

• 2,500 + GST 18% per person.
• 2,300 + GST 18% per person for a group of Three to Four participants.
• 2,100 + GST 18% per person for a group of Five or More participants.

 

Registration Details:

Registrations will be accepted only via email. kindly provide us the below given details on email: iitdpune@gmail.com & rajiv@iitdworld.com

• Name of the program :
• Names of the participants :
• Participant’s email id :
• Name of the company :
• GST number :

Certification: Participants shall be awarded a certificate of participation from IITD. 

Since seats are limited, registration is on a first-come, first-served basis. 

Customised In-house Workshops:

We would be pleased to conduct specific in-house workshops for your organisation, if you have adequate number of participants.

For enquiries related to corporate training or group nominations, please reach out to us. 

With warm regards,

Rajiv Kolhe

Mob: 8308459802/ 9822089898

Tel: 91 20 4120 3985

E-mail: iitdpune@gmail.com, rajiv@iitdworld.com

Website: www.iitdworld.com