MS Excel – Level 2

On completion of this course, students will be able to leverage the power of data analysis and presentation to make informed, intelligent organisational decisions.

Target Audience:

This course is for students who have foundational skills in Excel and who need to take advantage of some of the higher-level functionality in Excel to analyse and present data.

View Brochure


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