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

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.

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

Varun Kejriwal

Reviewed on 04 Jul, 2020

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

Rhia

Reviewed on 27 Jun, 2020

Basic Excel Course

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

Annmol Tibrewal

Priyanka Kharkia

Reviewed on 22 Jun, 2020

Basic Excel Course

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

Annmol Tibrewal

Laxmi Devi bajoria

Reviewed on 08 May, 2020

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?

About the Trainer

Reviews (22)

Subhojit Sengupta