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
Course curriculum
-
-
What Every School Administrator Needs to Know about Microsoft Word & Excel 2016 (365)
-
FAQ - How to Download the Workbook
-
-
-
Module 1 - Introductory 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
-
-
-
Module 2 - Introductory 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
-
-
-
Module 3 - Introductory 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
-
-
-
Module 4 - Introductory 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
-
Module 4 - Word Intermediate/Advanced Quiz
-
About this course
- $99.00
- 58 lessons
- 2 hours of video content