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