Loading Events
This event has passed.

Indian Institute of Training and Development (IITD)

Presents One Full Day Interactive Upskilling Training on

Advanced Excel

Saturday, 23rd March 2024; 09:00 am to 05:00 pm

at a Business Hotel/ Hall, Pune

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:

SN Day  1: Advance Training Content
1  Writing conditional expressions (using IF)
2 Using if with single condition
3 Using if with multiple conditions
4  Using logical functions (AND, OR)
5 Using Vlookup Function
6 Using Hlookup Function
7 Using Xlookup Function
8 Using Match Function
9 Using Index Function
10 Using Index, Match together
11 Using PMT Function
12  Protecting and un-protecting worksheets and cells
13 Protecting Sheet with password
14 Unprotecting Sheet
15 Hiding Formulas
16  Saving files with passwords
17 Adding password to a file
18 Removing Password
19 Applying auto format
20  Applying conditional formatting to cells
21 Applying conditional formatting to cells
22 Applying conditional formatting to rows
23 Applying conditional formatting to worksheets
24  Sorting Data
25 Sorting tables
26 Using multiple-level sorting
27 Using custom sorting
28  Filtering data for selected view (AutoFilter
29 Filtering Numbers
30 Filtering Text
31 Filtering Date
32  Using advanced filter options
33 Filtering Unique Values
34 Filtering on multiple criteria
35 Adding & Removing Grand Total
36 Adding & Removing subtotals
37 Multiple-level subtotals
38  Pivot Table
39 Creating Pivot tables
40 Formatting and customizing Pivot tables
41 Using advanced options of Pivot tables
42 Grouping data
43 Sorting Data in pivot
44 Filtering data in pivot
45 Types of Pivot Report
46 Pivot charts
47  Consolidating data from multiple sheets and files using Pivot tables
48  Using external data sources
49  Using data consolidation feature to consolidate data
50  Chart Tools
51 Create a Chart
52 Modify Charts
53 Format Charts
54 Create a Chart Template – Combination chart
55  Record Macro
56 Recording and executing macros
57 Understanding different types of references in macros
58 Assigning macros to toolbars or menu items
59 Editing macros using VBA Editor
60 Writing function using VBA Editor
61 Custom views
62  Using goal seek
63  Using data tables
64  Creating and editing scenarios

Methodology:

A combination of Lectures, Exercises, Videos, Experience Sharing and Q & A. 

Who should attend?

This program is best suited for :

Employees and professionals willing to learn / upskill the knowledge about the Advanced features of Excel 

Medium: English/ Hindi/ Marathi

Fees

  • 1,800 + GST 18% per person 1-3 participants.
  • 1,700 + 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 25 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, Mo: 98220 89898/ 83084 59802

Indian Institute of Training and Development (IITD)

Website: www.iitdworld.com

Encl: Training Calendar Classroom

IITD CLASSROOM – FACE TO FACE TRAINING, March 2024 AT PUNE
Sr. Date Timing Duration Training Module *Fees/Person ₹ 1-3 Pax/4 & above pax
1 11-Mar-24 9.00 am to 1.00 pm Half day Creating Effective PowerPoint Presentation 1100/1000
2 11-Mar-24 1.30 am to 5.00 pm Half day 7QC Tools: Problem Solving Methodology 1000/900
3 12-Mar-24 9 am to 5 pm Full day Goal Setting & Time Management 1800/1700
4 13-Mar-24 9 am to 5 pm Full day Awareness Program on Six Sigma 1800/1700
5 14-Mar-24 9 am to 5 pm Full day Team Building for Organisational Success 1800/1700
6 15-Mar-24 9 am to 5 pm Full day Operational Excellence for Business Excellence 1800/1700
7 16-Mar-24 9 am to 5 pm Full day Communication & Presentation Skills 1800/1700
8 19-Mar-24 9 am to 5 pm Full day PokaYoke: Gate Way to World-Class Quality 1800/1700
9 20-Mar-24 9.00 am to 1.00 pm Half day Workplace Ergonomics 1100/1000
10 21-Mar-24 9.00 am to 1.00 pm Half day Conflict Management and Resolution 1100/1000
11 21-Mar-24 1.30 am to 5.00 pm Half day Employee Wellbeing – Stress Management 1000/900
12 22-Mar-24 9.00 am to 1.00 pm Half day Decision Making and Problem Solving 1100/1000
13 22-Mar-24 1.30 am to 5.00 pm Half day The Science and Art of Delegation 1100/1000
14 23-Mar-24 9 am to 5 pm Full day Advance Excel 1800/1700
15 27-Mar-24 9 am to 5 pm Full day Transformational Leadership 1800/1700
*GST 18% extra