About the Resource Library
The Resource Library provides you with 24/7 access to a range of "how to" video clips and PDF files designed to give you the knowledge and the process to find solutions to common questions in Word, Excel, PowerPoint & Outlook 365.
Rather than waste time searching for the know how to get what you need to get done, the Resource Library provides individual access to all you need to give you the know how to get stuff done.
New information added on a regular basis.
For multi-user access, bulk purchase or affiliate links, contact Prime Solutions Training & Consulting on +61 3 9457 4745.
Access is for individual use for 12 months.
NOW ADDED:
- Microsoft Word & Excel Webcast
- Microsoft OneDrive Webcast
- Microsoft Forms Webcast
Individual Access includes:
-
24/7 access to Donna's entire Microsoft Office Video Library. Explore by skill level or search for a particular topic
-
Access downloadable PDF how to document for step by step written instructions and added tips
-
Access to three pre-recorded webinars on Microsoft Word & Excel, Microsoft OneDrive and Microsoft Forms
-
Automatic renewal of subscription at the same price each year (the library also contains details on how to switch off auto renewal)
-
Automatic access to any new resources added to the library during your subscription
-
Access to Donna for email Q&A, quick questions and heavily discounted pricing for one on one coaching sessions.

Productivity Expert Donna Hanson
Library Content
-
-
How to Navigate or Search the Excel Library
-
Got a Question?
-
-
-
Microsoft Excel 365 - Understanding How Excel Treats Data - Video & PDF
-
Microsoft Excel 365 - Mouse Pointers - Video & PDF
-
Microsoft Excel 365 - Selection Techniques - Video & PDF
-
Microsoft Excel 365 - Selecting All Data on Your Worksheet - Video & PDF
-
Microsoft Excel 365 - Inserting Rows & Columns - Video & PDF
-
Microsoft Excel 365 - Moving Worksheets - Video & PDF
-
Microsoft Excel 365 - Renaming & Colouring Worksheet Tabs Video & PDF Instructions
-
Microsoft Excel 365 - Formatting Cells, Changing Fonts and Alignment Video & PDF Instructions
-
Microsoft Excel 365 - Formatting Numbers in Excel - Video & PDF Instructions
-
Microsoft Excel 365 - Format Painter Video & PDF Instructions
-
Microsoft Excel 365 - Focus Cell - What it is and how to use it
-
Microsoft Excel 365 - Wrap Text Video & PDF Instructions
-
Microsoft Excel 365 - Find & Select - Video & PDF Instructions
-
Microsoft Excel 365 - Fit to a Page Video and PDF Instructions
-
Microsoft Excel 365 - Formulas vs Functions Video & PDF Instructions
-
Microsoft Excel 365 - Best Practice for Creating Formulas with Multiple Mathematical Calculations - ie Add tax. Video & PDF Instructions
-
Microsoft Excel 365 - Formula Basics - Video & PDF
-
Microsoft Excel 365 - Relative vs Absolute Cell Referencing Video & PDF Instructions
-
Microsoft Excel 365 - Calculating Percentages
-
Microsoft Excel 365 - SUM Function - Video and PDF
-
Microsoft Excel 365 - Date Formats Video and PDF Instructions
-
Microsoft Excel 365 - Understanding Graphs/Charts Video & PDF Instructions
-
Microsoft Excel 365 - Basic Charts/Graphs Video & PDF
-
Microsoft Excel 365 - Different Types of Graphs/Charts
-
Microsoft Excel 365 - Modifying Graphs/Charts
-
Microsoft Excel 365 - Freeze Panes Video and PDF Download
-
Microsoft Excel 365 - Converting Date to Numbers Video & PDF Instructions
-
Microsoft Excel 365 - Print Titles Video & PDF
-
Microsoft Excel 365 - Copy or Duplicate a Worksheet - Video & PDF
-
Microsoft Excel 365 - Inserting Excel Data into a Word Document - Video & PDF
-
Microsoft Excel 365 - Setting Up Data Lists
-
Microsoft Excel 365 - Copying & Pasting Options - Excel to Excel - Video & PDF Instructions
-
Microsoft Excel 365 - Copying & Pasting Options - Excel to Word
-
Microsoft Excel 365 - List of All Worksheets Video and PDF
-
Microsoft Excel 365 - Hiding Worksheets - Video and PDF
-
Microsoft Excel 365 - Renaming & Coloring Worksheet Tabs - Video and PDF
-
Microsoft Excel 365 - Merge & Center - Video and PDF
-
Microsoft Excel 365 - Applying Borders & Shading - Video & PDF Instructions
-
Microsoft Excel 365 - What do the ### symbols mean in an Excel worksheet? Video & PDF
-
Microsoft Excel 365 - AVERAGE Function Video & PDF
-
Microsoft Excel 365 - Rotating Text - Video & PDF
-
Microsoft Excel 365 - Separating One Worksheet from a File
-
Microsoft Excel 365 - Setting Up Data Lists - Video & PDF Instructions
-
Microsoft Excel 365 - Basic Sort & Filter - Video & PDF Instructions
-
Microsoft Excel 365 - Page Set Up - Video & PDF Instructions
-
-
-
Microsoft Excel 365 - Headers & Footers
-
Microsoft Excel 365 - Headers & Footers
-
Microsoft Excel 365 - Cell Notes - Video & PDF Instructions
-
Microsoft Excel 365 - Wrap Text - Video & PDF Instructions
-
Microsoft Excel 365 - Indenting Text - Video & PDF Instructions
-
Microsoft Excel 365 - Split Screen - Video & PDF Instructions
-
Microsoft Excel 365 - Text to Columns - Video & PDF
-
Microsoft Excel 365 - Viewing Two Files Side By Side
-
Microsoft Excel 365 - Viewing Two Files Side by Side
-
Microsoft Excel 365 - Hyperlinks - Video & PDF Instructions
-
Microsoft Excel 365 - Transpose Video & PDF
-
Microsoft Excel 365 - 3 Dimensional Formulas - Video & PDF
-
Microsoft Excel 365 - Grouping Worksheets - Video & PDF
-
Microsoft Excel 365 - Text to Numbers - Video & PDF
-
Microsoft Excel 365 - Subtotals - Video & PDF Instructions
-
Microsoft Excel 365 - Multiple Subtotals - Video & PDF Instructions
-
Microsoft Excel 365 - Custom Sort - Video & PDF Instructions
-
Microsoft Excel 365 - Conditional Formatting - Video & PDF
-
Microsoft Excel 365 - Conditional Formatting Rows
-
Microsoft Excel 365 - Conditional Formatting Rows
-
Microsoft Excel 365 - Conditional Formatting Based on Text - Video & PDF Instructions
-
Microsoft Excel 365 - Using Conditional Formatting to Highlight Unique Data in a list - Video & PDF
-
Microsoft Excel 365 - Concatenate Function - Video & PDF
-
Microsoft Excel 365 - Range Names - Video & PDF
-
Microsoft Excel 365 - VLOOKUP Function - Video & PDF Instructions
-
Microsoft Excel 365 - Format As Table - Video & PDF
-
Microsoft Excel 365 - Proper Function - Video & PDF
-
Microsoft Excel 365 - COUNT Function - Video and PDF
-
Microsoft Excel 365 - COUNTA Function - Video & PDF
-
Microsoft Excel 365 - COUNTIF Function - Video & PDF Instructions
-
Microsoft Excel 365 - COUNTBLANK Function - Video & PDF Instructions
-
Microsoft Excel 365 - TRIM Function - Video & PDF Instructions
-
Microsoft Excel 365 - Inserting a Landscape Excel Worksheet into a Portrait Word Document
-
Microsoft Excel 365 - Inserting a Landscape Excel Worksheet into a Portrait Word Document
-
Microsoft Excel 365 - Remove Duplicates Video & PDF Instructions
-
Microsoft Excel 365 - NOW Function - Video & PDF Instructions
-
Microsoft Excel 365 - TODAY Function - Video & PDF Instructions
-
Microsoft Excel 365 - Inserting the Current Date
-
Microsoft Excel 365 - Inserting the Current Date
-
Microsoft Excel 365 - Averaging Text Data
-
Microsoft Excel 365 - Averaging Text Data
-
Microsoft Excel 365 - Converting a Cell Displaying a Date to a Number
-
Microsoft Excel 365 - Converting a Cell Displaying a Date to a Number
-
Microsoft Excel 365 - UPPER Function - Video & PDF Instructions
-
Microsoft Excel 365 - Lower Function Video & PDF Instructions
-
Microsoft Excel 365 - Borders & Shading - Video & PDF
-
Microsoft Excel 365 - IF Function - Video and PDF Instructions
-
Microsoft Excel 365 - SUMIF Function - Video & PDF Instructions
-
Microsoft Excel 365 - FILTER Function - Video & PDF Instructions
-
Microsoft Excel 365 - How to find the Day of the Week from a date in Excel - Video & PDF
-
Microsoft Excel 365 - How to Remove Hyperlinks - Video and PDF Instructions
-
Microsoft Excel 365 - How to Remove Blank Rows from a Data List - Video & PDF
-
Microsoft Excel 365 - Graphing/Charting Specific Content - Video & PDF
-
Microsoft Excel 365 - New Window - Video & PDF
-
Microsoft Excel 365 - Hiding Columns - Video & PDF
-
Microsoft Excel 365 - Headers & Footers - Video & PDF
-
Microsoft Excel 365 - Save as PDF - Video & PDF
-
Microsoft Excel 365 - ROUND Function - Video & PDF
-
Microsoft Excel 365 - Basic Nested Functions - ie SUM and ROUND - Video & PDF
-
Microsoft Excel 365 - Filter a List by Colour - Video & PDF
-
Microsoft Excel 365 - Analyze Data - Video & PDF Instructions
-
Microsoft Excel 365 - Flash Fill Feature - Video & PDF Instructions
-
-
-
Microsoft Excel 365 - Introduction to Pivot Tables- Video & Instructions
-
Microsoft Excel 365 - How to Easily Create a Pivot Table by Leveraging Excel Tools - video and instructions
-
Microsoft Excel 365 - How to Change Pivot Table Formatting
-
Microsoft Excel 365 - How to Create Multiple Pivot Table Filter Reports - Video and PDF Download
-
Microsoft Excel 365 - How to Generate Detailed Pivot Table Reports - Video and instructions
-
Microsoft Excel 365 - How to Create Data Bars on Pivot Tables - Video and instructions
-
Microsoft Excel 365 - Slicers - Video and PDF Instructions
-
Microsoft Excel 365 - Pivot Charts - Video & PDF Instructions
-
Microsoft Excel 365 - Timelines - Video & PDF Instructions
-
Microsoft Excel 365 - How to Refresh a Pivot Table - Video & PDF
-
Microsoft Excel 365 - How to Adjust Pivot Table Field List Settings - Video & PDF
-
Microsoft Excel 365 - Pivot Tables - How to remove Autofit Column Setting
-
Microsoft Excel 365 - Nested Functions
-
Microsoft Excel 365 - Nested Functions
-
Microsoft Excel 365 - IFERROR nested into VLOOKUP
-
Microsoft Excel 365 - IFERROR nested into VLOOKUP
-
Microsoft Excel 365 - Protecting Worksheets and Files
-
Microsoft Excel 365 - Protecting Worksheets and Files
-
Microsoft Excel 365 - 2 Axis Chart
-
Microsoft Excel 365 - 2 Axis Graph
-
Microsoft Excel 365 - Custom Number Formats
-
Microsoft Excel 365 - Custom Number Formats
-
Microsoft Excel 365 - Droplists - Video & PDF
-
Microsoft Excel 365 - Macros Video & PDF
-
Microsoft Excel 365 - Linking Cells and Files - Video & PDF
-
Microsoft Excel 365 - Dependant Drop Lists
-
Microsoft Excel 365 - Dependant Droplists
-
Microsoft Excel 365 - How to Insert a PDF Table into Excel - Video and PDF Instructions
-
Microsoft Excel 365 - How to Insert a PDF Table into Excel
-
Microsoft Excel 365 - How to Access Version Control in Excel
-
Microsoft Excel 365 - How to Access Version Control in Excel
-
Microsoft Excel 365 - Trace Cell Dependents - Video & PDF Instructions
-
Microsoft Excel 365 - How to create a simple XLOOKUP Function - Video & Instructions
-
Microsoft Excel 365 - How to create a 4 argument XLOOKUP Function - Video & Instructions
-
Microsoft Excel 365 - How to create XLOOKUP Function including the 5th Argument - Video & Instructions
-
Microsoft Excel 365 - How to create XLOOKUP Function including wildcards - Video & Instructions
-
Microsoft Excel 365 - How to create XLOOKUP Function including the 6th Argument Search Order - Video & Instructions
-
-
-
Microsoft Excel 365 - How do I average a range of cells containing text instead of numbers?
-
Microsoft Excel 365 - How do I sort a list of data by multiple columns at the same time?
-
Microsoft Excel 365 - How do you change numbers that are showing in date format into numbers?
-
Microsoft Excel 365 - How do you colour a cell based upon the text within it?
-
Microsoft Excel 365 - If you have text in a column, can you Autosum the column?
-
Microsoft Excel 365 - Can you colour a cell based on it being past a particular date such as a due date?
-
Microsoft Excel 365 - What do the ### symbols mean in an Excel worksheet?
-
Microsoft Excel 365 - How to Calculate a Margin then Make it a % in Excel
-
Microsoft Excel 365 - How do I access versions of an Excel worksheet?
-
Microsoft Excel 365 - How do you import a PDF table into Excel?
-
Microsoft Excel 365 - How do I ensure my pivot table includes data I added to the end of the list?
-
Microsoft Excel 365 - How do I find out the day of the week from a date in Excel?
-
Microsoft Excel 365 - How do I rename a worksheet tab?
-
Microsoft Excel 365 - How do you put a phone number into a cell without the 0 being dropped?
-
Microsoft Excel 365 - How to Remove Hyperlinks
-

About this course
- Free
- 161 lessons
- 2 hours of video content