About the Course
Macro/VBA Training also available.
Register for the class, you are interested in.
In case of special requirement, ask for assistance
ONLINE and OFFLINE both classes available.
Complete Reference Advance Excel.
I am covering Complete MS-Excel through two crash courses.
1. Functional Excel:
2. Complete Reference in Advance Excel:
Covering all topics(except Functional Excel)
It is excellent opportunity for professionals from all fields to get trained in all specialized tools of Excel.
Formulas/Functional Excel is same, irrespective of version, you are using.
Topics CoveredCourse in Advanced Excel 2007/2010/2013
This training course outline is designed to provide training in Functional aspects of MS-Excel.
Module 1: Navigation and Data Cleaning
Navigation in a spreadsheet
Using Different Navigation Techniques for Data Cleaning
Formatting numbers ,Clearing formats
Managing records, Recognizing and Correcting blank, errors
Precedents and dependents cells for cell value
Module 2: Connect Excel Workbook with other applications
Hyperlinks and Bookmarks in Excel
Embedding Power Point, Excel, Word and PDF files in Excel
Compatible file formats with Excel
Using text files with Excel
Module 3: Working with Ranges
Working with ranges, continuous, dis-continuous, Intersecting ranges
Module 4: Working with Large Worksheets
Freezing and unfreezing panes
Inserting page breaks for printing
Module 5: Named Ranges
Definition Named Ranges
Usage of Named Ranges
Utility: Using Named Ranges in tools like Data Validation Tool, Index and Match Function
Module 6: Data Validations
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell: Allowing Only whole number/decimal/text length
Specifying custom validations
Module 7: Sorting Data
Using multiple-level sorting
Using custom sorting
Adding and deleting different levels of sorting
Row wise sorting
Module 8: Working with Charts
No. Of column, Types of columns required to create charts
Creating different types of charts(Pie, Columnar, Bar, Stacked, Combination chart, , X-Y chart, Line chart
Including titles and values in charts
Formatting of chart
Creating Secondary Axis in Chart
Changing display of category on X-Axis
Different Formatting options for different Chart components
Themes available in Excel and its usage
Module 9: What If Analysis
Module 10: Filtering the Data
Need of Filter application
Different kinds of filters
Auto and Advance filter
Filter condition for Filtering data
Using advanced filter options
Other usage of filters
Module 11: Using Subtotals for Reporting Purpose
Concept of Subtotal
Module 12: Using Pivot Tables
Creating Pivot Table
Dropping data into the Pivot Table
Refreshing the Pivot Table
• Making amendments in existing rows of Database
• Adding new rows in Database
Moving Data in Pivot Table
Grouping dates within a Pivot table
Grouping Text Entry in Pivot Table
Creating ranges for numbers in Pivot table
Formatting Pivot Table
Changing Value field setting
Changing Report Layout
Applying Slicer (in Excel 2010)
Turn off/on Grand total for Rows/Column
Drilling down report for Pivot Table values
Using Conditional Formatting in Pivot Table
Apply Page Report filter, Row and column Filter
Number Formatting to Pivot Table values
Customized column values (% of Total, % of column etc.)
Customizing Pivot Table options
Using advanced options of Pivot tables
Module 13: Data Consolidation
Using data consolidation feature to consolidate data
Types of Data Consolidation
Deploying Different capabilities of Data Consolidation
• Consolidation by Category
• Consolidation by Position
Module 14: Dynamic Data Ranges
Concept of Dynamic Data Ranges
Module 15: Multipurpose Function: I: Offset Function
Using Offset function for calculation and other purpose
Using Offset Function to create Dynamic Data Ranges
Module 16: Multipurpose Function: II
Module 17: Auto and Conditional Formatting
Concept of Condition Formatting
Using Different Conditional Formatting(Data Bars, Color Scales and others.
Applying Formulas for customized Conditional Formatting
Creating new rules, Managing, Editing and deleting new rules.
Using auto formatting option for worksheets
Module 18: Protecting Your workbook
Protecting Window or Content
Workbook, Worksheet and Cell level of Protection
Applying Password on Workbook, Worksheet and cell level
Module 19: Creating Data Entry Form
Predefine a format for data entry form for professionals
Module 20: Formula Auditing
Trace Precedents, Trace Dependents
Module 21: Shortcut Keys
50 most Important shortcut keys
Module 22: Introduction to Macros- 1hr. Introductory Session
Recording a Macro
How to Save and Run Macro
Editing any existing Macro
Assigning a macro to a button
MS Excel training: Who should attend?
• Sales & Marketing, Finance, HR, Admin, Accounts, Project Management, MIS and CRM professionals.
• Professionals from Engineering background, Real Estates, Customer Service Executives, Front desk Executives and Insurance Sector professionals.
• Students studying professional courses
Course Outline: Please see attached pics for course outline
Who should attendBPO Emaployee
Management Professional dealing with Data
Commerce field, Would be C.A.
Pre-requisitesWell verse in Basics and Functions of Excel
What you need to bringComputers with Excel 2007 installed, will be provided for practice.""""""""
Key TakeawaysTraining material will be shared with you.
Knowledge to manage your data.
Knowledge specific to Business Solution no matter which field you are in.
• Reference material for Excel training will be provided to all participants.