Digital SkillsProductivityMEAL2 100% HRDF claimable

Microsoft Excel Advanced – Level II

Equip yourself with advanced data analysis and visualization skills in Excel. Perform complex calculations with multiple criteria, leverage automated analysis tools, summarize data using PivotTables and PivotCharts, and visualize with advanced charting techniques.

1 DayPEOPLElogy

What you'll learn

Calculate data using advanced functions with single and multiple criteria
Apply financial and SUMPRODUCT functions
Perform What-If analysis with scenarios and data tables
Create PivotTables and PivotCharts for dynamic reporting
Visualize data using advanced chart settings and Sparklines

Course modules (6)

01Advanced data analysis functions (SUMIFS, COUNTIFS, SUMPRODUCT)

02Automated analysis tools (Goal Seek, Scenarios)

03PivotTables and PivotCharts

04Slicers and Timelines

05Advanced charting and Sparklines

06Importing external data