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

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.

Library Content

    1. How to Navigate or Search the Excel Library

    2. Got a Question?

    1. Microsoft Excel 365 - Understanding How Excel Treats Data - Video & PDF

    2. Microsoft Excel 365 - Mouse Pointers - Video & PDF

    3. Microsoft Excel 365 - Selection Techniques - Video & PDF

    4. Microsoft Excel 365 - Selecting All Data on Your Worksheet - Video & PDF

    5. Microsoft Excel 365 - Formatting Cells, Changing Fonts and Alignment Video & PDF Instructions

    6. Microsoft Excel 365 - Formulas vs Functions Video & PDF Instructions

    7. Microsoft Excel 365 - Best Practice for Creating Formulas with Multiple Mathematical Calculations - ie Add tax. Video & PDF Instructions

    8. Microsoft Excel 365 - Formula Basics - Video & PDF

    9. Microsoft Excel 365 - Relative vs Absolute Cell Referencing Video & PDF Instructions

    10. Excel 365 - Calculating Percentages

    11. Microsoft Excel 365 - SUM Function - Video and PDF

    12. Microsoft Excel 365 - Formatting Numbers in Excel - Video & PDF Instructions

    13. Microsoft Excel 365 - Understanding Graphs/Charts Video & PDF Instructions

    14. Microsoft Excel 365 - Date Formats Video and PDF Instructions

    15. Microsoft Excel 365 - Modifying Graphs/Charts

    16. Microsoft Excel 365 - Different Types of Graphs/Charts

    17. Microsoft Excel 365 - Basic Charts/Graphs Video & PDF

    18. Microsoft Excel 365 - Inserting Rows & Columns - Video & PDF

    19. Microsoft Excel 365 - Format Painter Video & PDF Instructions

    20. Microsoft Excel 365 - Moving Worksheets - Video & PDF

    21. Microsoft Excel 365 - Renaming & Colouring Worksheet Tabs Video & PDF Instructions

    22. Microsoft Excel 365 - Freeze Panes Video and PDF Download

    23. Microsoft Excel 365 - Converting Date to Numbers Video & PDF Instructions

    24. Microsoft Excel 365 - Wrap Text Video & PDF Instructions

    25. Microsoft Excel 365 - Find & Select - Video & PDF Instructions

    26. Microsoft Excel 365 - Print Titles Video & PDF

    27. Microsoft Excel 365 - Copy or Duplicate a Worksheet - Video & PDF

    28. Microsoft Excel 365 - Select all Data on a Worksheet

    29. Microsoft Excel 365 - Fit to a Page Video and PDF Instructions

    30. Microsoft Excel 365 - Inserting Excel Data into a Word Document - Video & PDF

    31. Microsoft Excel 365 - Setting Up Data Lists

    32. Microsoft Excel 365 - Copying & Pasting Options - Excel to Excel - Video & PDF Instructions

    33. Microsoft Excel 365 - Copying & Pasting Options - Excel to Word

    34. Microsoft Excel 365 - List of All Worksheets Video and PDF

    35. Excel 2016 (365) - Grouping Worksheets - Video and PDF

    36. Microsoft Excel 365 - Hiding Worksheets - Video and PDF

    37. Microsoft Excel 365 - Renaming & Coloring Worksheet Tabs - Video and PDF

    38. Microsoft Excel 365 - Merge & Center - Video and PDF

    39. Microsoft Excel 365 - Applying Borders & Shading - Video & PDF Instructions

    40. Microsoft Excel 365 - What do the ### symbols mean in an Excel worksheet? Video & PDF

    41. Microsoft Excel 365 - AVERAGE Function Video & PDF

    42. Microsoft Excel 365 - Rotating Text - Video & PDF

    43. Microsoft Excel 365 - Separating One Worksheet from a File

    44. Microsoft Excel 365 - Setting Up Data Lists - Video & PDF Instructions

    45. Microsoft Excel 365 - Basic Sort & Filter - Video & PDF Instructions

    46. Microsoft Excel 365 - Page Set Up - Video & PDF Instructions

    1. Excel 2016 (365) - Headers & Footers

    2. Excel 2016 (365) - Headers & Footers

    3. Excel 365 - Cell Notes - Video & PDF Instructions

    4. Excel 365 - Wrap Text - Video & PDF Instructions

    5. Excel 365 - Indenting Text - Video & PDF Instructions

    6. Excel 365 - Split Screen - Video & PDF Instructions

    7. Excel 365 - Text to Columns - Video & PDF

    8. Excel 2016 (365) - Viewing Two Files Side By Side

    9. Excel 2016 (365) - Viewing Two Files Side by Side

    10. Excel 365 - Hyperlinks - Video & PDF Instructions

    11. Excel 365 - Transpose Video & PDF

    12. Excel 365 - 3 Dimensional Formulas - Video & PDF

    13. Excel 365 - Grouping Worksheets - Video & PDF

    14. Excel 365 - Text to Numbers - Video & PDF

    15. Excel 365 - Subtotals - Video & PDF Instructions

    16. Excel 365 - Multiple Subtotals - Video & PDF Instructions

    17. Excel 365 - Custom Sort - Video & PDF Instructions

    18. Excel 365 - Conditional Formatting - Video & PDF

    19. Excel 2016 (365) - Conditional Formatting Rows

    20. Excel 2016 (365) - Conditional Formatting Rows

    21. Excel 365 - Conditional Formatting Based on Text - Video & PDF Instructions

    22. Excel 365 - Using Conditional Formatting to Highlight Unique Data in a list - Video & PDF

    23. Excel 365 - Concatenate Function - Video & PDF

    24. Excel 365 - Range Names - Video & PDF

    25. Excel 365 - VLOOKUP Function - Video & PDF Instructions

    26. Excel 365 - Format As Table - Video & PDF

    27. Excel 365 - Proper Function - Video & PDF

    28. Excel 365 - COUNT Function - Video and PDF

    29. Excel 365 - COUNTA Function - Video & PDF

    30. Excel 365 - COUNTIF Function - Video & PDF Instructions

    31. Excel 365 - COUNTBLANK Function - Video & PDF Instructions

    32. Excel 365 - TRIM Function - Video & PDF Instructions

    33. Excel 2016/365 - Inserting a Landscape Excel Worksheet into a Portrait Word Document

    34. Excel 2016 (365) - Inserting a Landscape Excel Worksheet into a Portrait Word Document

    35. Excel 365 - Remove Duplicates Video & PDF Instructions

    36. Excel 365 - NOW Function - Video & PDF Instructions

    37. Excel 365 - TODAY Function - Video & PDF Instructions

    38. Excel 2016 (365) - Inserting the Current Date

    39. Excel 2016 (365) - Inserting the Current Date

    40. Excel 365 - Averaging Text Data

    41. Excel 365 - Averaging Text Data

    42. Excel 365 - Converting a Cell Displaying a Date to a Number

    43. Excel 365 - Converting a Cell Displaying a Date to a Number

    44. Excel 365 - UPPER Function - Video & PDF Instructions

    45. Excel 365 - Lower Function Video & PDF Instructions

    46. Excel 365 - Borders & Shading - Video & PDF

    47. Excel 365 - IF Function - Video and PDF Instructions

    48. Excel 365 - SUMIF Function - Video & PDF Instructions

    49. Excel 365 - FILTER Function - Video & PDF Instructions

    50. Excel 365 - How to find the Day of the Week from a date in Excel - Video & PDF

    51. Excel 365 - How to Remove Hyperlinks - Video and PDF Instructions

    52. Excel 365 - How to Remove Blank Rows from a Data List - Video & PDF

    53. Excel 365 - Graphing/Charting Specific Content - Video & PDF

    54. Excel 365 - New Window - Video & PDF

    55. Excel 365 - Hiding Columns - Video & PDF

    56. Excel 365 - Headers & Footers - Video & PDF

    57. Excel 365 - Save as PDF - Video & PDF

    58. Excel 365 - ROUND Function - Video & PDF

    59. Excel 365 - Basic Nested Functions - ie SUM and ROUND - Video & PDF

    60. Excel 365 - Filter a List by Colour - Video & PDF

    61. Excel 365 - Analyze Data - Video & PDF Instructions

    62. Excel 365 - Flash Fill Feature - Video & PDF Instructions

    1. Excel 2016 (365) - Introduction to Pivot Tables- Video & Instructions

    2. Excel 365 - How to Easily Create a Pivot Table by Leveraging Excel Tools - video and instructions

    3. Excel - How to Change Pivot Table Formatting

    4. Excel 365 - How to Create Multiple Pivot Table Filter Reports - Video and PDF Download

    5. Excel 365 - How to Generate Detailed Pivot Table Reports - Video and instructions

    6. Excel 365 - How to Create Data Bars on Pivot Tables - Video and instructions

    7. Excel 365 - Slicers - Video and PDF Instructions

    8. Excel 365 - Pivot Charts - Video & PDF Instructions

    9. Excel 2016 (365) - Timelines - Video & PDF Instructions

    10. Excel - How to Refresh a Pivot Table - Video & PDF

    11. Excel 365 - How to Adjust Pivot Table Field List Settings - Video & PDF

    12. Excel 365 - Pivot Tables - How to remove Autofit Column Setting

    13. Excel 2016 (365) - Nested Functions

    14. Excel 2016 (365) - Nested Functions

    15. Excel 2016 (365) - IFERROR nested into VLOOKUP

    16. Excel 2016 (365) - IFERROR nested into VLOOKUP

    17. Excel 2016 (365) - Protecting Worksheets and Files

    18. Excel 2016 (365) - Protecting Worksheets and Files

    19. Excel 2016 (365) - 2 Axis Chart

    20. Excel 2016 (365) - 2 Axis Graphs

    21. Excel 2016 (365) - Custom Number Formats

    22. Excel 2016 (365) - Custom Number Formats

    23. Excel 365 - Droplists - Video & PDF

    24. Excel 365 - Macros Video & PDF

    25. Excel 2016 (365) - Macro Button

    26. Excel 2016 (365) - Macro Button

    27. Excel 365 - Linking Cells and Files - Video & PDF

    28. Excel 2016 (365) - Dependant Drop Lists

    29. Excel 2016 (365) - Dependant Droplists

    30. Excel 365 - How to Insert a PDF Table into Excel - Video and PDF Instructions

    31. Excel 2016 (365) - How to Insert a PDF Table into Excel

    32. Excel 2016 (365) - How to Access Version Control in Excel

    33. Excel 2016 (365) - How to Access Version Control in Excel

    34. Excel 365 - Trace Cell Dependents - Video & PDF Instructions

    35. Excel 365 - How to create a simple XLOOKUP Function - Video & Instructions

    36. Excel 365 - How to create a 4 argument XLOOKUP Function - Video & Instructions

    37. Excel 365 - How to create XLOOKUP Function including the 5th Argument - Video & Instructions

    38. Excel 365 - How to create XLOOKUP Function including wildcards - Video & Instructions

    39. Excel 365 - How to create XLOOKUP Function including the 6th Argument Search Order - Video & Instructions

    1. Excel 365 - How do I average a range of cells containing text instead of numbers?

    2. Excel 365 - How do I sort a list of data by multiple columns at the same time?

    3. Excel 365 - How do you change numbers that are showing in date format into numbers?

    4. Excel 365 - How do you colour a cell based upon the text within it?

    5. Excel 365 - If you have text in a column, can you Autosum the column?

    6. Excel 365 - Can you colour a cell based on it being past a particular date such as a due date?

    7. Excel 365 - What do the ### symbols mean in an Excel worksheet?

    8. Excel 365 - How to Calculate a Margin then Make it a % in Excel

    9. Excel 365 - How do I access versions of an Excel worksheet?

    10. Excel 365 - How do you import a PDF table into Excel?

    11. Excel 365 - How do I ensure my pivot table includes data I added to the end of the list?

    12. Excel 365 - How do I find out the day of the week from a date in Excel?

    13. Excel 365 - How do I rename a worksheet tab?

    14. Excel 365 - How do you put a phone number into a cell without the 0 being dropped?

    15. Excel 365 - How to Remove Hyperlinks

About this course

  • Free
  • 164 lessons
  • 2 hours of video content