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 Advance Excel Online Course

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 Abhishek

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

Advance Excel Online Course

Advance Excel Online Course

Online Instructor led Course

Platform: TBD

5,100

3 Reviews
5 Interested

About the Course


The outline of this training course is designed to provide training in advance functional aspects of MS-Excel. Anyone who know some basic of excel and desire to enhance the skill in Advance Excel can go for this training session.

Topics Covered

Unit 1 – Home Tab
***********************
Conditional Formatting
Use of format painter
Use of paste special
Strike through a value
Find and Replace
Hide/ unhide a tab
Color a tab
Move /Copy the tab to another sheet/workbook

Unit 2 – Insert Tab
*********************
Pivots and Pivot Graphs
-----------------------------------
Creating of Pivot Table
Using Summary function in Pivot Table
Pivot Table Calculations
Creating own formulas in Pivots
Grouping and Ungrouping in Pivot Tables
Creating Pivot Graph
Custom Filter on Pivot Table
Dropping data into the Pivot Table
Modifying data
Refreshing the 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.)
Calculated Fields Calculated Items


Working on Objects
-----------------------------
Inserting Objects
Exploring Formatting options for the inserted objects
Hyperlinks and Bookmarks in Excel
Providing screen tips in hyper link
Hyperlink to send emails
Inserting different files into Excel (like .doc, .pdf, .txt files)
Inserting symbols

Working with Charts
------------------------------
Creating charts
Creating different types of charts (Pie, Columnar, Bar, Stacked, Combination, , X-Y, 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

Unit 3 – Formulas
**********************
STRING
------------
CHAR/CODE,CLEAN/TRIM
CONCATENATE,FIND/SEARCH
LEFT/MID/RIGHT,LEN/REPT
LOWER/PROPER/UPPER
REPLACE/SUBSTITUTE

MATHEMATICAL
--------------------------
CEILING/FLOOR, EVEN/ODD
LARGE/SMALL, MAX/MIN
ROUND/TRUNC, AVERAGE/SUM/COUNT
PRODUCT/SUMPRODUCT

DATE
---------
DATE/TIME,
DATEDIF/DAYS360
DAY/MONTH/YEAR
HOUR/MINUTE/SECOND
NETWORKDAYS/NETWORKDAYS.INTL NOW/TODAY
WEEKDAY/WEEKNUM/WORKDAY

LOOKUP / REFERENCE
------------------------------------
ADDRESS, AREAS, CHOOSE
COLUMN/ROW, HLOOKUP/VLOOKUP
INDEX/MATCH,INDIRECT
LOOKUP/OFFSET,TRANSPOSE

STATISTICAL
--------------------
GROWTH,INTERCEPT
LARGE, PERCENTILE
PERCENTRANK ,QUARTILE,RANK

INFORMATION
----------------------
CELL, ISBLANK/ISNUMBER
ISERR/ISERROR
ISLOGICAL,ISNA, ISNONTEXT/ISTEXT

LOGICAL
-------------
IF, FALSE/TRUE, AND/OR/NOT

Name Manager
----------------------
Definition Named Ranges
Use of name manager
Using formulas in name manager
Editing name range

Formula Auditing
-------------------------
Trace Precedents, Trace Dependents
Error Checking
Remove arrows
Formula Evaluation

Unit 4 – Data Tab
*********************
Data Connection from External Data
From access
From SQL
From Web
From ODBC

Data Validation
----------------------
Use Data Validation in Excel
Using Input Message in Data validation
Using error message in Data Validation

Sorting Data
------------------
Sorting tables
Using multiple-level sorting
Using custom sorting
Adding and deleting different levels of sorting

Split Texts
----------------
Split texts to different columns
Remove special character from a string and split the string

What If Analysis
------------------------
Goal Seek
Scenarios

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
Filter by color

Subtotals
--------------
Concept of Subtotal
Creating subtotals
Multiple-level subtotals
Grouping and Outlining Data

Data Consolidation
---------------------------
Using data consolidation feature to consolidate data


Unit 5 - Review & View
**************************

View Multiple Files
---------------------------
Inserting page breaks for printing
Arrange multiple windows to view in one time.
Split big sheet into sub sheets for better analysis
Freezing and unfreezing panes

Security
------------
Protecting your workbook
Protecting the worksheet
Sharing the workbook
Allow users to edit ranges

Who should attend

Engineers, Managers,Executives,BPO Executives, MIS Personals, Accounts Personal, HR, Quality Analyst, Analysis Students etc.

Pre-requisites

Limited knowledge of MS Excel and willing to to Learn Advance Excel, Rest I will take care.

What you need to bring

This is online class so students should have good Laptop or Desktop with good internet connection at least 256 kbps. Internet Connection should be continuous to avoid any interruptions during the session.

If any how some topic missed then later on it would be cover.

Key Takeaways

Excellent knowledge in Excel.
Training Presentations/Worksheet
Tutorials and Exercise.
Content
Reviews

Recommendations & reviews from previous Customers:

Kiran

"I take this opportunity to mention that Mr. Abhishek is highly skillful and experienced. I opted for Advanced MS-Excel. His training is very structured and enables you to work on several complex functions and formulae by the end of the course. We feel confident!! Thank you Abhishek. "

attended Advance Excel Online Course


Shubham Kumar Shukla

"The course is designed in such a way that it touches all the relevant point and Mr. Abhishek uses witty example to make understand about its uses. I would highly recommend for all working professional looking out to get excel handy in their daily work life. "

attended Advance Excel Online Course


Anoob

"I liked the classes very much. His knowledge on the subject is amazing. Very friendly and teach very well. "

attended Advance Excel Online Course


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


Recommendations & reviews from previous Customers:

Kiran

"I take this opportunity to mention that Mr. Abhishek is highly skillful and experienced. I opted for Advanced MS-Excel. His training is very structured and enables you to work on several complex functions and formulae by the end of the course. We feel confident!! Thank you Abhishek. "

attended Advance Excel Online Course


Shubham Kumar Shukla

"The course is designed in such a way that it touches all the relevant point and Mr. Abhishek uses witty example to make understand about its uses. I would highly recommend for all working professional looking out to get excel handy in their daily work life. "

attended Advance Excel Online Course


Anoob

"I liked the classes very much. His knowledge on the subject is amazing. Very friendly and teach very well. "

attended Advance Excel Online Course


Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer

A Kumar picture

A Kumar

B. Tech


I have more than 6.5 years of IT domain experience. Currently working as Sr. Software Engineer in reputed MNC. Created multiple Gold award winning macros in current organization.
Seats Left-

Students Interested 5

Course Id: 20577