Loading Events
This event has passed.

Indian Institute of Training and Development (IITD)

Presents One Full Day Interactive Upscaling Classroom program on

Advanced Excel

24th Nov 2023; 09:00 am to 05:30 pm at a Hall/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

 

IITD Sr. Expert Trainer & Facilitator:

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,600 + GST 18% per person 1-3 participants.
  • 2,400 + 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.comrajiv@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, Nov 2023, 9 a.m. to 5.30 p.m. in Pune,                Online, 2 pm to 5.30 pm
 

 

*Fees Per Person
Sr Date Mode Program 1 – 3 participants;
    4 & above (₹)
1 22-Nov Classroom Effective Time Management 2500;2300
2 22-Nov Online World Class Manufacturing Practices 3000;2800
3 23-Nov Classroom Leadership and Managerial Skills 3000;2800
4 23-Nov Online Conflict Management & Resolution Skills 3000;2800
5 24-Nov Classroom Advanced Excel 2600;2400
6 24-Nov Online Product Part Approval Process (PPAP) 3600;3400
7 25-Nov Classroom Warehouse, Stores and Inventory Management 3400;3200
8 25-Nov Classroom Change Management 3400;3200
9 25-Nov Online Lean Manufacturing 3000;2800
10 28-Nov Classroom Communication Skills & Email Etiquette 2500;2300
11 29-Nov Classroom 7 QC Tools 2500;2300
*GST 18% Extra

 

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

Working together is success.” ― Henry Ford

 

***********