• Create, edit and format spreadsheets
• Navigate within worksheets and books
• Use Insert Function to create built-in functions
• Work with absolute references
• Create named ranges
• Create Tables within Excel
• Sort and filter data

• Create macros to automate common tasks
• Collaborate with others by tracking changes in workbooks
• Create and manipulate PivotTables and Pivot Charts
• Use advanced techniques to analyse data
• Work with data validation tools

Module 1: Creating a Macro

• Creating a Macro
• Comparing Relative and Absolute Macros
• Running a Macro
• Editing a Macro
• Assigning Shortcuts to Macros

Module 2 - Collaborating With Others

• Protection
• Track Changes

Module 3 - Creating PivotTables, PivotCharts and Slicers

• Creating a PivotTable
• Amending and Updating Fields
• Adding Calculations and Grouping
• Creating a PivotChart
• Using Slicers and Timelines

Module 4 - Analysing Data

• Creating Scenarios
• Using Goal Seek
• Linking to External Workbooks

Module 5 - Data Validation

• Number Validation
• Message Prompts and Alerts