Course Duration

Approx.15 Hours

Language

English

Doubt Clearing

Weekly

Skill Level

Beginner

About Course

Build a solid understanding of the basic to advanced features of Microsoft Excel

  • Most of the office tasks relevant to Accounts, Admin, HR, Sales, Purchase, and many more are handled using Excel.
  • An individual with advanced excel skills plays a significant role in the management of information systems.
  • Excel skills help to make quick decisions with its charts and graphs features.

What you will get to learn

Basic Excel

  • 1. Introduction to Basic Excel
  • 2. Home Tab
  • 3. Insert Tab
  • 4. Page Layout
  • 5. Data Tab
  • 6. Formulas Tab
  • 7. Review Tab & View Tab

Mastering Advanced Excel

  • 1. Overview & Customize Ribbon
  • 2. Worksheet Formatting
  • 3. Conditional Formatting & Protection
  • 4. Sorting, Filter and Advanced Filter
  • 5. Cell Referencing
  • 6. Pivot Table & Pivot Charts
  • 7. Pivot Table Grouping & Outlining
  • 8. Name Manager
  • 9. Subtotal & Consolidation
  • 10. What if Analysis- Goal Seek
  • 11. What if Analysis - Scenario Manager
  • 12. What if Analysis - Data Table and Data Validation
  • 13. Date & Time Functions
  • 14. Text Functions
  • 15. Financial Functions
  • 16. Math & Trig Functions
  • 17. Logical Functions - Basics
  • 18. Statistical Functions
  • 19. V Look Up - Basics
  • 20. H Look Up - Basics
  • 21. Look Up Functions
  • 22. Macros - Basics

Unlock the power and versatility of the Microsoft Excel tool

Why this Online Course??

  • A course designed by Experienced Accounting Professionals
  • Focuses on the training you to make you a Professional Accountant
  • Hands-on-practice in the area of Accounts, Taxation, MIS, Compliance, and Reporting.
  • Integrated with highly preferred Accounting software and applications
  • Practical Case Studies & practice on Live projects