• Call Us: +61 409551614

FREE Tips and Tutorials

The Office Expert has compiled a range of FREE Tips and Tutorials via videos and PDF documents. Simply click on and follow along with these user-friendly instructional videos and pause and replay as needed. If you are having difficulties viewing these tutorials, be sure to check them out directly on our The Office Expert’s YouTube channel to see our full range of resources.

Subscribe to our Social Media and Stay up to Date

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

If you would like to see more tasks and topics in our range of tutorials, please visit our Contact page and let us know. Tell us which issues you are having and would like us to cover. We’ll take your suggestion into consideration for our next video and might even mention your name as a thanks.
We also post our free tips and Tutorials onto our Facebook page, so please Like Like our page to stay up to date here: Facebook

  • Fix your Keyboard
    Have you spilled fluids over your keyboard before? Maybe consider trying this next time...
  • Hidden Objects in Word
    Select objects (i.e. Image, Textbox, WordArt, Checkbox) which are hidden behind text in Word
  • 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...
  • 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...
  • Create and Save a Custom Header in Word
    Save a Header you created in Word and save it to your Building Block...
  • Configure Dual Monitors in Windows 10
    Change Settings in Windows 10 so your mouse can move in the correct direction...
  • 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...
  • 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