HDI

₹3,600 ₹5,000

Core Advanced Excel Syllabus Components

Advanced Formulas & Functions:
Logical & Conditional: IF, AND, OR, NESTED IF, IFS, IFERROR.
Lookup & Reference: VLOOKUP, HLOOKUP, INDEX-MATCH (advanced), OFFSET, INDIRECT, CHOOSE.
Text & Data Cleaning: TRIM, CLEAN, CONCATENATE, LEFT/MID/RIGHT, FIND/SEARCH, SUBSTITUTE.
Date & Time Functions: EOMONTH, NETWORKDAYS, DATEDIF.

Core Advanced Excel Syllabus Components

Advanced Formulas & Functions:
Logical & Conditional: IF, AND, OR, NESTED IF, IFS, IFERROR.
Lookup & Reference: VLOOKUP, HLOOKUP, INDEX-MATCH (advanced), OFFSET, INDIRECT, CHOOSE.
Text & Data Cleaning: TRIM, CLEAN, CONCATENATE, LEFT/MID/RIGHT, FIND/SEARCH, SUBSTITUTE.
Date & Time Functions: EOMONTH, NETWORKDAYS, DATEDIF.
Data Analysis & Management:
Pivot Tables & Charts: Creating, calculated fields, grouping, slicers, and timelines.
Advanced Filtering & Sorting: Using advanced filters with complex criteria.
What-If Analysis: Goal Seek, Scenario Manager, Data Tables.
Data Validation: Creating dependent dropdown lists and custom validation rules.
Automation & Macros (VBA):
Recording, editing, and running Macros.
Introduction to VBA (Visual Basic for Applications): Creating user-defined functions and automating repetitive tasks.
Visualization & Reporting:
Interactive Dashboards.
Advanced Charts: Waterfall, Treemap, Sunburst, Box & Whisker.
Conditional Formatting (Advanced): Using formulas to format cells.

₹5000/-

Discounted Fees

₹ 3600/-

Course Duration

2 Months

0.0

Course Rating (0 reviews)

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

MS-OFFICE In Advanced Excel(S-AE-1356)