Scribd
Upload
318 views

Excel Training Program For Employee

The document outlines an Excel training program consisting of 13 modules that covers topics from basic to advanced Excel skills. Module 1 introduces the importance and uses of Excel in business. Module 2 covers the Excel interface and basic formatting and formulas. Later modules teach complex formulas, lookup functions, arrays, text functions, data validation, pivot tables, charts, VBA macros, and integrating Excel with other applications. The goal is to take students from beginner to an advanced level of Excel proficiency.

Uploaded by

Yogesh Khanvilkar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
318 views

Excel Training Program For Employee

The document outlines an Excel training program consisting of 13 modules that covers topics from basic to advanced Excel skills. Module 1 introduces the importance and uses of Excel in business. Module 2 covers the Excel interface and basic formatting and formulas. Later modules teach complex formulas, lookup functions, arrays, text functions, data validation, pivot tables, charts, VBA macros, and integrating Excel with other applications. The goal is to take students from beginner to an advanced level of Excel proficiency.

Uploaded by

Yogesh Khanvilkar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Excel Training program for Employee

Program is Design for Beginners to Advance level

 Module.1. Importance of Excel & Uses of excel in Business

 Business tool widely used by people from a variety of walks of life, from businesspeople
to scientists to accountants.
 To apply Formulas ,formatting for large set of data
 Graphing, Chart & table creation
 Data analysis & data integration
 Create spreadsheets for work or home

 Module 2. Introduction to Excel

 What the present Version of Excel in market features of it.


 Ribbon, Quick Access Toolbar, Galleries, Mini Toolbar, Enhance Screen Tips
 Understanding Excel files, formatting cell, rows, column & conditional formatting
 Using Formulas & Function
1. Date & Time
2. Logical Function
3. Mathematical Functions
4. Statistical Function
5. Text Function

 Module 3.Complex Formulas with Advance Function

 Lookup & Reference Functions


 Indirect Match ,Offset ,Transpose
 Find Data in Opposition by Index Match.

 Module 4. Lookup & Reference Functions

 Discussions on lookup functions, Use of Lookup, Vlookup, Hlookup.


 Vlookup, Hlookup with Name Range & Match.
 Vlookup, Hlookup with Multiple Function, Vlookup, Hlookup with arrays.
 Module 5.Array with Multiple Formulas

 Array Formulas and Use of the Array Formula,


 Array with Sum if , Count ifs , Sum product, Large Functions

 Module 6.Text functions & Data Validation

 Char, Clean, Code, Concatenate, Test, Trim, Value, Sort


 Data Validation, Group & Ungroup, Data Split

 Module 7.Pivot Table and Pivot Charts with Slicer

 Do the Multiple Field Setting in Pivot Table


 Pivot form Multiple Source of Data, Data Ranges, Name Range.
 Group Pivot Table Items , Mutli-level Pivot Table, Calculated Field

 Module 8.Advanced Chart & Dashboard Technique

 How to Make Dynamic chart, Bar Chart, Pie Chart


 Scatter Chat, Line Chart, Column Chart,
 Speedometer Chart, Gantt Chart, Pareto Charts
 Preparation of Advanced Level of Charts : Gantt Chart, Bubble Chart, Waterfall chart,
Use of Data Validation in Charting
 Offset Function, Combination of Charts, Time Series Analysis and Visualizing Data

 Module 9. VBA Macros & Dashboard Programming

 What is VBA & How VBA Works with Excel


 Macro, Concept of macro
 Quick visit to functioning of macros in MS Word
 Macros can be stored
 Difference in Absolute and Relative Referencing
 Assigning macros to key board short-cuts, buttons, icons
 Module 10.Introduction to VBA Editor & VBA Terminology

 Project Explorer, Creating Modules


 Variables, Constants, Message Box, Input Box
 Excel Object Model, Object and Collections
 Methods and Properties, Event Handling

 Module 11.Sub routines & User Form

 Procedures, Functions
 User Form : Dialog boxes and toolbar and menu bar creation
1. Text Box 2. Label
3. Button, Radio button 4. List, Check, Combo box
5. Attaching macros to controls
 Module 12.Programming Constructs & Case Statement

 If Condition, Multiple ifs, Array


 Logical AND, OR operators along with if condition
 Select Case Statement
 Looping
1.For 2. Do while
 Looping Over Collections
1. Object Variables 2. Collections

 Module 13. How to Use Excel data for Analysis in other application

 Integrate excel data with various other application for data analysis like Tableau, Power
BI, SQL etc.
 Various Plugin and add ins in Excel for Python R, etc.

You might also like