Advanced Excel
Improve spreadsheet skills through formulas, data organisation, analysis and reporting techniques.
Course Overview
This course focuses on spreadsheet features used to manage, analyse and present business data more efficiently.
What You Will Learn
- Advanced spreadsheet formatting
- Logical and lookup functions
- Data sorting and filtering
- Conditional formatting
- PivotTables and PivotCharts
- Data validation
- Reporting and dashboard fundamentals
Course Benefits
- Work more efficiently with spreadsheets.
- Analyse and organise business data.
- Create useful summaries and reports.