Courses

Excel Essentials

Excel Intermediate

Excel Advanced

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

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

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

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

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

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 

 

 

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

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

 new features added

Workshops

We recommend that you bring along your workbooks and questions for an interactive session.

Excel Formula Magic 

Excel PivotTable 

Excel Marks processing 

Excel Data Analysis 

Prerequisite: Completion of Excel Advanced course 

Prerequisite: Completion of Excel Advanced course 

Prerequisite: Completion of Excel Essentials skills  

Prerequisite: Completion of Excel Intermediate course or a very good working knowledge of Excel 
Duration: 3 hours   Duration: 3 hours   Duration: 3 hours 

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 

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

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

  • 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)