Course Duration

Approx.15 Hours

Language

Hindi

Doubt Clearing

Weekly

Skill Level

Beginner

About Course

Master Microsoft Excel from Beginner to Advanced

  • Understand different features and their functions
  • Learn worksheet formatting with various formatting features.
  • Learn V Lookup basics & H Lookup basics, lookup functions, and macros-basics.

Course Curriculum


  Basic Excel - Session 1: Introduction
Available in days
days after you enroll
  Basic Excel - Session 2: Home Tab 2.1
Available in days
days after you enroll
  Basic Excel - Session 3: Home Tab 2.2
Available in days
days after you enroll
  Basic Excel - Session 4: Insert Tab 2.1
Available in days
days after you enroll
  Basic Excel - Session 5: Insert Tab 2.2
Available in days
days after you enroll
  Basic Excel - Session 6: Insert Tab - 2.3
Available in days
days after you enroll
  Basic Excel - Session 7: Insert Tab 2.4
Available in days
days after you enroll
  Basic Excel - Session 8: Insert Tab 2.5
Available in days
days after you enroll
  Basic Excel - Session 9: Page Layout
Available in days
days after you enroll
  Basic Excel - Session 10: Data Tab
Available in days
days after you enroll
  Basic Excel - Session 11: Formulas Tab
Available in days
days after you enroll
  Basic Excel - Session 12: Review Tab & View Tab
Available in days
days after you enroll
  Mastering Advanced Excel - Session 1: Overview & Customize Ribbon
Available in days
days after you enroll
  Mastering Advanced Excel - Session 2: Worksheet Formatting
Available in days
days after you enroll
  Mastering Advanced Excel - Session 3: Conditional Formatting & Protection
Available in days
days after you enroll
  Mastering Advanced Excel - Session 4: Sorting, Filter and Advanced Filter
Available in days
days after you enroll
  Mastering Advanced Excel - Session 5: Cell Referencing
Available in days
days after you enroll
  Mastering Advanced Excel - Session 6: Pivot Table & Pivot Charts
Available in days
days after you enroll
  Mastering Advanced Excel - Session 7: Pivot Table Grouping & Outlining
Available in days
days after you enroll
  Mastering Advanced Excel - Session 8: Name Manager
Available in days
days after you enroll
  Mastering Advanced Excel - Session 9: Subtotal & Consolidation
Available in days
days after you enroll
  Mastering Advanced Excel - Session 10: What if Analysis- Goal Seek
Available in days
days after you enroll
  Mastering Advanced Excel - Session 11: What if Analysis - Scenario Manager
Available in days
days after you enroll
  Mastering Advanced Excel - Session 12: What if Analysis - Data Table and Data Validation
Available in days
days after you enroll
  Mastering Advanced Excel - Session 13: Date & Time Functions
Available in days
days after you enroll
  Mastering Advanced Excel - Session 14: Text Functions
Available in days
days after you enroll
  Mastering Advanced Excel - Session 15: Financial Functions
Available in days
days after you enroll
  Mastering Advanced Excel - Session 16: Math & Trig Functions
Available in days
days after you enroll
  Mastering Advanced Excel - Session 17: Logical Functions - Basics
Available in days
days after you enroll
  Mastering Advanced Excel - Session 18: Statistical Functions
Available in days
days after you enroll
  Mastering Advanced Excel - Session 19: V Look Up - Basics
Available in days
days after you enroll
  Mastering Advanced Excel - Session 20: H Look Up - Basics
Available in days
days after you enroll
  Mastering Advanced Excel - Session 21: Look Up Functions
Available in days
days after you enroll
  Mastering Advanced Excel - Session 22: Macros - Basics
Available in days
days after you enroll

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