Please see below a list of our Quick Reference Guides. For our Course Workbooks Click Here.
Access 2013 – Advanced Field Properties Lookups and Masks | |
Access 2013 – Creating Tables | |
Access 2013 – Introduction to Forms and Reports | |
Access 2013 – Introduction to Queries | |
Access 2013 – Organising Table Data | |
Access 2013 – Setting Field Properties | |
Access 2013 – Advanced Queries | |
Access 2013 – Database Utilities | |
Access 2013 – Importing and Exporting Data | |
Access 2013 – Modifying Forms in Design View | |
Access 2013 – Modifying Reports in Design View | |
Access 2013 – Table Relationships | |
Excel Short Cut Keys | |
Excel 2007 – Working with Workbooks | |
Excel 2007 – Basic Skills | |
Excel 2007 – Introduction to Calculations | |
Excel 2007 – Working with Multiple Sheets & Workbooks | |
Excel 2007 – Introduction to Charts | |
Excel 2007 – Introduction to Databases | |
Excel 2007 – Advanced Database Tools | |
Excel 2007 – Pivot Tables | |
Excel 2007 – Conditional Formatting | |
Excel 2007 – Filling Data, Paste Special & Range Names | |
Excel 2007 – Date Functions | |
Excel 2007 – Logical, Lookup, Sumif & Countif Functions | |
Excel 2007 – Match & Index Functions | |
Excel 2007 – Text Tools & Functions | |
Excel 2007 – Viewing Worksheets | |
Excel 2007 – Templates | |
Excel 2007 – Recording Macros | |
Excel 2010 | |
Excel 2010 – Advanced Database Tools | |
Excel 2010 – Auditing Tools | |
Excel 2010 – Calculating with Dates | |
Excel 2010 – Conditional Formatting | |
Excel 2010 – Consolidating and Outlining Data | |
Excel 2010 – Introduction to Databases and Tables | |
Excel 2010 – Introduction to Calculations | |
Excel 2010 – Introduction to Charts | |
Excel 2010 – Introduction to Macros | |
Excel 2010 – Logical, Lookup & Countif-Sumif Functions | |
Excel 2010 – Pivot Tables & Pivot Charts | |
Excel 2010 – Range Names and Paste Options | |
Excel 2010 – Text Functions | |
Excel 2010 – Viewing and Protecting Worksheets | |
Excel 2010 – Working with Multiple Sheets | |
Excel VBA | |
Excel 2013 – Advanced Database Tools | |
Excel 2013 – Introduction to Basics | |
Excel 2013 – Conditional Formatting | |
Excel 2013 – Date Functions | |
Excel 2013 – Working with Workbooks | |
Excel 2013 – Filling Data, Range Names & Paste Special | |
Excel 2013 – Introduction to Calculations | |
Excel 2013 – Introduction to Charts | |
Excel 2013 – Introduction to Databases | |
Excel 2013 – Logical & Lookup Functions, SUMIF and COUNTIF | |
Excel 2013 – Match & Index Functions | |
Excel 2013 – Pivot Tables | |
Excel 2013 – Recording Macros | |
Excel 2013 – Templates | |
Excel 2013 – Text Tools and Functions | |
Excel 2013 – Viewing Worksheets | |
Excel 2013 – Working with Multiple Sheets and Workbooks | |
Excel 2016 – Introduction to Basics | |
Excel 2016 – Conditional Formatting | |
Excel 2016 – Date Functions | |
Excel 2016 – Filling Data, Range Names & Paste Special | |
Excel 2016 – Introduction to Calculations | |
Excel 2016 – Introduction to Charts | |
Excel 2016 – Introduction to Databases | |
Excel 2016 – Logical & Lookup Functions, SUMIF and COUNTIF | |
Excel 2016 – Match & Index Functions | |
Excel 2016 – Pivot Tables | |
Excel 2016 – Text Tools and Functions | |
Excel 2016 – Viewing Worksheets | |
Excel 2016 – Working with Multiple Sheets and Workbooks | |
Excel 2019 – Advanced Formatting – Styles, Themes and ‘Tables’ | |
Excel 2019 – Basics of Charting | |
Excel 2019 – Cut, Copy, Paste and Fill (incl. ‘Flash Fill’) | |
Excel 2019 – Expanding on Calculations | |
Excel 2019 – Formatting Cells and Fonts | |
Excel 2019 – Introduction to Calculations | |
Excel 2019 – Naming Ranges | |
Excel 2019 – Overview and Basic Skills | |
Excel 2019 – Paste Options and Paste Special | |
Excel 2019 – Sorting & Filtering Data | |
Excel 2019 – Working with Columns and Rows | |
Excel 2019 – Advanced Chart Formatting | |
Excel 2019 – Advanced Charting Tools and Techniques | |
Excel 2019 – Advanced Page Setup | |
Excel 2019 – Page Setup Essentials | |
Excel 2019 – Printing Worksheets and Workbooks | |
Excel 2019 – Viewing Techniques for Large Workbooks | |
Excel 2019 – Workbooks Viewing and Linking | |
Excel 2019 – Worksheets Navigation and Linking | |
Office 2010 – Differences from 2003 | |
Outlook Short Cut Keys | |
Outlook 2007 | |
Outlook 2007 – Mail | |
Outlook 2007 – Calendar | |
Outlook 2010 | |
Outlook 2013 | |
PowerPoint Short Cut Keys | |
PowerPoint 2007 – An Introduction | |
PowerPoint 2007 – Getting Started | |
PowerPoint 2007 – Drawings and Graphics | |
PowerPoint 2007 – Animating Slides | |
PowerPoint 2007 – Importing Themes and Master Slides | |
PowerPoint 2007 – Linking and Embedding | |
PowerPoint 2010 | |
PowerPoint 2013 – Level 1 | |
PowerPoint 2013 – Level 2 | |
PowerPoint 2016 – Level 1 | |
PowerPoint 2016 – Level 2 | |
Project 2007 – New Features | |
Project 2007 – Task Planning | |
Project 2007 – Analysing Data and Customisation | |
Project 2007 – Implementation | |
Project 2007 – Multiple Projects and Sharing | |
Project 2007 – Resource Planning | |
Project 2010 – Analysing Data and Customisation | |
Project 2010 – Guide to Task and Resource Planning | |
Project 2010 – Implementation | |
Project 2010 – Multiple Projects and Sharing | |
Project 2013 – Communicating and Analysing Data | |
Project 2013 – Customisation | |
Project 2013 – Guide to Task and Resource Planning | |
Project 2013 – Implementing a Project | |
Project 2013 – Multiple Projects and Sharing | |
Windows 7 | |
Word Short Cut Keys | |
Word 2010 – Main Changes from 2003 | |
Word 2010 – Mail Merge | |
Word 2010 | |
Word 2013 – Basic Skills and Proofing | |
Word 2013 – Document layout, Printing and Headers and Footers | |
Word 2013 – Introduction to Mail Merge | |
Word 2013 – Introduction to Tables | |
Word 2013 – Paragraph Formatting | |
Word 2013 – Special Mail Merge Techniques and Troubleshooting | |
Word 2013 – Text Formatting | |
Word 2013 – Adding Bullets & Numbering | |
Word 2013 – Advanced Tables | |
Word 2013 – Columns | |
Word 2013 – Quick Parts (AutoText) | |
Word 2013 – Using Charts | |
Word 2013 – Working with Borders & Shading | |
Word 2013 – Working with Tabs | |
Word 2013 – Working with Styles | |
Word 2013 – Table of Contents | |
Word 2013 – Section Breaks | |
Word 2013 – Outline View and Numbering | Download |
Visio 2010 – Basics | Download |
Visio 2013 – Keyboard Shortcuts | Download |