Bestseller
Bestseller
The Excel Course is a practical short-term program designed to help students master data handling and analysis skills. It covers key topics such as formulas, functions, charts, and report creation, enabling users to efficiently manage and analyze data.
This course is ideal for students, job seekers, and professionals who want to improve their productivity, data analysis skills, and office work efficiency, with a strong focus on real-world tasks and hands-on practice.
Introduction to MS Excel
Workbook and Worksheet Basics
Rows, Columns, and Cells
Data Entry and Formatting
Basic Formulas (SUM, AVERAGE, COUNT)
Relative and Absolute Cell References
AutoFill and Flash Fill
Logical Functions (IF, AND, OR)
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
Text Functions (LEFT, RIGHT, MID, LEN, CONCAT)
Date and Time Functions
Sorting and Filtering Data
Conditional Formatting
Data Validation
Remove Duplicates
Creating Charts (Bar, Pie, Line)
Chart Formatting and Design
Pivot Tables and Pivot Charts
Basic Dashboard Creation
Freeze Panes and Page Setup
Printing in Excel
Important Keyboard Shortcuts
Protect Sheet and Workbook
Real-World Projects (Sales Report, Expense Tracker, Data Analysis)
Copyright © 2026 DITRP INDIA. All Rights Reserved
