Bestseller
Bestseller
Master Advanced Excel with practical, hands-on training. Learn advanced formulas and functions, data analysis, Pivot Tables, charts, conditional formatting, data validation, lookup functions (VLOOKUP, XLOOKUP), dashboards, and report automation. Develop the skills required to manage data efficiently and prepare professional reports for real-world business and office applications.
Excel Basics & Advanced Formatting
Advanced Formulas and Functions
IF, Nested IF & IFS Functions
VLOOKUP, HLOOKUP & XLOOKUP
INDEX & MATCH Functions
Text Functions
Date & Time Functions
Conditional Formatting
Data Validation & Drop-down Lists
Sorting, Filtering & Advanced Filter
Pivot Tables & Pivot Charts
Charts and Graphs
What-If Analysis
Goal Seek & Scenario Manager
Data Consolidation
Remove Duplicates & Data Cleaning
Excel Tables & Structured References
Dashboard Creation
Copyright © 2026 DITRP INDIA. All Rights Reserved
