Bestseller
Bestseller
Advance Excel is a career-oriented and completely practical-based course, designed to make students proficient in Data Analysis, Reporting, and Automation.
Through this course, learners gain professional-level skills inAdvanced Excel Functions, Data Tools, Dashboards, Pivot Tables, Macros, and MIS Reports.
The course enables students to learn real-time data handling, large data management, error reduction techniques, and automated report creation, preparing them for roles in Corporate, Banking, Accounts, HR, and other data-related fields.
· Excel Interface & Shortcuts
· Workbook & Worksheet Management
· Data Entry Techniques
· Formatting (Custom, Conditional)
· Logical Functions: IF, AND, OR, IFERROR
· Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
· Text Functions: LEFT, RIGHT, MID, LEN, TRIM
· Date & Time Functions: TODAY, NOW, DATE, DATEDIF
· Mathematical Functions: SUMIF, COUNTIF, AVERAGEIF
· Attendance Sheet
· Salary Sheet
· 10 Different type Shees
· Sorting & Filtering (Advanced Filter)
· Data Validation (Drop-down Lists)
· Remove Duplicates
· Text to Columns
· Creating Pivot Tables
· Grouping Data
· Calculated Fields
· Pivot Charts
· Slicers & Timelines
· Column, Bar, Line, Pie Charts
· Dynamic Charts
· Conditional Formatting for Reports
· MIS Report
· Sales Analysis Dashboard
· Interactive Dashboards
· Use of Pivot + Charts
· KPI Indicators
· Professional Layout Design
· Introduction to Macros
· Recording Macros
· Assigning Macros to Buttons
· Basic VBA Concepts
· What-If Analysis
· Goal Seek & Scenario Manager
· Power Query (Basic)
· Protecting Workbook & Sheets
· Real-time MIS / Business Report
· Complete Dashboard Project
· Weekly Assignments
· Monthly Tests
· Final Project Evaluation
· Viva / Interview-based Questions
Copyright © 2026 DITRP INDIA. All Rights Reserved
