This program introduces additional skills to develop your knowledge of Microsoft Excel by focusing on PivotTables, PivotCharts, SmartArt diagrams and conditional formatting.
Participants should be able to:
- Summarise and analyse data lists using PivotTables and PivotCharts
- Create and format eye-catching PivotCharts
- Use conditional formatting to highlight areas of interest in worksheets when specific conditions are met
- Use SmartArt to draw diagrams (e.g. list, process, cycle).