Quick Reference Guides

Please see below a list of our Quick Reference Guides. For our Course Workbooks Click Here.

Access 2013 – Advanced Field Properties Lookups and Masks

Download

Access 2013 – Creating Tables

Download

Access 2013 – Introduction to Forms and Reports

Download

Access 2013 – Introduction to Queries

Download

Access 2013 – Organising Table Data

Download

Access 2013 – Setting Field Properties

Download

Access 2013 – Advanced Queries

Download

Access 2013 – Database Utilities

Download

Access 2013 – Importing and Exporting Data

Download

Access 2013 – Modifying Forms in Design View

Download

Access 2013 – Modifying Reports in Design View

Download

Access 2013 – Table Relationships

Download

Excel Short Cut Keys

Download

Excel 2007 – Working with Workbooks

Download

Excel 2007 – Basic Skills

Download

Excel 2007 – Introduction to Calculations

Download

Excel 2007 – Working with Multiple Sheets & Workbooks

Download

Excel 2007 – Introduction to Charts

Download

Excel 2007 – Introduction to Databases

Download

Excel 2007 – Advanced Database Tools

Download

Excel 2007 – Pivot Tables

Download

Excel 2007 – Conditional Formatting

Download

Excel 2007 – Filling Data, Paste Special & Range Names

Download

Excel 2007 – Date Functions

Download

Excel 2007 – Logical, Lookup, Sumif & Countif Functions

Download

Excel 2007 – Match & Index Functions

Download

Excel 2007 – Text Tools & Functions

Download

Excel 2007 – Viewing Worksheets

Download

Excel 2007 – Templates

Download

Excel 2007 – Recording Macros

Download

Excel 2010

Download

Excel 2010 – Advanced Database Tools

Download

Excel 2010 – Auditing Tools

Download

Excel 2010 – Calculating with Dates

Download

Excel 2010 – Conditional Formatting

Download

Excel 2010 – Consolidating and Outlining Data

Download

Excel 2010 – Introduction to Databases and Tables

Download

Excel 2010 – Introduction to Calculations

Download

Excel 2010 – Introduction to Charts

Download

Excel 2010 – Introduction to Macros

Download

Excel 2010 – Logical, Lookup & Countif-Sumif Functions

Download

Excel 2010 – Pivot Tables & Pivot Charts

Download

Excel 2010 – Range Names and Paste Options

Download

Excel 2010 – Text Functions

Download

Excel 2010 – Viewing and Protecting Worksheets

Download

Excel 2010 – Working with Multiple Sheets

Download

Excel VBA

Download

Excel 2013 – Advanced Database Tools

Download

Excel 2013 – Introduction to Basics

Download

Excel 2013 – Conditional Formatting

Download

Excel 2013 – Date Functions

Download

Excel 2013 – Working with Workbooks

Download

Excel 2013 – Filling Data, Range Names & Paste Special

Download

Excel 2013 – Introduction to Calculations

Download

Excel 2013 – Introduction to Charts

Download

Excel 2013 – Introduction to Databases

Download

Excel 2013 – Logical & Lookup Functions, SUMIF and COUNTIF

Download

Excel 2013 – Match & Index Functions

Download

Excel 2013 – Pivot Tables

Download

Excel 2013 – Recording Macros

Download

Excel 2013 – Templates

Download

Excel 2013 – Text Tools and Functions

Download

Excel 2013 – Viewing Worksheets

Download

Excel 2013 – Working with Multiple Sheets and Workbooks

Download

Excel 2016 – Introduction to Basics

Download

Excel 2016 – Conditional Formatting

Download

Excel 2016 – Date Functions

Download

Excel 2016 – Filling Data, Range Names & Paste Special

Download

Excel 2016 – Introduction to Calculations

Download

Excel 2016 – Introduction to Charts

Download

Excel 2016 – Introduction to Databases

Download

Excel 2016 –¬†Logical & Lookup Functions, SUMIF and COUNTIF

Download

Excel 2016 – Match & Index Functions

Download

Excel 2016 – Pivot Tables

Download

Excel 2016 – Text Tools and Functions

Download

Excel 2016 – Viewing Worksheets

Download

Excel 2016 –¬†Working with Multiple Sheets and Workbooks

Download

Excel 2019 – Advanced Formatting – Styles, Themes and ‘Tables’

Download

Excel 2019 – Basics of Charting

Download

Excel 2019 – Cut, Copy, Paste and Fill (incl. ‘Flash Fill’)

Download

Excel 2019 – Expanding on Calculations

Download

Excel 2019 – Formatting Cells and Fonts

Download

Excel 2019 – Introduction to Calculations

Download

Excel 2019 – Naming Ranges

Download

Excel 2019 – Overview and Basic Skills

Download

Excel 2019 – Paste Options and Paste Special

Download

Excel 2019 – Sorting & Filtering Data

Download

Excel 2019 – Working with Columns and Rows

Download

Excel 2019 – Advanced Chart Formatting

Download

Excel 2019 – Advanced Charting Tools and Techniques

Download

Excel 2019 – Advanced Page Setup

Download

Excel 2019 – Page Setup Essentials

Download

Excel 2019 – Printing Worksheets and Workbooks

Download

Excel 2019 – Viewing Techniques for Large Workbooks

Download

Excel 2019 – Workbooks Viewing and Linking

Download

Excel 2019 – Worksheets Navigation and Linking

Download

Office 2010 – Differences from 2003

Download

Outlook Short Cut Keys

Download

Outlook 2007

Download

Outlook 2007 – Mail

Download

Outlook 2007 – Calendar

Download

Outlook 2010

Download

Outlook 2013

Download

PowerPoint Short Cut Keys

Download

PowerPoint 2007 – An Introduction

Download

PowerPoint 2007 – Getting Started

Download

PowerPoint 2007 – Drawings and Graphics

Download

PowerPoint 2007 – Animating Slides

Download

PowerPoint 2007 – Importing Themes and Master Slides

Download

PowerPoint 2007 – Linking and Embedding

Download

PowerPoint 2010

Download

PowerPoint 2013 – Level 1

Download

PowerPoint 2013 – Level 2

Download

PowerPoint 2016 – Level 1

Download

PowerPoint 2016 – Level 2

Download

Project 2007 – New Features

Download

Project 2007 – Task Planning

Download

Project 2007 – Analysing Data and Customisation

Download

Project 2007 – Implementation

Download

Project 2007 – Multiple Projects and Sharing

Download

Project 2007 – Resource Planning

Download

Project 2010 – Analysing Data and Customisation

Download

Project 2010 – Guide to Task and Resource Planning

Download

Project 2010 – Implementation

Download

Project 2010 – Multiple Projects and Sharing

Download

Project 2013 – Communicating and Analysing Data

Download

Project 2013 – Customisation

Download

Project 2013 – Guide to Task and Resource Planning

Download

Project 2013 – Implementing a Project

Download

Project 2013 – Multiple Projects and Sharing

Download

Windows 7

Download

Word Short Cut Keys

Download

Word 2010 – Main Changes from 2003

Download

Word 2010 – Mail Merge

Download

Word 2010

Download

Word 2013 – Basic Skills and Proofing

Download

Word 2013 – Document layout, Printing and Headers and Footers

Download

Word 2013 – Introduction to Mail Merge

Download

Word 2013 – Introduction to Tables

Download

Word 2013 – Paragraph Formatting

Download

Word 2013 – Special Mail Merge Techniques and Troubleshooting

Download

Word 2013 – Text Formatting

Download

Word 2013 – Adding Bullets & Numbering

Download

Word 2013 – Advanced Tables

Download

Word 2013 – Columns

Download

Word 2013 – Quick Parts (AutoText)

Download

Word 2013 – Using Charts

Download

Word 2013 – Working with Borders & Shading

Download

Word 2013 – Working with Tabs

Download

Word 2013 – Working with Styles

Download

Word 2013 – Table of Contents

Download

Word 2013 – Section Breaks

Download

Word 2013 – Outline View and Numbering Download
Visio 2010 – Basics Download
Visio 2013 – Keyboard Shortcuts Download