Microsoft Excel Courses

Excel is the market leader in spreadsheets. It can track your expenses, create fantastic charts and help with complex analysis of data. We have three levels of Excel.

All levels can be customised or combined to suit your requirements or we can write a course specifically for you! (Standard course outlines are for a one-day course.)

PDF versions of the Course Outlines are available – contact us.

Excel Level 1

Lesson 1: Getting Started with Excel

  • Identify the Elements of the Excel Interface
  • Navigate and Select Cells in Worksheets
  • Customise the Excel Interface
  • Create a Basic Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet

  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas

Lesson 3: Modifying a Worksheet

  • Edit Worksheet Data
  • Find and Replace Data
  • Manipulate Worksheet Elements

Lesson 4: Modifying the Appearance of a Worksheet

  • Apply Font Properties
  • Add Borders and Colours to Cells
  • Align Content in a Cell
  • Apply Number Formatting
  • Apply Cell Styles

Lesson 5: Managing an Excel Workbook

  • Manage Worksheets
  • View Worksheets and Workbooks

Lesson 6: Printing Excel Workbooks

  • Define the Page Layout
  • Print a Workbook

Excel Level 2

Lesson 1: Calculating Data with Advanced Formulas

  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialised Functions
  • Analyse Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data

Lesson 3: Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts

  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyse Data Using PivotCharts

Lesson 5: Inserting Graphic Objects

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing the Excel Environment

  • Customise the Excel Environment
  • Customise Workbooks
  • Manage Themes
  • Create and Use Templates

Excel Level 3

Lesson 1: Streamlining Workflow

  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria

Lesson 2: Collaborating with Other Users

  • Protect Files
  • Password Protecting Workbooks
  • Set Revision Tracking
  • Review Tracked Revisions

Lesson 3: Auditing Worksheets

  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline

Lesson 4: Analysing Data

  • Create a Trendline
  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis

Lesson 5: Working with Multiple Workbooks

  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links