Loading Events
This event has passed.

Indian Institute of Training and Development (IITD)

Presents One Full Day Interactive Training on

Advanced Excel

Tuesday, 23rd January 2024; 09:00 am to 05:30 pm

at a Business Hotel/ Hall, 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:

Formulas

  • Vlookup, Hlookup, Xlookup
  • DSUM,DCOUNT,DMIN,DMAX
  • Match, Index
  • AND,OR,IF,SUMIF,COUNTIF
  • ARRAY, Sort, Filter, LET,Sequence
  • Xmatch, Rank, Unique, Transpose

Pivot Table

  • Calculated Fields, GETPIVOTDATA
  • Slicers, Pivot Charts, Drill-Down
  • Report filter pages

Dashboard

  • Interactive Dashboard Basic, KPIs
  • Data Visualization, Reports

Automation

  • Macro, Automation Basic
  • UserForms, Worksheet Events
  • Create & manage own menu bar

What if analysis

  • Goal Seek, Data Table, Scenario
  • Data Table

Scenario

Forecast Sheet

Data Analysis

  • Descriptive Statistics
  • Data Validation, Regression

Power Query Basic

  • Combine multiple files
  • Transformation
  • Auto Update

Filter

  • Advanced Filter
  • Multilevel Filter

Conditional Format

  • Advanced Conditional Format

Charts

  • Interactive, Conditional Charts

 

The Learning Model

The trainer uses up-to-date training techniques and a variety of training methods, to give all participants the best opportunities for learning, including:

  • Class Session
  • Group Discussions
  • Simulations exercises
  • Case studies and Problem-Solving Exercises
  • Individual assignments

 

Medium: English/ Hindi/ Marathi 

Fees

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

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

 

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,

 

Rajiv Kolhe, Mob: 9822089898

Indian Institute of Training and Development (IITD)

Website: www.iitdworld.com