Sharp Institute – Computer & Professional Training Institute

₹3,000 ₹5,000

Course Includes

Duration1 Month
Enrolled0
Lectures25
Videos0
Notes0
CertificateYes

What you'll learn

10TH PASSED

Course Syllabus

Advanced Excel courses cover high-level data analysis, automation, and visualization techniques, focusing on PivotTables, advanced formulas (INDEX/MATCH, XLOOKUP), VBA macros, and dashboard creation. Key topics include data modeling, Power Query/Pivot, scenarios, and complex chart types (waterfall, Treemap).

Core Components of Advanced Excel

Advanced Formulas & Functions: Nested IF statements, VLOOKUP/HLOOKUP/XLOOKUP, INDEX & MATCH, SUMIFS, COUNTIFS, OFFSET, INDIRECT, and date/time functions.
Data Analysis & Visualization: Advanced PivotTables (calculated fields, grouping, slicers), PivotCharts, and interactive Dashboards.
Data Tools & Cleaning: Data Validation, Advanced Filter, Remove Duplicates, Text-to-Columns, and Goal Seek/Scenario Manager for sensitivity analysis.
Automation & VBA (Macros): Recording and editing macros, Introduction to VBA (Visual Basic for Applications), writing custom functions, loops, and handling errors.
Power Tools & New Features: Power Query for data transformation, Power Pivot for data modeling, 3D Maps, and Dynamic Array formulas (365