Course Overview
Transform your data analytics productivity with Microsoft Excel 2026. Master cell formatting, logical formulas (IF, AND, OR), lookup functions (XLOOKUP, INDEX/MATCH), Power Query ETL, Pivot Tables, interactive dashboards, and introduction to VBA macros.
What You'll Learn
- Construct complex lookup and conditional logic formulas (XLOOKUP, SUMIFS, FILTER)
- Automate data cleaning and transformation workflows using Power Query
- Build dynamic Pivot Tables, Slicers, and interactive KPI dashboards
- Analyze business financial models and sales performance reports
Key Skills Covered
Structured Learning Roadmap
Step-by-step milestone progression for Learn Excel from Beginner to Pro (2026)
Establish prerequisite knowledge in Business, setup local development environments, and master fundamental syntax and concepts.
Interface navigation, shortcuts, formatting, basic math functions. XLOOKUP, INDEX-MATCH, FILTER, SORT, UNIQUE, nested logical IF statements.
Importing CSVs, cleaning dirty data, Pivot Tables, calculated fields, slicers. Chart design, KPI cards, conditional formatting rules, macro recorder intro.
Synthesize all course modules into a production-grade portfolio project, undergo self-assessment quizzes, and earn your official Money Mitra Network certificate.
Course Curriculum
Module 1: Excel Essentials & Data Entry Mastery
Module 2: Advanced Lookup & Dynamic Array Formulas
Module 3: Power Query ETL & Pivot Table Analytics
Module 4: Executive Dashboards & Automation Basics
Instructor Profile
Prof. Arvind Sharma
15+ years mentoring engineering students and tech professionals in computer science fundamentals, design patterns, and industry best practices.
Prerequisites & Audience
Microsoft Excel (2019, 365, or 2021+) installed.
Data analysts, accountants, business managers, students, and administrative staff.