Introduce your staff to time-saving and productivity-boosting features in Microsoft Office using our bite-size sessions.

Just choose 3 sessions (delivered over 1 day) from the extensive list of End User Applications on the following pages, these sessions will target specific topics.

More detailed training courses are also available on all Office applications, please contact us for more details.

Delivery Method

Virtual Training accessible from your desktop or laptop, session will be fully interactive and will require everyone to have their own PC or Laptop, headset/speaker to participate in the session and would benefit from having 2 screens. These sessions are also available to run as live face-to-face classroom events.

Read more


  • Use of mouse and keyboard
  • Ability to navigate the Windows environments
  • Open and close programs
Read more



90 min sessions

1. Excel (The Basics)

In this session, you will learn how to create a basic spreadsheet.

  • Creating and editing a workbook
  • Creating Basic Formulas including AutoSum
  • Formatting a worksheet (Text formatting and cell alignment)
  • Page layout options / printing a worksheet

2. Excel (Beyond The Basics)

In this session, you will build on Excel (The Basics) and use more features to enhance your spreadsheet

  • Introducing Functions (SUM, AVERAGE, MIN, MAX, COUNT)
  • Understanding Relative and Absolute cell references
  • Further formatting features (Format Painter, Cell Styles)
  • Managing worksheets and workbooks

3. Working with Data Lists

In this session, you will learn how to manage Data Lists using a variety of commands

  • Flash Fill
  • Text to columns
  • Sorting and filtering
  • Creating Custom Views
  • Using Subtotals

4. Mastering Excel Tables

In this session, you will see the benefits of using Excel Tables to further analyse data lists

  • Creating and Formatting Excel Tables
  • Add calculations and totals to a table
  • Using Slicers to filter data
  • Managing tables

5. Visual Tools

In this session, you will insert Charts and use Sparklines to show trends and use Conditional Formatting to format cells based on rules.

  • Creating and managing Charts
  • Analyse data using Sparklines
  • Creating Conditional Formatting
  • Using Quick Analysis

6. Collaborating with Others

In this session, you will use features that allow you to control the entry of data into worksheets that are shared with others

  • Data Validation
  • Conditional Data Validation
  • Protecting Cells, worksheets and workbooks

7. Logical Functions

In this session, you will use some of Excel’s Logical Functions to test conditions within cells

  • COUNTIFS, SUMIFS, AVERAGEIFS (multiple criteria)
  • IF Function with AND / OR

8. Lookup and Reference Functions

In this session, you will create different LOOKUP functions to search for values and return value(s) from another location.

  • Office 365 / Office 2016: VLOOKUP Functions
  • Office 365 / Office 2019 Only (XLOOKUP / Dynamic Arrays)

9. Pivot Tables and Pivot Charts

In this session, you will use Pivot Tables to calculate, summarise and analyse data, showing trends and patterns in your data.

  • Create and modify Pivot Tables
  • Manage and configure Pivot Table fields
  • Creating interactive reports using Slicers and Timelines
  • Creating Pivot Charts

10. Text Functions

In this session, you will use some of Excel’s Text Functions to transform, extract and split data.

  • Flash Fill
  • Get and transform data using Power Query (if time)


90 min sessions

1. Word (The Basics)

In this session, you will learn how to create, format and print a Word document.

  • Creating and editing a document
  • Formatting Text and Paragraphs
  • Adding Headers and Footers
  • Printing a document

2. Word (Beyond the Basics)

In this session, you will build on Word (The Basics) and use more features to enhance your document.

  • Font and paragraph formatting
  • Borders, Shading, Format Painter, Indents, Spacing
  • Bullets, Numbering and Multi-level numbering
  • Creating Styles
  • Navigation Pane

3. Working with Graphics, Word Tables and Excel Charts

In this session, you will enhance your documents by inserting graphics, Word Tables and Excel Charts.

  • Inserting Pictures
  • Adding SmartArt Diagrams
  • Create, Modify and Format Word Tables
  • Inserting an Excel Chart

4. Word Mail Merge

This session will show you how to use Mail Merge to automate document creation.

  • Creating a Mail Merge Letter
  • Data Source linking using Word and Excel
  • Creating Mailing Labels

5. Collaborating on Documents

In this session, you will learn how to use collaboration tools in Word to manage and review document changes.

  • Inserting Comments
  • Using Track Changes
  • Track Changes Options
  • Review Tracked Changes
  • Restrict Editing

6. Managing Long Documents

In this session, you will incorporate various referencing tools into documents to help you manage long documents.

  • Review of Heading Styles and Navigation Pane
  • Insert Table of Contents
  • Using Section Breaks


90 min sessions

1. PowerPoint (The Basics)

In this session, you will learn how to create a basic PowerPoint Presentation.

  • Creating and editing a Presentation
  • Inserting a Slide Background
  • Formatting Slides with Text and Pictures
  • Adding Slide Transitions
  • Running a Presentation

2. PowerPoint (Beyond the Basics)

In this session, you will build on your PowerPoint skills by use more features to enhance your presentation.

  • Working with Sections
  • Inserting and managing Shapes and Screenshots
  • Adding Animation
  • Creating Speaker Notes and Handouts

3. Adding Content

In this session, you will add content to enhance your slides and make your presentation look more professional.

  • Re-use Slide Content
  • Inserting Audio and Video Files
  • Adding SmartArt Diagrams
  • Inserting an Excel Chart
  • Inserting a Word Table

4. Customising a Slide Show

In this session, you will learn quick ways of running your slideshow.

  • Inserting Hyperlinks and Action Buttons
  • Creating Custom shows
  • Setup a Slide Show / slide show controls
  • Slide Annotations
  • Presenter View


90 min sessions

1. Mailbox Management

  • Email Basics and working with Attachments
  • Setting up Automatic Replies
  • Creating Search Folders
  • Creating Email Signatures
  • Sorting and Filtering Emails
  • Using Flags
  • Setting up Email Rules
  • Using Quick Steps
  • Access Another User’s Folder

2. Calendar Management

  • Calendar Views
  • Creating an appointment and a Recurring Appointment
  • Creating a Meeting
  • Setting Calendar Options
  • Colour Categories
  • Sharing Calendars


90 minute session

This will give you a basic introduction to Microsoft OneNote. OneNote is a digital notebook that provides a single place to gather notes and information to use for your own use or to share with a Team.

  • Explore the OneNote Interface
  • Creating a Notebook, Adding Sections and Pages
  • Adding Content from Excel, Word and Webpages


90 minute session

This will give you a basic introduction to creating a Process Flowchart in Microsoft Visio. Visio is an application for creating diagrams using pre-installed templates e.g. Process Flowcharts, Organisation Charts, new office layouts and many more diagrams.

  • Explore the Visio Interface
  • Creating and formatting a Process Flowchart
  • Creating an Org Chart
Read more

Why choose QA

Digital Skills learning paths

Required Star = Required
Certification = Certification
Pick and Mix

Frequently asked questions

See all of our FAQs

How can I create an account on myQA.com?

There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.

If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".

If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.

Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.

How do QA’s virtual classroom courses work?

Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.

We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting (more details in the link below) to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.

Learn more about our Virtual Classrooms.

How do QA’s online courses work?

QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course. When you book a QA online learning course you will receive immediate access to it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.

All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.

Learn more about QA’s online courses.

When will I receive my joining instructions?

Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.

When will I receive my certificate?

Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.

Contact Us

Please contact us for more information