Course Description

This 120 day self paced course is designed to enable small business owners and their staff to immediately increase their productivity with Microsoft Word & Excel 2016 (365).

The content is focused on the "real world" needs of small business and provides a cost and time effective way to increase productivity without leaving the office.

Course fee is per person.

If you wish to purchase access for more than 10 staff, contact enquiries@primesolutions.net.au for multi-user rates.

Pricing is in Australian Dollars

Access is for 120 days


Productivity Expert

Donna Hanson

For the past 20 years, Donna has helped thousands of organisations around the world save time, money, stress and frustration with Microsoft Office products. She is passionate about helping people get things done so they can get back to enjoying life.

Course curriculum

  1. 1
    • Welcome Video - Watch this First

    • What Every Small Business Owner Needs to Know about Microsoft Word & Excel 2016 (365)

    • FAQ - How to Download the Workbook

  2. 2
    • Module 1 - Introduction Video

    • Excel 2016 - Select All

    • Excel 2016 - Duplicating a Worksheet

    • Excel 2016 - Naming Worksheets

    • Excel 2016 - Grouping Worksheets

    • Excel 2016 - BODMAS - Understanding Functions

    • Excel 2016 - Basic Formulas including SUM Function

    • Excel 2016 - Basic Graphs

    • Excel 2016 - Print Titles

    • Excel 2016 - Format Painter

    • Excel 2016 - Sort & Filter Data

    • Excel 2016 - Freeze Panes

    • Excel 2016 - Conditional Formatting

    • Excel 2016 - Fit to a Page

    • Excel 2016 - Headers & Footers

    • Excel 2016 - 3 Dimensional Formulas

    • Module 1 - Excel Tips, Tricks & Shortcuts Quiz

  3. 3
    • Module 2 - Introduction Video

    • Word 2016 - Default Line Spacing

    • Word 2016 - Inserting Page Breaks

    • Word 2016 - Copying & Pasting Options

    • Word 2016 - Autocorrect

    • Word 2016 - QuickParts

    • Word 2016 - Headers & Footers

    • Word 2016 - Format Painter

    • Word 2016 - Save As PDF

    • Word 2016 - Bullets

    • Word 2016 - Inserting File Name & Path

    • Word 2016 - Inserting a Cover Page

    • Word 2016 - Inserting Page Numbers

    • Module 2 - Word Tips, Tricks & Shortcuts Quiz

  4. 4
    • Module 3 - Introduction Video

    • Excel 2016 - Remove Duplicates

    • Excel 2016 - Text to Columns

    • Excel 2016 - Proper

    • Excel 2016 - TRIM Function

    • Excel 2016 - Concatenate

    • Excel 2016 - Range Names

    • Excel 2016 - VLOOKUP Function

    • Excel 2016 - Hyperlinks

    • Excel 2016 - Intro to Pivot Tables

    • Excel 2016 - SubTotals

    • Excel 2016 - Protecting Cells and Files

    • Excel 2016 - Macros

    • Excel 2016 - Macro Button

    • Module 3 - Excel Intermediate/Advanced Quiz

  5. 5
    • Module 4 - Introduction Video

    • Word 2016 - Inserting One Document into Another

    • Word 2016 - Inserting an Excel Worksheet - Includes Sections

    • Word 2016 - Pictures

    • Word 2016 - Styles

    • Word 2016 - Table of Contents

    • Word 2016 - Templates

    • Word 2016 - Watermark

    • Word 2016 - Forms

    • Word 2016 - Mail Merge to Labels

    • Word 2016 - Mail Merge to Letters with Excel as the Data Source

    • Module 4 - Word Intermediate/Advanced Quiz

  6. 6
    • Want more help with Microsoft Word or Excel? Book a one on one coaching session via the link below.