Our Learning Content

Choose your technology
Banner image
Microsoft Office
Banner image
Microsoft Office 365
Banner image
G Suite
Banner image
Azure
Banner image
Collaboration
Banner image
Social
Banner image
Autotask Workplace
Banner image
Cyber Security

Microsoft Office

Choose your application

Excel

Module 1

Excel Fundamentals

  • Excel Interface Overview
  • Data Entry and Editing Techniques
  • Data Autofill
  • Working with Dates & Times
  • Adding Comments
  • Simple Formulas (Totals & Averages)
  • Formatting Rows & Columns
Module 2

Excel Essentials

  • Inserting Pictures and Shapes into Excel
  • Working with Themes
  • Freeze Panes
  • Getting Your Sheet Ready for Printing
  • Page Break Preview
  • Spell Checker
  • Clear All Button
  • Find and Replace
  • Merge Cells
  • Microsoft Templates
Module 3

Working with Tables

  • Why Use a Table
  • The Components of a Table
  • Formatting of a Table
  • Using Autofilter
  • Slicers with Tables
  • Advanced Sorting
  • Calculating Totals on a Table
  • Referencing Within a Table
Module 4

Formatting

  • What Data Really Looks Like
  • Applying Formatting to a Cell
  • Text vs Numerical Data
  • Formatting Dates
  • Working with Currencies
  • Formatting Percentages
  • Custom Formatting
  • Format Painter
Module 5

Core Functions

  • Equals and Targeting Cells
  • Functions vs Formulas
  • Adding Subtracting Multiplication & Division
  • Components of a Function
  • Sum and Average Function
  • More than One Function in a Cell
  • Nested Functions
  • Absolute References ($ Signs)
Module 6

More Functions

  • Functions in Excel
  • COUNT Function
  • ROUND, ROUNDUP and ROUNDDOWN Functions
  • CONCATENATE Function
  • UPPER, LOWER and PROPER Functions
  • LEFT and RIGHT Functions
  • MID Function
  • Errors in Functions
Module 7

VLOOKUP’s

  • What You Can Do With a VLOOKUP
  • The Correct Dataset Structure
  • Doing a VLOOKUP
  • Common Problems With a VLOOKUP
  • Exact or Approximate Match
  • Comparing Two Sheets with a VLOOKUP
  • Matching on More than One Criteria
  • HLOOKUP Function
  • Error Handling - IFERROR Function
Module 8

The IF Function

  • Overview
  • Inputs to an IF Function
  • Operator Functions - AND, OR, NOT
  • IF in an IF (Nested IF)
  • COUNTIF Function
  • SUMIF Function
  • Sum on More Than One Condition - SUMIFS
Module 9

Charts, Graphs & Data

  • Getting Your Data Ready for a Graph
  • Elements of a Graph
  • What Graph to Use
  • Formatting Chart Elements
  • Managing Axes
  • Bar and Column Graphs
  • Donut and Pie Graphs
  • Scatter Graphs
  • Combo Graphs
  • Using Sparklines
Module 10

Pivot Tables Overview

  • Overview of Pivot Tables
  • Formatting Data for a Pivot Table
  • Creating a new Pivot Table
  • Pivot Table Areas
  • Functions in a Pivot Table
  • Subtotals and Grand Totals
  • Formatting a Pivot Table
  • Multiple Pivot Tables
Module 11

Pushing Pivot Tables Further

  • Sorting Data in a Pivot Table
  • Show Data as Percentages
  • Number Formats in a Pivot Table
  • Calculated Fields
  • Using Slicers and Timelines
  • Pivot Charts
  • Pivot Table Options
Module 12

Import & Clean Data

  • Copying and Pasting
  • Paste Special
  • Clean Up Spaces - TRIM Function
  • SUBSTITUTE Function
  • REPLACE Function
  • Importing Data
  • Data Validation
  • Split Data into Multiple Columns
  • Convert Text Data to Values
Module 13

New in Excel 2016

  • Overview
  • Excel 2013 and 2016 Side by Side
  • 'Tell me' Tool
  • Hierarchy Charts
  • Waterfall Charts
  • Forecasts
  • 3D Maps

OneNote

Module 1

OneNote Fundamentals

  • Overview of the OneNote Interface
  • Creating, Editing and Deleting Notebooks
  • Creating, Editing, Moving and Deleting Sections
  • Creating, Editing, Moving and Deleting Pages
  • Setting Up Pages and Sub-Pages
  • Creating Notes
  • Using Bullets and Numbering
  • Formatting Text
Module 2

Managing and Laying Out OneNote

  • Ways of Sending Content to OneNote
  • Copying and Pasting Content
  • Working with Screen Clippings
  • Adding Pictures
  • Adding Video
  • Recording Audio and Video
  • Adding Files
  • Adding Symbols
Module 3

Formatting Notes and Templates

  • Using the Format Painter
  • Interface Layout Options
  • Linking Notes
  • Tagging Notes
  • Searching Notebooks
  • Using Templates
  • Creating Templates
  • Setting Template Defaults
Module 4

Working with Tables

  • Creating Tables
  • Managing Rows and Columns
  • Formatting Tables
  • Bringing in Tables from Excel
  • Exporting Tables to Excel
Module 5

Using Pen and Inking

  • Overview of Using Pen and Ink
  • Pen Mode Options
  • Converting Handwriting
  • Working with Notes
  • Working with Drawings
Module 6

Outlook and OneNote

  • Creating Tasks
  • Managing Tasks
  • Sending Notes by Email
  • Using Notes as a Meeting Agenda
Module 7

Collaborating and Sharing

  • Exporting Notes to PDF
  • Sharing Notebooks
  • Syncing Notebooks
  • Looking at Versions
  • Understanding Author Indicators
  • Saving to OneDrive for Business

Outlook

Module 1

Outlook Fundamentals

  • Overview of the Outlook Interface
  • Reading and Receiving Mail
  • Creating a New Email Message
  • Formatting a Message
  • Customise your Inbox
  • Searching Emails
  • Working with Attachments
  • Printing an Email
Module 2

Reviewing and Managing Messages

  • Show Messages by Conversation
  • Use the Read Pane
  • Mark Messages
  • Use Advanced Find to Locate Messages
  • Ignore a Conversation
  • Use Mailbox Cleanup
Module 3

Inbox Views in Outlook

  • Arrange Email by Date or Sender
  • Add a Column or View
  • Sort and Filter a View
  • Modify a View's Setting
  • Save a View
  • Use Conditional Formatting to Highlight Important Messages
Module 4

Using Folders and Categories

  • Create an Inbox Folder
  • Add a Folder to Favourites
  • Use Custom Search Folders
  • Customise and Use Categories
  • Understand How Archiving Works
  • Set AutoArchive Options
  • View Archive Data Files
Module 5

Working With Rules and Actions

  • Flag Emails for Future Action
  • Use Built-in Quick Steps
  • Create a Custom Quick Step
  • Move a Message or Conversation
  • Create a Rule from a Message
  • Create a Rule from Scratch
  • Manage Email Rules
  • Use Automatic Replies to Set Out of Office
  • Using Rules with Automatic Replies
Module 6

Working with People and Contacts in Outlook

  • Navigating the People Hub
  • Creating a New Contact
  • Creating a New Contact Group
  • Working with Contacts
  • Moving Contacts into Folders
  • Sharing Contact Data with Others
Module 7

Working with Calendars

  • Navigating the Calendar
  • Changing the Look of the Calendar
  • Creating an Appointment and an All Day Event
  • Creating a Meeting
  • Chairing a Meeting
  • Responding to a Meeting Invitation
  • Opening Other Calendars
  • Printing, Emailing and Sharing the Calendar
  • Creating Additional Calendars
  • Setting Calendar Permissions
Module 8

Working With Tasks

  • The Task Interface
  • Creating Tasks
  • Assigning Tasks
  • Managing To Do Lists
  • Creating Notes

PowerPoint

Module 1

PowerPoint Fundamentals

  • The PowerPoint Interface
  • View & Open Presentations
  • Create a Presentation
  • Changing Themes
  • Formatting Text
  • Adding Sections
  • Adding Headers & Footers
  • Adding and Removing Slides
  • Changing the Slide Layout
  • Changing Slide Backgrounds
Module 2

Adding Content & Working Up Presentations

  • Working with Text Boxes
  • Working with Bullets
  • Adding Shapes and Boxes
  • Working with Tables
  • Add a Table from Excel
  • Working with Charts
  • Using Word Art
  • Using Smart Art
  • Working with Transitions
  • Working with Animations
Module 3

Pictures and Working With Objects

  • Insert Pictures into a Deck
  • Adding Video into a Deck
  • Adding Audio into a Deck
  • Adding Links into a Deck
  • Using the Eye Dropper Tool
  • Remove Background and Image Effects
  • Laying Out Images into a Deck
  • Layering Objects
  • Aligning Objects
Module 4

Presenting in PowerPoint

  • Using Speaker Notes
  • Printing Out Handouts
  • Present a Slide Deck
  • Using Presenter View (Multiple Screens)
  • Using Pointer Tool
  • Zooming into Presentations
  • Using the Timer
Module 5

Collaborating in PowerPoint

  • Review Presentations
  • Comments on Slides
  • Review and Compare Changes
  • Highlight Slide Content
  • Printing Slides and Notes
  • Exporting Presentations to a PDF

Word

Module 1

Word Fundamentals

  • The Word Interface
  • Opening and Viewing Documents
  • Creating New Documents
  • Saving Documents
  • Working With PDF Documents
  • Printing Documents
Module 2

Word Essentials

  • Inserting Text
  • Selecting Text
  • Font Formatting
  • Using Text Effects
  • Using Cut, Copy and Paste
  • Find and Replace Text
  • Undo and Redo Actions
  • Bulleted Lists
  • Numbered Lists
  • Paste Options
Module 3

Paragraphs and Formatting in Word

  • Alignment of Paragraphs
  • Justification of Paragraphs
  • Adjusting Line Spacing
  • Shading and Borders
  • Tabs and Indents
Module 4

Themes and Styles in Word

  • Applying Themes
  • Creating Styles
  • Using Heading Styles
  • Creating Themes
  • Paper Size and Margins
  • Page Backgrounds
  • Working with Headers and Footers
Module 5

Tables in Word

  • Creating a Table
  • Converting Text to a Table
  • Copying Tables from Excel
  • Applying a Table Style
  • Formatting a Table
  • Add & Remove Columns & Rows
  • Converting a Table to Text
  • Sorting Data in a Table
  • Using Tables to Layout Images
Module 6

Working with Pictures & Objects in Word

  • Inserting Pictures
  • Positioning Pictures
  • Text and Images Options
  • Applying Effects to Images
  • Adjusting Images
  • Using Word Art
  • Using Smart Art
  • Bringing in Screenshots
  • Inserting Video
Module 7

Collaborating on Documents in Word

  • Tracking Changes & Using Review
  • Inserting and Reviewing Comments
  • Managing Changes (Accept & Reject)
  • Sharing Documents Via Email
  • Password Protecting Word Files
Module 8

Proofing Documents

  • Spell Checking
  • Using Thesaurus
  • AutoCorrect Options
  • Translation Tools
  • Setting Your Default Language