• Call Us: +61 409551614

FREE Tips and Tutorials

The Office Expert has devised a range of FREE Tips and Tutorials in video and PDF format. Simply click on the videos below to be guided through these instructional videos. The great thing about referring to our how-to videos is, you can and pause and replay them as needed. Also, if you are having difficulties viewing these tutorials, be sure to check them out directly on our The Office Expert’s YouTube channel. With one click of the mouse on the “Watch on YouTube” link at the bottom of the videos, you’ll be able to see them full screen! After that, be sure you provide us with some feedback and let us know how you like it.

The Office Expert YouTube Channel

Subscribe to our Free Tutorials

Our ‘How-To’ instructional videos are updated frequently and contain lessons and FREE tips on Word, Excel, Outlook, Basic PC and more. Ensure you subscribe to our YouTube Channel to stay up-to-date with our FREE Tips and tutorials.

If you would like to see a specific topic covered in our range of tutorials, please let us know. Simply, tell us which issues you are having difficulty with and would like us to cover in more detail. We’ll take your suggestion into consideration for our next video and might even mention your name as a thanks.

The Office Expert Facebook Page

Check out our Facebook Page

Since opening our Facebook page, we have posted many great tips onto our page. Software apps are always upgrading, so please Like Like our page to stay up to date with all our news. Additionally, message us and tell us which topics you’d like to hear more about.

  • Share and Unshare a Google Drive Folder
    Share and Unshare a Google Drive Folder (2 Methods in Chrome 2022)
  • Remove a Shared Dropbox Folder without deleting it
    Correctly Remove a Shared Dropbox Folder without deleting it
  • Disable 'Show more options' feature in File Explorer
    Disable 'Show more options' feature in File Explorer of Win 11
  • Microsoft Outlook - Show as Conversations out of Date Order
    Microsoft Outlook - Show as Conversations Emails out of Date Order
  • Fix & Sort Home Directory Quick Access Folder
    Fix & Sort Home Directory Quick Access Folder
  • Fix your Keyboard
    Have you spilled fluids over your keyboard before? Maybe consider trying this next time...
  • Hidden Objects in Word
    Select hidden Word objects (i.e. Image, Textbox, WordArt, Checkbox)
  • Sort by Date in Excel
    Sort an Excel spreadsheet by date or any other column of data
  • Subtotalling & Outlining in Excel
    How to Subtotal or Outline a spreadsheet easily for improved use
  • Insert Columns in a Word Document
    Convert a paragraph of text into 2 columns or 3 columns & then back again...
  • Access and Change Document Properties in Excel
    Change the Author or Owner's name in your Word Document properties
  • Absolute vs Relative Cell References in Excel
    Learn Formulas in Excel and how to calculate efficiently using Absolutes
  • Use Format Painter for Fast Formatting
    How to use Format Painter, the tool that makes formatting quick and easy
  • Apply a Filter to a Column in Excel Spreadsheets
    Filter large data sources to display only record that match a specified criteria
  • Create Desktop Shortcuts in Windows
    Create a desktop shortcut in Windows to your Documents in any version
  • Formatting Efficiently in Word
    Reveal and display hidden Non-Printing Characters in Word
  • Flash Fill in EXCEL
    Automatically extract data from a column by typing the format you want in the next...
  • Create and Save a Custom Header in Word
    Save a Header you created in Word and save it to your Building Block Gallery
  • Configure Dual Monitors in Windows 10
    Change Settings in Windows 10 so your mouse can move in the correct direction towards...
  • Restore Missing Photoshop Tools in Toolbox
    Restore and organise your tools in your Photoshop Toolbox to improve workflow
  • Stop Spam Permanently from the Roots
    Get spammers deregistered, suspended and blacklisted
  • Create Facebook Event Longer than 2 weeks
    Add opening & closing times for each day in Facebook events longer than 2 weeks
  • Update Excel Formulas Automatically
    Force Excel's formulas to update and calculate automatically
  • Outlook Compact View
    Restrict the Outlook Mail Items from reverting to Compact Layout view.
  • Formulas and Multiplication in Excel
    Build a basic multiplication formula and understanding calculations in Excel