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

No Reviews Yet

Sarjapur Road, Bangalore

Course ID: 2371

Sarjapur Road, Bangalore

Students Interested 0 (Seats Left 0)

₹ 12,000

No Reviews Yet

Date and Time

Not decided yet.

Rashmi Sachdeva

MS in Information Technology, MS-BI

9 Years of Experience

About Rashmi Sachdeva

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.
No reviews currently Be the First to Review

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.

Reviews

No reviews currently Be the First to Review

Students Interested 0 (Seats Left 0)

₹ 12,000

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 12,000 Enquire

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