Advanced pivot table techniques Statistical analysis workshop Real-world analysis scenarios Project presentations

What-if analysis Goal Seek and Solver Scenario Manager Advanced filtering techniques

Descriptive statistics Statistical functions Analysis ToolPak features Correlation and regression

Creating and customizing pivot tables Calculated fields and items Grouping and filtering data Pivot charts basics

Hands-on data cleaning workshop Common cleaning scenarios Tool demonstrations Project review

VLOOKUP, HLOOKUP INDEX and MATCH functions Conditional formatting Custom sorting and filtering

TRIM, CLEAN, and SUBSTITUTE functions Removing duplicates Handling missing values Data validation and verification ERROR handling functions