Microsoft Excel

Contact me for a quote for your training requirements.

Officetrain Online Courses

Online courses are available in all versions of Microsoft Office up to and including Microsoft 365 (the new name for Office 365)

You can choose one of the standard courses or make up your own course by selecting topics relevant to you.

Each course is 90 minutes long (unless stated otherwise), and delegates receive the following:

• pdf set of notes on topics covered in the course
• demonstration files used during the course
• exercises to try
• PowerPoint file covering key points

Courses are delivered using Zoom (preferred) or Microsoft Teams.

Recordings of Zoom sessions are available for up to 7 days for delegates to download or stream.

Current courses are for Excel, but happy to deliver courses on other Office programs.  Please contact me for more details.

See our classroom course catalogue for an idea of some of the topics available

Current course list

Click the course name for more details

Excel 365 Formulas - Entering formulas, using absolute cell references, names, linking sheets, working with dates

Excel 365 Functions I - Understanding functions, writing formulas with functions including COUNTIFS and VLOOKUP, finding the right function

Excel Functions II
This course covers topics currently available only in Excel 365 Monthly Update channel
This course covers some of the biggest changes in Excel formulas in the past 35 years, including XLOOKUP, spill formulas and dynamic array functions such as FILTER, SORT and UNIQUE

Excel Presenting Information - Conditional formatting and creating charts.

Excel Tables and Pivot Tables - Using Tables to store data, and analysing data with Pivot Tables.

Excel Power Query and the Data Model - Automate data import and clean up with Power Query and build Pivot Tables from multiple tables of data using the Data Model

Introduction to Excel Macros - (45 minute course) Set up your PC and use the macro recorder to generate code.