Bestseller
This course covers Excel from basic to advanced level, including formulas, data analysis, pivot tables, and dashboards. It also introduces automation tools like Macros and VBA to make you job-ready for office and MIS roles.
Module 1: Excel Fundamentals
Excel Interface (Workbook, Worksheet, Ribbon)
Data Entry & Editing
Formatting (Font, Border, Alignment)
Sort & Filter
Data Validation
Module 2: Formulas & Functions
Basic Formulas
Logical Functions (IF, AND, OR, IFS)
Lookup Functions (VLOOKUP, XLOOKUP)
INDEX & MATCH
Text & Date Functions
Module 3: Data Analysis
Pivot Table (Basic to Advanced)
Pivot Chart
Data Cleaning
Remove Duplicates
Flash Fill
Module 4: Advanced Excel Tools
Conditional Formatting (Advanced)
What-if Analysis
Goal Seek & Scenario Manager
Advanced Charts
Module 5: Automation & Power Tools
Macro Recording
VBA Basics
Power Query
Power Pivot
Modules 6: Dashboard & Project Work
Interactive Dashboard Design
MIS Report Preparation
Data Visualization
Final Project (Real-life Report)
Copyright © 2026 DITRP INDIA. All Rights Reserved
