Bestseller
Bestseller
Learn Microsoft Excel from basics to advanced level with practical, job-oriented training. Master formulas, functions, data formatting, charts, Pivot Tables, advanced Excel tools, and real-world data management techniques. Perfect for students, job seekers, and working professionals.
Course Duration:-1 Months
Topics Covered
Excel Interface, Workbook & Worksheet, Rows/Columns, Cell References
Formatting, Number Formats, Custom Formatting, Borders, Alignment
Basic Formulas & Functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
Relative, Absolute & Mixed Cell References
Logical Functions: IF, AND, OR, NOT
Nested IF, IFERROR
SUMIF, COUNTIF
SUMIFS
VLOOKUP – Basic & Advanced
HLOOKUP
INDEX + MATCH
Multiple Criteria Lookup
Text Functions: LEFT, RIGHT, MID, LEN, TRIM
Text Functions: UPPER, LOWER, PROPER, CONCAT, TEXTJOIN, SUBSTITUTE
DATEDIF, EDATE, EOMONTH, NETWORKDAYS, WORKDAY
Sort, Filter, Custom Sort, Advanced Filter
Data Validation, Drop-down List, Input Restrictions
Conditional Formatting – Basic & Advanced
Excel Tables, Structured References, Dynamic Data
Pivot Table – Creation, Rows, Columns, Values & Filters
Pivot Table – Grouping, Sorting, Calculated Values
Pivot Chart, Slicer & Timeline
Charts: Column, Bar, Line, Pie, Area & Combo Chart
MIS Reporting: Employee, Attendance, Sales & Inventory
Dashboard Design: KPI, Charts, Slicers, Dynamic Reports
What-If Analysis, Goal Seek, Scenario Manager, Named Range, Protection
Final Project + Revision + Practical Test
Who can apply for this course
Minimum 10th pass and Basic Computer Knowledge.
Copyright © 2026 DITRP INDIA. All Rights Reserved
