Signup as a Tutor

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

Advance Excel Online Course

12 Reviews

Course type: Online Instructor led Course

Platform: TBD

Course ID: 20577

Course type: Online Instructor led Course

Platform: TBD

Students Interested 5 (Seats Left 0)

12 Reviews

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.

Date and Time

Not decided yet.

About the Trainer

A Kumar picture

4.91 Avg Rating

46 Reviews

65 Students

2 Courses

A Kumar

B. Tech

11 Years of Experience

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.

Student Feedback

4.8

Average Rating

92%
0%
8%
0%
0%

Reviews

A

Ankit

Simple and good way of teaching. Has strong basics and step by step teaching procedure. Has the patient to deal with question and also equally making classes interesting.

V

Viswanathan Chandrasekaran

I attended the Excel course, Abhishek was a great trainer, clear explanation of concepts, good sense of progression through the topics, and most of all making it relevant to real work situations.Trainer was very responsive to all questions and made me to feel comfortable with asking questions. Highly recommended.

S

Shilajit Banerjee

Very helpful advanced excel course like Learnt a lot about excel formulas. Excel tab strip elements. Vba macros Coding methodology behind vba macros Best practices Logic refresher course Subroutines Functions Userforms Dashboards Class modules Api calls Wrapping objects around vba such as running c# and vbscripts from vba Stack programming Internet explorer wrap arounds Automating word using excel vba Automating powerpoint, adobe forms using vba Automating manual robotic steps using vba Integration of odbc data sources using vba Integration of sql and access data sources using vba Also worked on a project in the training to categorize macro enabled excel xlsm and xlsb according to complexity logic based no.of formulas, sheets, controls in the userform, no. of modules, lines of code, no.of user forms.

S

Shanmuga Priyan R

My experience training with Abhishek is hardly summed up by a five star review. Abhishek is very knowledgeable about Microsoft Office. He knows a lot and he shares it all. Very organized step by step approach to learning Excel. Lots of good tips and instruction.Your sense of humor, kindness and enthusiasm for Excel are fantastic. I like the lesson material covered. It is very applicable to my every day job.

K

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.

S

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.

C

Chethana P S

Abhishek is excellent trainer, he is friendly and method of teaching is great. He answers all the questions or doubts we have and he makes sure we are understanding the topics well. The assignments are good & makes us feel comfortable learning the technology with ease. Thanks Abhishek.

A

Anoob

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

S

Shreyansh Tripathi

Abhishek sir taught me excel which helped me in my work very friendly and knowledgeable person.Thank you sir.

K

Khushboo

As I have learnt Advance Excel from Abhishek sir, and I found him very talented. The way he teaches, I really appreciate that. He makes a lesson fun and I feel I made a great choice. He has lot of patience while solving our doubts. I wold like to recommend him as a teachers to others.

V

Vinitha Akarsh

He is a very good teacher and explains the concepts any number of times until we understand.His classes were practical and he also helps us with any queries after the completion of the course which is the best part. I am very happy with his classes and recommend him to others .

A

Abhi King

It was fun filled class....!!! I would like to suggest others to join n get max knowledge out of it...!! In future I would join some other course and be in touch always...!

Discussions

Students Interested 5 (Seats Left 0)

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

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.

Please check the fields again.

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 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

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, 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 UrbanPro.com. 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