UrbanPro
true

Advanced Excel Course

LIVE
22 reviews
25 Hours

Course offered by Annmol Tibrewal

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

~ Using advanced filter options

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

About the Trainer

Annmol Tibrewal picture

5 Avg Rating

22 Reviews

30 Students

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

Students also enrolled in these courses

LIVE

Course offered by Sudipto

0 review
LIVE
32 reviews
40 Hours

Course offered by Annmol Tibrewal

22 reviews
LIVE

Course offered by Sudipto

0 review
LIVE
12 Hours

Course offered by Subhojit Sengupta

0 review

Reviews (22)

4 out of 5 22 reviews

Annmol Tibrewal https://p.urbanpro.com/tv-prod/member/photo/5356504-small.png Mali Panchghara
5.00522
Annmol Tibrewal
V

Combo- Basic & Advanced Excel

"It was very detailed comprehensive classes, I learnt every small bit of excel including shortcuts. The practical examples and assignment to be done after class also helped in imbibing the functions plus better understanding. Very well taught in a friendly and interactive environment. Thank you. "

Annmol Tibrewal
R

Basic Excel Course

"The course was very interactive as well as informative. Teaches basic excel skills with practical examples. Great experience. "

Annmol Tibrewal
P

Basic Excel Course

"It was nice and interacting class. Easy to understand class. Thank you."

Annmol Tibrewal
L

Combo- Basic & Advanced Excel

"It was one of the best online courses I attended. Everything was taught with extreme clarity and ease. I got to know the details of excel very well and all my doubts were attended to keenly. "

View All
Have you attended any class with Analytics Educator?

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

4 out of 5 22 reviews

Annmol Tibrewal https://p.urbanpro.com/tv-prod/member/photo/5356504-small.png Mali Panchghara
5.00522
Annmol Tibrewal
V

Combo- Basic & Advanced Excel

"It was very detailed comprehensive classes, I learnt every small bit of excel including shortcuts. The practical examples and assignment to be done after class also helped in imbibing the functions plus better understanding. Very well taught in a friendly and interactive environment. Thank you. "

Annmol Tibrewal
R

Basic Excel Course

"The course was very interactive as well as informative. Teaches basic excel skills with practical examples. Great experience. "

Annmol Tibrewal
P

Basic Excel Course

"It was nice and interacting class. Easy to understand class. Thank you."

Annmol Tibrewal
L

Combo- Basic & Advanced Excel

"It was one of the best online courses I attended. Everything was taught with extreme clarity and ease. I got to know the details of excel very well and all my doubts were attended to keenly. "

Annmol Tibrewal
S

Combo- Basic & Advanced Excel

"Very clearly explained each topic with examples and assignments helped us to understand the topic better. "

Annmol Tibrewal
D

Combo- Basic & Advanced Excel

"The teaching and explanation have been so positively intriguing and has helped me learn so many diverse uses of MS-excel. The classes were conducted ensuring our comfort zone and pace of learning and grasping topics which helped us a lot. Anmol Sir’s effort and patience is commendable. The materials and assignments provided were really helpful in testing our understanding. Overall, it was an amazing experience. "

Annmol Tibrewal
M

Advanced Excel Course

"Great tutor, very patient. An in-depth explanation of all topics, Very interactive classes solves all queries. "

Annmol Tibrewal
D

Basic Excel Course

"The classes conducted provide complete clarity and ensure hundred per cent understanding of all topics by everyone. He always entertains all our doubts. The classes have a positive atmosphere. "

Annmol Tibrewal
S

Combo- Basic & Advanced Excel

"I really found the class very stimulating and helpful. The teacher was very patient and clear in his explanation. The best part was the attention to detail and patience to clear all the doubts. "

Annmol Tibrewal
V

Basic Excel Course

"Excellent knowledge and understanding of shortcuts and tricks. Good with scripting. Easy way of explaining makes it very easy to understand. Awesome lecture. Loved it. "

Annmol Tibrewal
S

Basic Excel Course

"Excellent knowledge and understanding of shortcuts and tricks. Good with scripting. An easy way of explaining makes it very easy to understand. Awesome lecture. Loved it. "

Annmol Tibrewal
M

Basic Excel Course

"Very diligent and patient tutor. Ensures everyone understands the topics. Very interactive sessions. "

Annmol Tibrewal
G

Advanced Excel Course

"Very good and Trusted teacher. His response was good. He helped me in excel assignment. I am happy to hire him. "

Annmol Tibrewal
A

Microsoft Excel Training

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

Reply by Annmol

Thank you Aditi for the review. Hope you liked our classes and it surely shall help you a lot in your career. Do recommend your friends and relatives.

Annmol Tibrewal
D

Microsoft Excel Training

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

Reply by Annmol

Thank you Deepannita for such a review. Hope you enjoyed the classes and do recommend your friends and relatives if they look for a trainer.

Annmol Tibrewal
S

Microsoft Excel Training

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

Annmol Tibrewal
R

Microsoft Excel Training

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

Annmol Tibrewal
S

Microsoft Excel Training

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

Reply by Annmol

Thank you Sreedeshna. Happy you liked the class and hope it helps you a lot in your career

Annmol Tibrewal
S

Microsoft Excel Training

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

Reply by Annmol

Thank you Sneha. It had a lovely experience teaching you. Hope u have a great career ahead.

Annmol Tibrewal
D

Microsoft Excel Training

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

Reply by Annmol

Thank You. It was nice interacting with you.

Annmol Tibrewal
T

Microsoft Excel Training

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

Reply by Annmol

Thank You Tanisha. It was nice teaching you. Hope it takes you much ahead in your career.

Annmol Tibrewal
I
Verified Student

Microsoft Excel Training

"Took a demo class from Anmol. Really liked it. He makes excel learning fun and interesting and gives a detailed in depth view of all the functions in excel. "

Reply by Annmol

Thank you Isha. See you in the classes soon.

Have you attended any class with Analytics Educator?

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Advanced Excel Course by Annmol Tibrewal

Annmol Tibrewal picture
LIVE
(22 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Advanced Excel Course by Annmol Tibrewal

Annmol Tibrewal picture
LIVE
(22 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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