Signup as a Tutor

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

true
true

8 Reviews

Course ID: 64056

Students Interested 0 (Seats Left 0)

₹ 5,000 onwards

8 Reviews

Module 1 - Overview of the Basics of Excel

~ Customizing common options in Excel

~ Absolute and relative cells

~ Protecting and un-protecting workbooks,worksheets and cells

Module 2- Working with Functions

~ Writing conditional expressions (using IF)

~ Using logical functions (AND, OR, NOT)

~ Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)

~ VlookUP with Exact Match, Approximate Match

~ Using VLookUP to consolidate Data from Multiple Sheets

Module 3 - Data Validations

~ Specifying a valid range of values for a cell

~ Specifying a list of valid values for a cell

~ Specifying custom validations based on formula for a cell

Module 4 - Sorting and Filtering Data

~ Sorting tables

~ Using multiple-level sorting

~ Using custom sorting

~ Filtering data for selected view (AutoFilter)

Module 5 - Working with Reports

~ Creating subtotals

~ Multiple-level subtotals

~ Creating Pivot tables

~ Formatting and customizing Pivot tables

~ Using advanced options of Pivot tables

~ Pivot charts

~ Consolidating data from multiple sheets and files using Pivot tables

~ Using external data sources

~ Using data consolidation feature to consolidate data

~ Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)

~ Viewing Subtotal under Pivot

~ Creating Slicers ( Version 2010 & Above)

Module 6 - More Functions (covering 250+functions)

~ Date and time functions

~ Text functions

~ Math functions

~ Financial functions

~ Database functions

~ Power Functions (CountIf, CountIFS, SumIF, SumIfS)

~ Trace precedents, dependents, remove arrows and error evaluation

Module 7 - Formatting

~ Using auto formatting option for worksheets

~ Using conditional formatting option for rows, columns and cells

~ Text to columns related conversion

Module 8 - Macros

~ Creating Macros

~ Editing Macros

Module 9 - WhatIf Analysis

~ Goal Seek

~ Data Tables

~ Scenario Manager

Module 10 - Charts

~ Using Charts

~ Formatting Charts

~ Using Bar and Line Chart together

~ Using Secondary Axis in Graphs

~ Sharing Charts with PowerPoint / MS Word, Dynamically

~ (Data Modified in Excel, Chart would automatically get updated)

Module 11 - New Features Of Excel

~ Sparklines, Inline Charts, data Charts

~ Overview of all the new features

The classes for the Advanced Course is conducted on Weekdays- Monday- Friday.

Check our batch details

Not decided yet.

## Students also enrolled in these Courses

5 Avg Rating

9 Reviews

19 Students

3 Courses

Annmol Tibrewal

Chartered Accountant

3 Years of Experience

Almost 3 years’ experience in training professionals and graduates from various fields about the details and efficient use of MS- Excel for professional growth. Ranked 1 by Urbanpro as an MS-Excel trainer, he tries to bring his experience and learning in his classroom and focus on incorporating real life examples to illustrate his teaching, thereby making classes lively, interactive and full of practical knowledge. His student-friendly style of teaching, practical application of learning and motivational approach to drive his mentees creates a lasting impact on students.

Currently engaged in training students online, he has taught over 100 students and professionals including Chartered Accountants, Company Secretaries, Graduates, aspiring MBAs and even housewives. He has given corporate seminars on Advanced excel in companies like Tata Hitachi, Hindustan Unilever Limited, India Power Corporation Limited, Balaji Chemicals, Varsace Apparels Private Limited and various partnership and sole-proprietorship firm where the main focus is to train the finance and MIS team to handle the data analysis and maintain MIS using Excel much more efficiently for better results.

5.0

Average Rating

100%
0%
0%
0%
0%

## Reviews

A

Anmol has been an incredible Excel teacher, he inculcates the ability to visualize data and analyze information in his students. The style of teaching and structure of the class is unique, accessible, interactive and best way to learn. Basic excel course helped me in using excel faster and in a more efficient way. The advanced course nurtured the ability to organize, evaluate and analyze data. Microsoft Excel is the most used program and one of the most important skill set to have, if you wish to climb up the ladder, after taking his classes the Excel strategies and techniques made me better at what I do and definitely gives me an edge. Most recommend for finance professionals like me and for other functions as well.

D

Deepannita Jain

Anmol is an excellent tutor who conveys his knowledge of complex material in a manner easily understandable. He gave step by step explanations and made sure I understood everything before proceeding & presents the material in a clear and logical sequence. Would definitely recommended.

S

Shivanshu Shaw

Annmol Sir had all the knowledge one needs to know about excel. A very friendly and adjustable teacher. Loved his classes!

R

Rashmi Birua

I had fun learning in his class. Each topic was conveniently taught with ease. Keep up the good work Anmol.

S

SREEDESHNA DAS

Anmol is a passionate teacher and is able to explain the curriculum very well. He is patient and has the zeal to teach. I have liked attending his classes and have been able to gain a thorough understanding of excel.

S

Sneha agarwal

A great Teacher. Anmol is an extremely patient, thoughtful and thorough tutor. He got me excited to use excel which i have been avoiding my whole life. Highly recommended. Thank you so much.

D

Divya Lunia

Anmol has an indepth knowledge about excel and he makes sure to impart the same to the students. The classes were fun, interesting and at the same time full of knowledge.

T

Tanisha Jain

Anmol is a young and passionate teacher. The way he teaches and interacts with the learners can be rarely seen in any teacher. His enthusiasm while teaching is contagious.

## Discussions

Students Interested 0 (Seats Left 0)

₹ 5,000 onwards

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

Enquire

Please enter valid question or comment

Connect With Annmol

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 Enter valid Email or Phone Number

Forgot Password? Resend OTP OTP Sent

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