Signup as a Tutor

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

Enquire

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.

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 support@urbanpro.com 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 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

Share

Complete Reference Advance Excel-3days

Complete Reference Advance Excel-3days

Sarjapur Road, Bangalore

12,000

No Reviews Yet
0 Interested

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
Scenarios
Table
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.
Sales/HR.

Pre-requisites

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.
Content
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask

Showing 1 to 10 of 36
R

Rashmi 29/01/2014

Praveen,

Please contact me at 95353-28913.

Regards
Rashmi S.

0 0

Answer

You can add upto 6 Images

U

praveen balan 27/01/2014

when is the next 3 days crash course in February'14. can I get accomodation facility since I am coming from kerala. Also how much is the fee

0 0

Answer

You can add upto 6 Images

R

Rashmi 01/01/2014

Wish You All A Very Happy Prosperous New Year..
Happy Learning !!!!

Regards
Rashmi S.

0 0

Answer

You can add upto 6 Images

R

Rashmi 01/01/2014

Wish You All A Very Happy Prosperous New Year..
Happy Learning !!!!

Regards
Rashmi S.

0 0

Answer

You can add upto 6 Images

U

Bantwal Srinivas Pradeep 30/08/2013

Dear Rashmi,

I am interested and know the fee structure now. I will make a final decision after 19th September as I am on a snow skiing course and will return to Auckland at the end of the month.

Pradeep

0 0

Answer

You can add upto 6 Images

U

Dauda Sheriff 29/08/2013

Intrested in online training on the following:
1- Auto and advance finter.
2- auto and conditional formating
3- Introduction to macros.

0 0

Answer

You can add upto 6 Images

R

Rashmi 26/07/2013

Hi Pradeep, Course fee is mentioned on the top right hand corner. Fee mentioned is non-negotiable. Don't post message regarding negotiation of fee here. Questions and comment section is for user queries regarding course outline. Not for bargain about course fee. Hope you understand this. Regards Rashmi S.  more » Hi Pradeep,

Course fee is mentioned on the top right hand corner.

Fee mentioned is non-negotiable. Don't post message regarding negotiation of fee here. Questions and comment section is for user queries regarding course outline. Not for bargain about course fee.

Hope you understand this.

Regards
Rashmi S. «less

0 0

Answer

You can add upto 6 Images

R

Rashmi 03/05/2013

Hi There,

Class is scheduled for May 5 from 10AM-11AM. Interested please register for class.

Regards
Rashmi S.

0 0

Answer

You can add upto 6 Images

R

Rashmi 13/04/2013

Vijeysree, Functions and formuals are covered in Functional Excel course outline. Visit below mentioned link. http://www.urbanpro.com/bangalore/functional-ms-excel-master-basics-and-functions-in-1-day/496687 Course outline for Adavnce Excel is explained on the page where you posting your queries. Please see all 17 modules. Arrays, Sumif, and Countif...  more » Vijeysree,

Functions and formuals are covered in Functional Excel course outline. Visit below mentioned link.
http://www.urbanpro.com/bangalore/functional-ms-excel-master-basics-and-functions-in-1-day/496687

Course outline for Adavnce Excel is explained on the page where you posting your queries. Please see all 17 modules.

Arrays, Sumif, and Countif I add in Advance Excel,if requested (without any extra payment).



Regards
Rashmi S. «less

0 0

Answer

You can add upto 6 Images

U

vijeyasree 11/04/2013

Thanks Rashmi for your reply, will ur course cover Vlookup, Hlookup, arrays etc.............

0 0

Answer

You can add upto 6 Images


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer

Rashmi Sachdeva

MS in Information Technology, MS-BI


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.
Seats Left-

Students Interested 0

Course Id: 2371