Training Topics

While this list covers some of the main topics we offer, it's not everything we do. We’re happy to accommodate individual requests and can tailor training to meet your specific needs. You can also mix and match topics based on your prior knowledge and goals.

Spreadsheets (in Excel)

• What are spreadsheets? An introduction to using Microsoft Excel

• Microsoft Excel’s interface: rows, columns, and cells

• Formatting text and numbers

• Entering Data

• Cursor shapes

• Using SUM to add up numbers

• Introduction to using functions

• Introduction to writing your own formulas

• Data entry and techniques for manipulating text

• How to move around efficiently

• Techniques for working more efficiently

• Managing worksheets (rename, insert, delete)

• Borders

• Copying and moving data

• Using Autofill

• Sorting data

• Using filters

• Conditional formatting

• Introduction to charts

• Using tables

• Customising charts

• Absolute and relative cell referencing

• Common functions

• Functions: logical functions such as IF, AND, OR

• Functions: lookup functions such as XLOOKUP, MATCH

• Functions: text functions such as CONCAT, LEFT, RIGHT

• Functions: time functions

• Introduction to pivot tables

• Control input values with data validation

Word Processing (in Word)

• What is word processing? An introduction to using Microsoft Word

• Word’s interface and menus

• Creating simple lists

• Introduction to Styles

• Setting up a page

• Formatting text

• Techniques for working more efficiently

• Positiong text on the page: alignment

• Positiong text on the page: tabs

• Selection techniques

• Dictating

• Using the Editor

• Add pictures to your document

• Add diagrams using SmartArt

• Understanding line and paragraph spacing

• Save, Save As, and Save a Copy

• Creating and saving documents

• Printing

• Graphics with shapes and icons

• Advanced lists

• Create your own style

• Positiong text on the page: text boxes

• Positiong text on the page: tables

• Creating tables

• Page numbers, headers, and footers

• Create your own diagrams

• Create a table of contents

• Citations and bibliographies

• Captioning pictures and tables

• Mail merge

• Using sections in long documents

• Custom tabs

• Tips for longer documents

Email (in Outlook)

• Using the online version of Outlook

• Introduction to Outlook 365 desktop app

• Introduction to the New Outlook app

• Using folders

• Prioritising your emails

• Categorising your emails

• Creating rules

Presentations (in PowerPoint)

• What are presentations? An introduction to using PowerPoint

• PowerPoint basics: create slides, add text and images

• Presentations: how to avoid boring your audience

• PowerPoint: Introduction to animations

• PowerPoint: Introduction to transitions

• Showing your PowerPoint presentation

• PowerPoint: Lifting your slides visually

Google Drive, Docs, and Sheets

• What is Google Drive?

• Introduction to Google Docs

• Introduction to Google Sheets

• Google Drive: Sharing files