Contact me for a quote for your training requirements.
I can also cover other topics not listed here - please ask if you have a special requirement
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:
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
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.