• 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.

  • 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