Course Description

This 120 day self paced course is designed to enable staff working in school environments to immediately increase their productivity with Microsoft Word & Excel 2016 (365).

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

Course fee is per user.

If you wish to purchase access for more than 10 staff, contact [email protected] for multi-user rates.

Pricing is in Australian Dollars

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. What Every School Administrator Needs to Know about Microsoft Word & Excel 2016 (365)

    2. FAQ - How to Download the Workbook

    1. Module 1 - Introductory 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 - Introductory 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 365 - 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 - Introductory Video

    2. Excel 2016 - Remove Duplicates

    3. Excel 2016 - Text to Columns

    4. Excel 2016 - Proper

    5. Excel 2016 - TRIM Function

    6. Excel 365 - Concatenate

    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 - Introductory 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. Module 4 - Word Intermediate/Advanced Quiz

About this course

  • $99.00
  • 58 lessons
  • 2 hours of video content