Overview

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 +

Prerequisites

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

Outline

MICROSOFT EXCEL

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

  • IF, COUNTIF, SUMIF, AVERAGEIF
  • COUNTIFS, SUMIFS, AVERAGEIFS (multiple criteria)
  • IF Function with AND / OR
  • IFERROR

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
  • UPPER, LOWER, PROPER
  • CONCAT, TEXTJOIN
  • Get and transform data using Power Query (if time)

MICROSOFT WORD

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

MICROSOFT POWERPOINT

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

MICROSOFT OUTLOOK ONLINE

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

MICROSOFT ONENOTE ONLINE

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

MICROSOFT VISIO ONLINE

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
= Certification
Essentials
Collaboration
Pick and Mix
Productivity
Need to know

Frequently asked questions

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.

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.

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.

Let's talk

By submitting this form, you agree to QA processing your data in accordance with our Privacy Policy and Terms & Conditions. You can unsubscribe at any time by clicking the link in our emails or contacting us directly.