Corporate Training in Advance MS Excel
Corporate Training
in MS Excel
This program 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.
Program Objectives
This Advanced Excel
training program will empower the participants to be able to do the
following:
-
Performing complex
calculations more efficiently, using various Excel functions.
-
Organizing and
analyzing large volumes of data.
-
Creating MIS
reports.
-
Designing and using
templates.
-
Consolidating and
managing data from multiple workbooks.
Audience
Executives and managers
who have already been using Microsoft Excel, but now feel the need for
learning more powerful features and options of Excel, to manage their
worksheet-related tasks more efficiently.
COURSES OUTLINE
Module 1: Overview of the Basics
- Customizing common
options in Excel
- Absolute and relative
cells
- Protecting and
un-protecting worksheets and cells
Module 2: Working with Functions
- Writing conditional
expressions (using IF)
- Using logical functions
(AND, OR, NOT)
- Using lookup and
reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
Module
3: Data Validations
- Specifying a valid
range of values for a cell
- Specifying a list of
valid values for a cell
- Specifying custom
validations based on formula for a cell
Module 4: Working with Templates
- Designing the structure
of a template
- Using templates for
standardization of worksheets
Module 5: Sorting and Filtering Data
- Sorting tables
- Using multiple-level
sorting
- Using custom sorting
- Filtering data for
selected view (AutoFilter)
- Using advanced filter
options
Module 6: Working with Reports
- Creating subtotals
- Multiple-level
subtotals
- Creating Pivot tables
- Formatting and
customizing Pivot tables
- Using advanced options
of Pivot tables
- Pivot charts
- Consolidating data from
multiple sheets and files using Pivot tables
- Using external data
sources
- Using data
consolidation feature to consolidate data
Module 7: More Functions
- Date and time functions
- Text functions
- Database functions
Module 8: Formatting
- Using auto formatting
option for worksheets
- Using conditional
formatting option for rows, columns and cells
Contact
Aslam Paloji
Mobile: +91.9833046773, Mumbai India
Email
: info@paloji.com
......................................................
PALOJI
Technologies
Corporate IT Training!
