HDI

Bestseller

0 rating

Certificate In MS-EXCEL (BASIC + ADVANCE)(S-M(+A-6643)

Last updated Mar, 2026
Certified Course

₹1,000 ₹1,500

Enquire Now

Course Includes

Duration1 Months
Enrolled0
Lectures10
Videos0
Notes0
CertificateYes

What you'll learn

An Advanced Excel course typically covers complex data analysis, automation, and visualization techniques, including advanced formulas (VLOOKUP, HLOOKUP, XLOOKUP, Index-Match), PivotTables, Power Query, VBA/Macros, data validation, and dashboard creation.

Course Syllabus

Core Syllabus Modules

Advanced Functions and Formulas:
Logical Functions: IF, AND, OR, NOT, Nested IF, IFERROR.
Lookup & Reference: VLOOKUP, HLOOKUP, XLOOKUP, INDEX-Match, Offset, Indirect.
Text & Date Functions: CONCATENATE, LEFT, RIGHT, MID, FIND, TEXT, DATE functions.
Array Formulas: Basic and advanced array formulas (Ctrl+Shift+Enter).
Data Analysis and Modeling:
PivotTables & PivotCharts: Grouping, Calculated Fields/Items, Slicers, and Timelines.
What-If Analysis: Goal Seek, Scenario Manager, Data Tables, Solver.
Data Validation: Custom validation rules, dropdown lists.
Sorting & Filtering: Custom sorts, Advanced Filter.
Data Visualization and Reporting:
Conditional Formatting: Creating rules with formulas.
Advanced Charts: Combo Charts, Secondary Axis, Treemap, Waterfall, Sunburst, Box and Whisker.
Dashboards: Creating interactive, dynamic dashboards.
Automation and Power Tools:
Macros & VBA: Recording, editing, and running Macros using Visual Basic for Applications.
Power Query: Extract, Transform, and Load (ETL) data from multiple sources.
Power Pivot & Power Map: Data modeling and 3D data visualization.
Data Management and Security:
Protection: Protecting cells, rows, columns, and workbook structure.
Linking & Consolidating: Linking data across multiple workbooks/sheets.