Course 1: Basic Excel - Topics Covered
Module 1: Getting Started
	~ Understanding the Excel screen
	~ Navigating in a spreadsheet
	~ Understanding worksheets, columns, rows and cells
	~ Saving, opening, and closing workbooks
	~ Navigating and operating in excel through shortuts
Module 2: Formatting a Spreadsheet
	~ Changing column widths and row heights
	~ Changing alignment of cells
	~ Undoing and redoing actions
	~ Formatting numbers
	~ Clearing formats
	~ Applying borders to cells
	~ Merging cells
Module 3: Formulas and Functions
	~ Entering formulas
	~ Copying data and formulas
	~ Using AutoSum
	~ Understanding functions
	~ Using simple agg. functions (Sum, Count, Average, Min, Max)
	~ Copying formulas
	~ Applying conditions in a formula (The IF function)
	~ Working with ranges
Module 4: Editing Features
	~ Using cut , copy, and paste operations
	~ Using paste special with values
	~ Selection techniques
	~ Navigation techniques
Module 5: Working with Large Worksheets
	~ Freezing and unfreezing panes
	~ Splitting windows
	~ Inserting page breaks for printing
Module 6: Working with Charts
	~ Creating charts using Chart Wizard
	~ Creating different types of charts
	~ Including titles and values in charts
	~ Formatting of charts
Module 7: Previewing and Printing
	~ Previewing worksheets
	~ Page setup
	~ Printing of worksheets in multiple pages
	~ Repeating rows and columns for multiple pages
	~ Printing multiple worksheets
Module 8: Simple Database Operations
	~ Sorting tables
	~ Filtering data with auto filter
	~ Referring data from other worksheets

The classes for the Combo Course is conducted on Weekends- Saturday- Sunday.

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