Courses

Prerequisite: No previous experience with Excel is required, but a good working knowledge of Windows is essential.

Duration: 12 hours (4 x 1/2 days)

Overview 

  • Start Excel 

  • Excel window basics 

  • Workbook and window views

 

Basic data entry 

  • Create workbooks 

  • Save workbooks 

  • Enter and edit basic data in a worksheet  

 

Basic formatting

  • Insert and delete cells 

  • Manual formatting 

  • Use the format painter 

 

Basic formulas 

 

  • Structure calculations

  • Understand the difference between functions and formulas 

 

Introduction to functions 

  • Summarise data with functions:

    • SUM

    • AVERAGE

    • MIN

    • MAX

  • Absolute referencing

 

Work with rows and columns 

  • Manage rows and columns 

  • Use themes 

 

Printing & Backstage 

  • Print with Backstage 

  • Change the Excel environment 

 

Workbook management 

  • Organise worksheets 

  • Use Zoom 

  • Find and replace data 

Closed

Prerequisite: Completion of Excel Essential skills (Basic), or a very good working knowledge of Excel.

Duration: 12 hours (4 x 1/2 days)

Advanced formatting

  • Conditional formatting
  • Work with styles
  • Hyperlinks

 

Data management 

  • Import data 

  • Sort data 

  • Filter data 

  • Outline and subtotal data 

  • Flash fill 

  • Tables

 

Intermediate formulas

  • Excel cell references
  • SUMIF
  • COUNTIF
  • AVERAGEIF

 

Basic logic functions

  • IF
  • AND 
  • OR

 

Data lookup functions

  • Introduction to XLOOKUP*

 

Introduction to charting 

  • Build charts 

  • Format chart

  • Use quick analysis tools 

 

Introduction to Pivot Tables

  • Create and modify PivotTables

  • Introduction to PivotCharts

 

Workbook protection

  • Manage workbooks
  • Basic workbook protection

Data analysis introduction

  • Basic use of data analysis too
Closed

Prerequisite: Completion of Excel Intermediate, or a very good working knowledge of Excel.

Duration: 12 hours (4 x 1/2 days)

Use advanced functions

  • Nested IF
  • IFS
  • SUMIFS
  • COUNTIFS
  • AVERAGEIFS 
  • TEXTJOIN
  • SWITCH

 

Advanced logic and lookups 

  • Advanced use of XLOOKUP

  • Two-way lookup

  • Multiple match

 

Advanced charting 

  • Create advanced charts 

  • Format sparklines

  • Funnel charts

 

Deep dive in PivotTables

  • In-depth look at PivotTables

  • Advanced PivotCharts

  • Relationships

 

Power Query & Power pivot

  • Introduction to Power Query & Power Pivot
  • Data transformation

 

3D models & Dynamic arrays

  • Insert 3D models
  • Work with dynamic arrays
    • FILTER
    • SORT

 

Advanced workbook management

  • Manage advanced workbooks
  • Review and advanced protection

 

Collaboration features

  • Introduction to real-time collaboration
  • Sharing features
Closed

Workshops

Prerequisite: Completion of Excel Advanced course 

Duration: 3 hours  

Names ranges 

  • Recap using named ranges 

  • Change a named range's size  

 

Introduction to array functions 

  • Perform calculations using array functions 

  • Examine the advantages and disadvantages of array functions 

  • Create single and multi-cell array formulas 

 

Text and date formulas 

  • Use the date function to calculate duration 

  • Manipulate text using text functions 

Closed

Prerequisite: Completion of Excel Advanced course 

Duration: 3 hours

Organise worksheet and table data

  • Create and modify tables

  •  Format tables

  • Sort/filter data

 

Pivot Tables

  • Create a PivotTable to analyse worksheet data

  • Filter data using Slicers

  • Analyse data using Pivot Charts

  • Adjust the layout

  • Manage subtotals and grand totals

  • Add calculated columns & fields

  • Apply conditional formatting

Closed

Prerequisite: Completion of Excel Essentials skills

Duration: 3 hours

Names ranges 

  • Sort data

  •  Apply filters to data

  • Manage tables

  • Work with functions and formulas

    • Specialised functions (IF Function, VLOOKUP)

  • Maintain data with conditional formatting

  • Use advanced paste options

  • Save worksheets as different file types

Closed

Prerequisite: Completion of Excel Intermediate course or a very good working knowledge of Excel.

Duration: 3 hours

  • Clean up your data

  • Sort and filter data

  • Use data analysis formulas 

  • Create and manipulate PivotTables

  • Format and conditional formatting in PivotTables

  • Introduce PowerPivot and data model and Data Analysis Expressions (DAX)

Closed