Outcomes
| Customizing the Excel Environment | • Configure Excel options • Customise the ribbon and the Quick Access toolbar • Enable Excel add-ins |
| Creating Advanced Formulas | • Use range names in formulas • Use specialized functions • Use array formulas |
| Analysing Data with Functions and Conditional Formatting | • Analyse data by using text and logical functions • Apply advanced conditional formatting |
| Organising and Analysing Datasets and Tables | • Create and modify tables • Sort data • Filter data - Use SUBTOTAL and Database Functions |
| Visualizing Data with Basic Charts | • Create charts • Modify and format charts |
| Analysing Data with PivotTables, Slicers, and Pivot Charts | • Create a PivotTable • Analyse PivotTable data • Present data with PivotCharts • Filter data by using Slicers |
