Indian Institute of Training and Development (IITD)

Presents One Full Day Interactive Classroom program on

Advanced Excel

15th Sept 2023; 09:00 am to 05:30 pm at a Business Hotel, Pune

Certificates will be issued to the participants!

 

Introduction:

Organizations 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 to 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 MS Office version.

 

Prerequisites:

Participant should familiar with basic excel that contain 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, 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.

 

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

 

Medium: English/ Hindi/ Marathi

 

Fees:

• 2,400 + GST 18% per person 1-3 participants.
• 2,200 + GST 18% per person for a group of 4 or above participants.

Fees include participation, course material (Hard copy), Breakfast, Lunch and tea / coffee with cookies.

 

Registration Details:

Please write to email: iitdpune@gmail.com; rajiv@iitdworld.com with

Name of the program, participant names, mobile nos, company name, GST number.

 

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

 

Registrations open till 2 days prior to the program date.

Seats are limited up to 20 pax, registration is on a first-come, first-served basis.

 

Customised In-house Workshops:

We would be pleased to conduct specific in-house pan-India 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.

 

We look forward to your active participation and nominations.

 

With warm regards,

 

Shilpa Kulkarni/ Rajiv Kolhe

Mob: 7666256426/ 9822089898

Indian Institute of Training and Development (IITD)

Tel: 91 20 4120 3985

Website: www.iitdworld.com

Encl: Training Calendar Classroom

 

IITD CLASSROOM Training, Sept 2023@Business Hotel, Pune, 9 am to 5.30 pm
			*Fees Per Person
Sr	Date	Program	1 – 3 participants;
			4 & above (₹)
1	07-Sep	Communication Skills & Interpersonal Relations	2400;2200
2	07-Sep	Total Productive Maintenance (TPM)	2400;2200
3	08-Sep	Statistical Process Control (SPC)	2400;2200
4	08-Sep	Supply Chain Management (SCM)	2400;2200
5	09-Sep	Effective Time Management	2400;2200
6	09-Sep	Workplace Harassment Awareness PoSH	2400;2200
7	13-Sep	5-S Training & Implementation	2400;2200
8	14-Sep	Supervisory Skills	2400;2200
9	15-Sep	Advanced Excel	2400;2200
10	16-Sep	Lean Manufacturing	2400;2200
11	16-Sep	Leadership & Managerial Skills	2400;2200
12	23-Sep	Emotional Intelligence (EI)	2400;2200
13	26-Sep	7 QC Tools	2400;2200
		*GST 18% Extra

 

 “Coming together is the beginning. Keeping together is progress.

Working together is success.” ― Henry Ford

 

***********