This introductory Microsoft Excel course is ideal for beginners who want to learn how to produce spreadsheets, work with data and perform basic calculations.

This course has been developed for people wanting to use Excel to perform calculations with a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.

• Work with multiple workbooks and worksheets at the same time
• Share and protect workbooks
• Automate workbook functionality
• Apply conditional logic
• Audit worksheets
• Present your data visually effectively

• Prepare data for PivotTables
• Create PivotTables from various data sources
• Analyse data using PivotTables
• Work with PivotCharts

• Utilise Power Pivot in your data analysis
• Visualise Power Pivot data
• Apply the advanced functions to your data

• Create advanced formulas
• Automate workbook functionality
• Apply conditional logic
• Visualise data using basic charts
• Implement advanced charting techniques
• Use PivotTables, slicers and PivotCharts to analyse data

• Understand the functions of Excel VBA
• Understand applications of Excel VBA to improve efficiency
• Use Excel VBA to enhance efficiency of the software
• Investigate and solve problems related to Excel VBA