Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Complete Reference Advance Excel-3days

4 Reviews

Sarjapur Road, Bangalore

Course ID: 2371

Sarjapur Road, Bangalore

Students Interested 0 (Seats Left 0)

4 Reviews

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:
All Functions

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 Covered

Course 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
Formula Evaluation

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
Splitting windows
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
Sorting tables
Using multiple-level sorting
Using custom sorting
Adding and deleting different levels of sorting
Row wise sorting

Module 8: Working with Charts
Creating 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
Goal Seek
PMT function

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
Creating subtotals
Multiple-level subtotals

Module 12: Using Pivot Tables
Creating Pivot Table
Dropping data into the Pivot Table
Modifying data
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
Creating Table

Module 15: Multipurpose Function: I: Offset Function
Offset Function
Using Offset function for calculation and other purpose
Using Offset Function to create Dynamic Data Ranges

Module 16: Multipurpose Function: II
Sumif, Sumifs
Countif, Countifs

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
Error Checking
Remove arrows
Formula Evaluation

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 attend

BPO Emaployee
Business person
Management Professional dealing with Data
MIS personnel
Commerce field, Would be C.A.


Well verse in Basics and Functions of Excel

What you need to bring

Computers with Excel 2007 installed, will be provided for practice.""""""""

Key Takeaways

Training material will be shared with you.

Knowledge to manage your data.
Knowledge specific to Business Solution no matter which field you are in.

Program Deliverable:
• Reference material for Excel training will be provided to all participants.

Date and Time

Not decided yet.

About the Trainer

5 Avg Rating

17 Reviews

60 Students

13 Courses

Rashmi Sachdeva

MS in Information Technology, MS-BI

9 Years of Experience

I have Total 9.5years of experience in IT field.

->I am rendering my services as Freelance Technical Consultant ( Business Solutions & Analysis) & Corporate Trainer.

->As a Techical Consultant I am harnessing the power of Excel for MIS(Management Information System), Business Decisions.

->Presently I am assisting three companies one from each US,Uk and Europe in their Business.

->As a Corporate Trainer, helping others to achieve their goal.

Student Feedback


Average Rating




Suparna Mehrotra

In simple words, I can tell -"The training is worth" One should go for the same. Rashmi Sachdeva gives the detailed explanation for each and every topic and is also very friendly . She is never tired to give the explanation again and again.She is always approachable, friendly, patient and will take how much ever time is required to teach you the concept.


Mahesh Sn

It was very gud time with rashmi to learn more thhing abt excel SPL thanks to rashmi


Girish Jamdar

I am IT professional. It is worth joining class at Rashmi Madam.I have learned from Rashmi Madam. I found Rashmi madam as Highly professional, Good Subject knowledge, very good teacher. Perfectly designed course material. Really focused, excellent Teacher. Course and teaching is exactly according to my expectations. I am very happy. I will recommend people to join the class.

Pankaj Singh

The class was fruitfull. Hope to learn more when i take the next course in the same subject matter.

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now


Submit your enquiry for Complete Reference Advance Excel-3days

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Rashmi

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more