M Excel Elite

LIVE ONLINE SESSIONS | NO RECORDED ACCESS

10 Days
Learning Calendar

10 Days. 20+ Hours. One Goal – EXCEL EXCELLENCE!

Direct Interaction with Trainer
Practice Files & Resources
Doubt Solving in Live Class
Certificate of Completion
Lifetime Access to Class Materials

Full Course Curriculum

1. Getting Started

  • Introduction
  • What is Data & Its Theory
  • Excel Versions
  • Interface Overview
  • Movement Shortcut Keys
  • Data Entry

2. Visual Basics

  • Formatting
  • Number Formats
  • Basic Formulae
  • Conditional Formatting

3. Smart Data Handling

  • AI Conditional Formatting
  • Data Creation with AI
  • Clipboard
  • Filter
  • Sorting
  • Table Creation
  • Fill Series

4. Efficiency Boosters

  • Go To Special
  • Paste Special
  • Find & Replace
  • Clear
  • Cell Referencing

5. Formula Basics

  • Text Formulas
  • Rand/Randbetween/Randarray
  • Large/Small
  • Round/Roundup/Rounddown/Int/Trunc
  • Math Function

6. Time & Logic

  • Date & Time Functions
  • Workday/Edate/Eomonth
  • IF, IFS, Switch
  • Iferror, Ifna, ETC

7. Data Analysis

  • Sumif/Averageif/Countif
  • Lookup & Reference Theory
  • Vlookup Basics & Applications

8. Advanced Formulas

  • Vlookup Variants
  • Index + Match
  • Hlookup
  • Xlookup
  • Financial Formulas
  • AI Formula Creation

9. Data Summarization

  • Text to Columns
  • Data Validation
  • Consolidation
  • Pivot Table Theory & Creation
  • Pivot Design Options
  • Slicer
  • Timeline
  • Charts

10. Visualization

  • Dashboard Theory & Planning
  • KPI Creation
  • Visual Design
  • Dashboard Creation
  • Interview Questions
Launch Price Offer
Actual Value: ₹4,999
₹999

Limited Time Offer • One-Time Payment