HDI

₹1,500 ₹2,000

Course Includes

Duration1 Months
Enrolled0
Lectures1
Videos0
Notes0
CertificateYes

What you'll learn

Advanced Excel focuses on enhancing data management, analysis, and automation capabilities beyond basic spreadsheet usage. Key areas include mastering complex formulas (XLOOKUP, INDEX-MATCH), pivot tables, data visualization, and automating tasks with Macros/VBA and Power Query to improve efficiency. It enables professionals to handle large datasets, perform financial analysis, and create interactive dashboards

Course Syllabus

Key Advanced Excel Components:

Advanced Formulas & Functions: Moving beyond basics to use nested formulas, text manipulation (LEFT, MID, RIGHT), and logical functions (IF, AND, OR) to handle complex scenarios.
Data Analysis Tools: Utilizing Pivot Tables and Pivot Charts to summarize large data, Goal Seek, and Solver for optimization.
Data Cleaning & Automation: Using Power Query for data transformation and Macros/VBA for automating repetitive tasks, saving significant time.
Data Visualization & Dashboards: Creating dynamic, interactive reports and dashboards using advanced charting techniques, slicers, and conditional formatting.
Modern Excel Features: Utilizing new functions like LAMBDA for custom formula creation and enhanced XLOOKUP for flexible data retrieval.
+8

Essential Advanced Functions to Master:

Lookup: XLOOKUP, INDEX & MATCH, VLOOKUP
Logical & Statistical: COUNTIFS, SUMIFS, IFERROR
Text & Data Manipulation: LEFT, MID, RIGHT, TEXTJOIN, UPPER/LOWER