Course curriculum

  • 1

    Welcome

    • Getting Started
  • 2

    Exploring Excel

    • Starting Excel from the Desktop

    • Screen Elements

    • The Excel Ribbon

    • The QAT (Quick Access Toolbar)

    • The Right Click Menu

    • Excel Options

    • Creating New Workbooks

    • Opening a Workbook

    • Quiz: How much do you know about Excel Screen Elements and Menus?
  • 3

    Creating Formulas

    • Simple Functions (Auto Sum)

    • Mathematical Operators

    • Comparison Operators

    • Comparison Operators

    • Combining Comparison Operators

    • Referencing Cells and Ranges

    • More Complex Functions (The Function Builder)

    • Order of Operations (BODMAS)
  • 4

    Fill Techniques

    • The Fill Handle

    • Built in & Custom Fill Lists

    • Fill a Series

    • Flash Fill
  • 5

    Sorting & Filtering

    • Navigating Spreadsheets

    • Basic Sort

    • Multi-level Sort

    • Applying a Filter

    • Filtering Specific Items

    • Compound Filters

    • Subtotalling
  • 6

    Working with Data

    • Resizing Column Widths

    • Resizing Row Heights

    • Hiding and Unhiding Columns

    • Hiding and Unhiding Rows

    • Navigating a Range of Data

    • Navigating Large Data Ranges

    • Basic Number Formatting

    • Let's see what you have learned about data!
  • 7

    Calculation Techniques

    • Simple Functions (Auto Sum)

    • Mathematical Operators

    • Comparison Operators

    • More Complex Functions (The Function Builder)

    • Order of Operations (BODMAS)
  • 8

    Formula Referencing

    • Relative Referencing

    • Absolute Referencing

    • Mixed Referencing
  • 9

    Naming Cells & Ranges

    • Creating Named Cells

    • Creating Named Ranges

    • Scoping Names

    • Dynamic Named Ranges
  • 10

    Analysis Formulas

    • CountIf Formulas

    • SumIf Formulas

    • AverageIf Formula

    • Max

    • Max

    • CountIfs Formula

    • CountIfs Formula - with Date Range

    • SumIfs Formula

    • Sumifs Formula - with Date Range
  • 11

    Logical Functions

    • Comparison Operators

    • Combining Comparison Operators

    • AND

    • OR

    • IF

    • Combining AND & OR Functions

    • IF & AND

    • Combining IF & OR
  • 12

    Conditional Formatting

    • Highlight Cell Rules

    • Top & Bottom Rules

    • Colour Scales

    • Icon Sets

    • Format with a Formula
  • 13

    Pivot Tables

    • Creating a Pivot Table

    • Pivot Table Design Options

    • Pivot Table Number Formatting

    • Calculating Items

    • Calculating Items

    • Filters & Slicers

    • Refreshing Data

    • Timelines
  • 14

    Pivot Charts

    • Creating a Pivot Chart

    • Pivot Chart Design Options

    • Filters & Slicers
  • 15

    Advanced Pivot Options

    • Summarising Without Calculation

    • Running Totals
  • 16

    Lookup Functions

    • VLookUp - Introduction

    • VLookup

    • Index & Match

    • Nested Functions

    • Protecting your Formulas
  • 17

    Macros

    • Macro Security Settings

    • Saving a Workbook as Macro Enabled

    • Recording Macros

    • Reviewing the Code

    • Filtering, Copying and Creating New Sheets

    • Working with Variables and Input Boxes

    • Programming a Loop

    • Command Buttons

    • Ribbon Buttons and Tabs
  • 18

    Charting

    • Create a Chart

    • Customising Chart Elements

    • Modifying Clustered Column Charts

    • Creating a Combination Chart

    • Creating a 100% Stacked Column
  • 19

    Data Linking

    • Linking Cells witin a Worksheet

    • Link Cells Between Worksheets

    • Link to Cells in External Workbooks

    • Creating Links between Applications
  • 20

    Thanks!

    • Tell us what you think!