Coworkers collaborating around a table with laptops in a rustic office

Microsoft excel training courses

Through tailored training and practical learning resources, we help businesses simplify technology, improve productivity and empower people to work smarter.

Microsoft Excel is a fundamental tool for working in all types of businesses, you might be keeping track of orders or listing out attendees to an event, right through to full financial company information, Excel can do it all! But do you and your team use the full functionality? Have a look at these topics to see what your teams could benefit from learning to improve the way their work and their efficiency.

Mix and match topics below to create the course that suites your teams:

MAke Excel work For you

Example topics for this course

  • Using Excel shortcuts

  • Creating Formulas using Absolute References

  • Creating Named Ranges in Formulas

  • VLOOKUP, HLOOKUP, XLOOKUP

  • IF, COUNTIF, SUMIF

  • Text Functions

  • Working with Databases

  • PivotTables

  • What If Analysis: Scenario Manager, Goal Seek, Solver

  • Protecting cells and workbooks

Getting started with Excel

Example topics for this course

  • Navigating Excel

  • Setting up a spreadsheet in Excel

  • Formatting

  • Creating Formulas

  • Using Functions

  • Conditional Formatting

  • Printing options

  • Adding Graphics & SmartArt

  • Creating Charts

  • Setting Passwords Restrictions

Becoming an expert in Excel

Example topics for this course

  • Creating Marcos

  • Data Analysis

    • Importing and Exporting, Analyse Data

    • Power Query, Power Pivot

  • Advanced Charts

    • Waterfall, Treemap

  • Automation

    • PowerAutomate

    • Forms

Excel working as a database

Example topics for this course

  • Setting up Tables

  • Freeze Panes

  • AutoFilter

  • Sorting Data

  • Conditional Formatting

  • Using PivotTables

  • Database Charts

  • Adding a Microsoft Form to collect data

We see a future where every business and every employee has the skills, confidence and support to make technology simpler, more productive and more rewarding.

People

✳︎

Tailored

✳︎

Simple

✳︎

Relevant

✳︎

People ✳︎ Tailored ✳︎ Simple ✳︎ Relevant ✳︎