Advanced Excel is designed for students and professionals who want to master data analysis, automation, reporting, dashboards, and advanced Excel functions. The course focuses on practical, real-world projects.
Advanced Excel Formulas & Functions
Logical Functions – IF, IFS, AND, OR
Lookup Functions – XLOOKUP, VLOOKUP, HLOOKUP
INDEX & MATCH
Advanced Text & Date Functions
Conditional Formatting
Data Validation
Sorting & Advanced Filtering
Pivot Tables & Pivot Charts
Power Query
What-If Analysis
Charts & Data Visualization
Interactive Dashboard Design
Macros & VBA Basics
No reviews yet. Be the first to review this course!
Enroll in your desired course
Copyright © 2026 DITRP INDIA. All Rights Reserved