Learn about Microsoft Excel and how it applies to business reporting. Discovering Excel will teach you how to develop spreadsheets, use formulas and formatting as well as how to create charts and navigate throughout Microsoft Excel. Gain a comprehensive knowledge of how Excel can work for you.
Excel On Steroids
Excel on Steroids is a specialised training programme, comprising of three workshops, focusing on key Excel functionality for powerful business reporting and decision-making!
Formulas and Functions
Ribbons, Copy & Move Worksheets, Paste special, Conditional Formatting, Worksheet Protection, Named Ranges, Lookup, Text, Logical, Information, Statistical & Mathematical Functions
Data lists and Macros
Custom List, Subtotals, Filtering, Data Validation, Custom Views, Scenarios, Macros
PivotTables and Pivot Charts
Understanding & Creating a PivotTable, Modifying & Formatting a PivotTable, Sparkline’s, Calculated Fields, Grouping, Creating a PivotChart
Excel On Steroids Plus
Excel on Steroids Plus: Data Analysis, Visualisation and Dashboards will teach you how to model your data so you can create interactive dashboard reports that will make analysing your data much easier, and will give you clearer insights so you can make smart business decisions.