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

Categories: ,

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

Related products