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 [email protected] 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. Welcome Video - Watch this First

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

    3. FAQ - How to Download the Workbook

    1. Module 1 - Introduction Video

    2. Excel 2016 - Select All

    3. Excel 2016 - Duplicating a Worksheet

    4. Excel 2016 - Naming Worksheets

    5. Excel 2016 - Grouping Worksheets

    6. Excel 2016 - BODMAS - Understanding Functions

    7. Excel 2016 - Basic Formulas including SUM Function

    8. Excel 2016 - Basic Graphs

    9. Excel 2016 - Print Titles

    10. Excel 2016 - Format Painter

    11. Excel 2016 - Sort & Filter Data

    12. Excel 2016 - Freeze Panes

    13. Excel 2016 - Conditional Formatting

    14. Excel 2016 - Fit to a Page

    15. Excel 2016 - Headers & Footers

    16. Excel 2016 - 3 Dimensional Formulas

    17. Module 1 - Excel Tips, Tricks & Shortcuts Quiz

    1. Module 2 - Introduction Video

    2. Word 2016 - Default Line Spacing

    3. Word 2016 - Inserting Page Breaks

    4. Word 2016 - Copying & Pasting Options

    5. Word 2016 - Autocorrect

    6. Word 2016 - QuickParts

    7. Word 2016 - Headers & Footers

    8. Word 2016 - Format Painter

    9. Word 2016 - Save As PDF

    10. Word 2016 - Bullets

    11. Word 2016 - Inserting File Name & Path

    12. Word 2016 - Inserting a Cover Page

    13. Word 2016 - Inserting Page Numbers

    14. Module 2 - Word Tips, Tricks & Shortcuts Quiz

    1. Module 3 - Introduction Video

    2. Excel 2016 - Remove Duplicates

    3. Excel 2016 - Text to Columns

    4. Excel 2016 - Proper Function

    5. Excel 2016 - TRIM Function

    6. Excel 2016 - Concatenate Function

    7. Excel 2016 - Range Names

    8. Excel 2016 - VLOOKUP Function

    9. Excel 365 - Hyperlinks

    10. Excel 2016 - Intro to Pivot Tables

    11. Excel 2016 - SubTotals

    12. Excel 2016 - Protecting Cells and Files

    13. Excel 365 - Macros

    14. Excel 2016 - Macro Button

    15. Module 3 - Excel Intermediate/Advanced Quiz

    1. Module 4 - Introduction Video

    2. Word 2016 - Inserting One Document into Another

    3. Word 2016 - Inserting an Excel Worksheet - Includes Sections

    4. Word 2016 - Pictures

    5. Word 2016 - Styles

    6. Word 2016 - Table of Contents

    7. Word 2016 - Templates

    8. Word 2016 - Watermark

    9. Word 2016 - Forms

    10. Word 2016 - Mail Merge to Labels

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

    12. Module 4 - Word Intermediate/Advanced Quiz

    1. Want more help?

About this course

  • $147.00
  • 62 lessons
  • 2 hours of video content