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 - Inserting Rows & Columns - Video & PDF

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

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

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

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

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

    11. Microsoft Excel 365 - Focus Cell - What it is and how to use it

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

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

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

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

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

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

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

    19. Microsoft Excel 365 - Calculating Percentages

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

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

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

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

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

    25. Microsoft Excel 365 - Modifying Graphs/Charts

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

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

    28. Microsoft Excel 365 - Print Titles Video & PDF

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

    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. Microsoft Excel 365 - Hiding Worksheets - Video and PDF

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

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

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

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

    40. Microsoft Excel 365 - AVERAGE Function Video & PDF

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

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

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

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

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

    1. Microsoft Excel 365 - Headers & Footers

    2. Microsoft Excel 365 - Headers & Footers

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

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

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

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

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

    8. Microsoft Excel 365 - Viewing Two Files Side By Side

    9. Microsoft Excel 365 - Viewing Two Files Side by Side

    10. Microsoft Excel 365 - Hyperlinks - Video & PDF Instructions

    11. Microsoft Excel 365 - Transpose Video & PDF

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

    13. Microsoft Excel 365 - Grouping Worksheets - Video & PDF

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

    15. Microsoft Excel 365 - Subtotals - Video & PDF Instructions

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

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

    18. Microsoft Excel 365 - Conditional Formatting - Video & PDF

    19. Microsoft Excel 365 - Conditional Formatting Rows

    20. Microsoft Excel 365 - Conditional Formatting Rows

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

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

    23. Microsoft Excel 365 - Concatenate Function - Video & PDF

    24. Microsoft Excel 365 - Range Names - Video & PDF

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

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

    27. Microsoft Excel 365 - Proper Function - Video & PDF

    28. Microsoft Excel 365 - COUNT Function - Video and PDF

    29. Microsoft Excel 365 - COUNTA Function - Video & PDF

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

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

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

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

    34. Microsoft Excel 365 - Inserting a Landscape Excel Worksheet into a Portrait Word Document

    35. Microsoft Excel 365 - Remove Duplicates Video & PDF Instructions

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

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

    38. Microsoft Excel 365 - Inserting the Current Date

    39. Microsoft Excel 365 - Inserting the Current Date

    40. Microsoft Excel 365 - Averaging Text Data

    41. Microsoft Excel 365 - Averaging Text Data

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

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

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

    45. Microsoft Excel 365 - Lower Function Video & PDF Instructions

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

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

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

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

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

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

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

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

    54. Microsoft Excel 365 - New Window - Video & PDF

    55. Microsoft Excel 365 - Hiding Columns - Video & PDF

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

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

    58. Microsoft Excel 365 - ROUND Function - Video & PDF

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

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

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

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

    1. Microsoft Excel 365 - Introduction to Pivot Tables- Video & Instructions

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

    3. Microsoft Excel 365 - How to Change Pivot Table Formatting

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

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

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

    7. Microsoft Excel 365 - Slicers - Video and PDF Instructions

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

    9. Microsoft Excel 365 - Timelines - Video & PDF Instructions

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

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

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

    13. Microsoft Excel 365 - Nested Functions

    14. Microsoft Excel 365 - Nested Functions

    15. Microsoft Excel 365 - IFERROR nested into VLOOKUP

    16. Microsoft Excel 365 - IFERROR nested into VLOOKUP

    17. Microsoft Excel 365 - Protecting Worksheets and Files

    18. Microsoft Excel 365 - Protecting Worksheets and Files

    19. Microsoft Excel 365 - 2 Axis Chart

    20. Microsoft Excel 365 - 2 Axis Graph

    21. Microsoft Excel 365 - Custom Number Formats

    22. Microsoft Excel 365 - Custom Number Formats

    23. Microsoft Excel 365 - Droplists - Video & PDF

    24. Microsoft Excel 365 - Macros Video & PDF

    25. Microsoft Excel 365 - Linking Cells and Files - Video & PDF

    26. Microsoft Excel 365 - Dependant Drop Lists

    27. Microsoft Excel 365 - Dependant Droplists

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

    29. Microsoft Excel 365 - How to Insert a PDF Table into Excel

    30. Microsoft Excel 365 - How to Access Version Control in Excel

    31. Microsoft Excel 365 - How to Access Version Control in Excel

    32. Microsoft Excel 365 - Trace Cell Dependents - Video & PDF Instructions

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    15. Microsoft Excel 365 - How to Remove Hyperlinks

About this course

  • Free
  • 161 lessons
  • 2 hours of video content