Productivity Portal - Microsoft Office 2016 (365)

Presenter Donna Hanson

Course description

This course provides 24/7 access to Donna's Microsoft Office 2016 Productivity Portal - a range of "how to" video clips and PDF files designed to give you answers to common tasks in Word, Excel, PowerPoint & Outlook 2016 (365).


Access is for individual use for 12 months.

Each month you receive an email reminding you to revisit the portal and keep adding to your knowledge.


For multi-user access, bulk purchase or affiliate links, contact Prime Solutions Training & Consulting on +61 3 9457 4745.

Donna Hanson
Donna Hanson
Productivity Expert

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

Microsoft Excel 2016 (365) - Introduction
40:19
Excel 2016 (365) - BODMAS Formula Basics
Excel 2016 (365) - BODMAS Formula Basics
Excel 2016 (365) - Relative Vs Absolute Cell Addressing
Excel 2016 (365) - Basic Charts
Excel 2016 (365) - Basic Charts
Excel 2016 (365) - Inserting & Deleting Columns & Rows
Excel 2016 (365) - Inserting & Deleting Columns & Rows
Excel 2016 (365) - Format Painter
Excel 2016 (365) - Format Painter
Excel 2016 (365) - Separating One Worksheet From A File
Excel 2016 (365) - Separating One Worksheet From A File
Excel 2016 (365) - Naming Worksheets
Excel 2016 (365) - Naming Worksheets
Excel 2016 (365) - Freeze Panes
Excel 2016 (365) - Freeze Panes
Excel 2016 (365) - Calculating the Difference Between Dates
Excel 2016 (365) - Calculating the Difference Between Dates
Excel 2016 (365) - Wrapping Text in a Cell
Excel 2016 (365) - Wrapping Text in a Cell
Excel 2016 (365) - Fit to a Page
Excel 2016 (365) - Fit to a Page
Excel 2016 (365) - Adding Icons to the Quick Access Toolbar
Excel 2016 (365) - Adding Icons to the Quick Access Toolbar
Excel 2016 (365) - Find & Replace
Excel 2016 (365) - Find & Replace
Excel 2016 (365) - Print Titles
Excel 2016 (365) - Print Titles
Excel 2016 (365) - Duplicating a Worksheet
Excel 2016 (365) - Duplicating a Worksheet
Excel 2016 (365) - Select All
Excel 2016 (365) - Select All
Excel 2016 (365) - Inserting an Excel Worksheet into a Word Document
Excel 2016 (365) - Inserting an Excel Worksheet into a Word Document
Excel 2016 (365) - Setting Up Data Lists
Excel 2016 (365) - Setting up Data Lists In Excel
Excel 2016 (365) - Setting Up Data Lists in Excel
Excel 2016 (365) - Copying & Pasting Into Word
Excel 2016 (365) - Relative Vs Absolute Cell Addressing
Excel 2016 (365) - Copying & Pasting into Word
Hide Content
Microsoft Excel 2016 (365) - Intermediate
49:42
Excel 2016 (365) - TRIM Function
Excel 2016 (365) - TRIM Function
Excel 2016 (365) - Headers & Footers
Excel 2016 (365) - Headers & Footers
Excel 2016 (365) - Text to Columns
Excel 2016 (365) - Text to Columns
Excel 2016 (365) - Viewing Two Files Side By Side
Excel 2016 (365) - Viewing Two Files Side by Side
Excel 2016 (365) - Hyperlinks
Excel 2016 (365) - Hyperlinks
Excel 2016 (365) - Transpose
Excel 2016 (365) - Transpose
Excel 2016 (365) - 3 Dimensional Formulas
Excel 2016 (365) - 3 Dimensional Formulas
Excel 2016 (365) - Grouping Worksheets
Excel 2016 (365) - Grouping Worksheets
Excel 2016 (365) - Text to Numbers
Excel 2016 (365) - Text to Numbers
Excel 2016 (365) - Sub Totals
Excel 2016 (365) - Sub Totals
Excel 2016 (365) - Sort & Filter
Excel 2016 (365) - Sort & Filter
Excel 2016 (365) - Conditional Formatting
Excel 2016 (365) - Conditional Formatting
Excel 2016 (365) - Concatenate Function
Excel 2016 (365) - Concatenate Function
Excel 2016 (365) - Range Names
Excel 2016 (365) - Range Names
Excel 2016 (365) - VLOOKUP Function
Excel 2016 (365) - VLOOKUP Function
Excel 2016 (365) - Format As Table
Excel 2016 (365) - Format As Table
Excel 2016 (365) - Proper Function
Excel 2016 (365) - Proper Function
Excel 2016 (365) - COUNTA Function
Excel 2016 (365) - COUNTA Function
Excel 2016 (365) - Remove Duplicates
Excel 2016 (365) - Remove Duplicates
Excel 2016 (365) - Inserting a Landscape Excel Worksheet into a Portrait Word Document
Excel 2016 - Inserting a Landscape Excel Worksheet into a Portrait Word Document
Excel 2016 - Inserting the Current Date
Excel 2016 - Inserting the Current Date
Hide Content