HDI

Bestseller

0 rating

CERTIFICATE In Advanced Excel (Data Analytics Using Spreadsheets)(S-AE(AUS-2057)

Last updated Apr, 2026
Certified Course

₹5,000 ₹7,000

Course Includes

Duration3 Months
Enrolled2
Lectures45
Videos0
Notes0
CertificateYes

What you'll learn

Advanced Excel (Data Analytics Using Spreadsheets) course provides complete practical training in advanced Excel tools, formulas, functions, pivot table, charts, dashboard and data analysis. This course is useful for students, office staff, accountants and data entry professionals.

Show More

Course Syllabus

Excel Interface & Workbook Basics
Data Entry and Data Formatting
Cell Referencing (Relative/Absolute/Mixed)
Text Functions (LEFT, RIGHT, MID, LEN, TRIM)
Logical Functions (IF, AND, OR, IFERROR)
Math Functions (SUM, ROUND, MOD)
Statistical Functions (MAX, MIN, COUNT)
SUMIF, SUMIFS, COUNTIF, COUNTIFS
Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
INDEX + MATCH
Date & Time Functions (TODAY, NOW, DATEDIF)
Conditional Formatting
Data Validation (Drop-down List)
Sorting & Filtering (Advanced Filter)
Remove Duplicates
Text to Columns
Flash Fill
Pivot Table Creation & Formatting
Pivot Chart
Charts & Graphs
Slicers & Timeline
Subtotal & Grouping
What-if Analysis (Goal Seek, Scenario, Data Table)
Dashboard Basics
Protect Sheet & Workbook
Printing Setup
Excel Shortcut Keys
Mini Project / Practical Work

Course Fees

Course Fees

:

₹7000/-

Discounted Fees

:

₹ 5000/-

Course Duration

:

3 Months

Review

0.0

Course Rating (0 reviews)

0%

0%

0%

0%

0%

Featured review

No reviews yet. Be the first to review this course!

Copyright © 2026 DITRP INDIA. All Rights Reserved

Review