Loading Events
This event has passed.

Indian Institute of Training and Development (IITD)

Presents One Full Day Interactive Upscaling Classroom program on

Advanced Excel

14th Oct 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

 

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, Oct 2023@Hall/Business Hotel, Pune,

9 am to 5.30 pm

      *Fees Per Person
Sr Date Program 1 – 3 participants;
    4 & above (₹)
1 10-Oct Production Planning and Control (PPC) 3000;2800
2 11-Oct Geometric Dimensioning & Tolerancing (GD&T) 3400;3200
3 12-Oct Emotional Intelligence (E.I) 2500;2300
4 13-Oct Personal Effectiveness Programme (PEP) for Secretaries/EA 2500;2300
5 14-Oct Advanced Excel 2600;2400
6 14-Oct How to conduct Domestic Enquiry 3000;2800
7 17-Oct Hydraulics and Pneumatics 3400;3200
8 18-Oct Purchase Management and Purchase Negotiation Skills 3400;3200
9 19-Oct Supply Chain Management (SCM) 2500;2300
10 20-Oct Change Management 3400;3200
11 20 & 21 Oct Core Tools (2 days) 4800;4600
12 25-Oct Team Building and Motivation 2500;2300
13 26-Oct First Aid and CPR Training (GoM certificate) 2500;2300
14 27-Oct Email Etiquette & Writing Skills 2500;2300
15 28-Oct Smart Supervisory Skills 2500;2300
  *GST 18% Extra

 

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

Working together is success.” ― Henry Ford

***********