Bestseller
Bestseller
Master the essential and advanced features of Microsoft Excel to improve productivity, analyze data efficiently, and create professional reports. This intermediate-level course is designed for students, job seekers, office professionals, accountants, and business owners who want to strengthen their Excel skills for academic and workplace success. By the end of the course, learners will be able to manage data, use advanced formulas, create dynamic charts, analyze information using PivotTables, and automate repetitive tasks with powerful Excel tools.
Module 1: Excel Fundamentals Review
Excel Interface & Navigation
Workbook and Worksheet Management
Cell Formatting & Number Formats
Freeze Panes & Split Window
Print Setup & Page Layout
Module 2: Advanced Formulas & Functions
IF, Nested IF
IFS Function
AND, OR, NOT
IFERROR
SUMIF & SUMIFS
COUNTIF & COUNTIFS
AVERAGEIF & AVERAGEIFS
Module 3: Lookup & Reference Functions
VLOOKUP
HLOOKUP
XLOOKUP (Excel 365)
INDEX & MATCH
CHOOSE Function
OFFSET Function
Module 4: Data Management
Sort & Multi-Level Sorting
Filtering & Advanced Filter
Remove Duplicates
Text to Columns
Flash Fill
Data Validation
Conditional Formatting
Module 5: Text Functions
LEFT, RIGHT, MID
LEN
TRIM
UPPER, LOWER, PROPER
CONCAT & TEXTJOIN
FIND & SEARCH
SUBSTITUTE & REPLACE
Module 6: Date & Time Functions
TODAY
NOW
DATE
YEAR, MONTH, DAY
DATEDIF
NETWORKDAYS
WORKDAY
Module 7: Pivot Tables & Pivot Charts
Creating Pivot Tables
Grouping Data
Calculated Fields
Pivot Charts
Slicers & Timelines
Module 8: Charts & Data Visualization
Column Charts
Bar Charts
Line Charts
Pie Charts
Combo Charts
Sparklines
Dashboard Basics
Module 9: Data Analysis Tools
What-If Analysis
Goal Seek
Scenario Manager
Data Tables
Basic Forecasting
Module 10: Protection & Collaboration
Protect Workbook
Protect Worksheet
Password Protection
Comments & Notes
Sharing Excel Files
Module 11: Basic Automation
Recording Macros
Running Macros
Introduction to VBA (Overview)
Module 12: Real-Time Projects
Sales Report
Attendance Sheet
Payroll Calculation
Expense Tracker
Inventory Management
Invoice Preparation
MIS Dashboard
Business Performance Report
Copyright © 2026 DITRP INDIA. All Rights Reserved
