free online microsoft training

Free tips and tricks for using Microsoft Office and Windows

Use buttons to filter articles by category..

  • All
  • Microsoft Excel
  • Microsoft Forms
  • Microsoft OneNote
  • Microsoft Outlook
  • Microsoft PowerPoint
  • Microsoft Sway
  • Microsoft Teams
  • Microsoft Windows
  • Microsoft Word
All
  • All
  • Microsoft Excel
  • Microsoft Forms
  • Microsoft OneNote
  • Microsoft Outlook
  • Microsoft PowerPoint
  • Microsoft Sway
  • Microsoft Teams
  • Microsoft Windows
  • Microsoft Word
How to use Countif in Excel
Microsoft Excel

How to use Countif in Excel

When working with large amounts of data in Excel, you can find yourself needing to count the number of records which meet specific criteria. This is when the Excel Countif …

Read Now →
Which version of OneNote do you have
Microsoft OneNote

How to tell which version of OneNote you have

As much as I am a dedicated fan of Microsoft products, I feel this is a really confusing area for many. Microsoft has several different versions of OneNote available and …

Read Now →
Conditional formatting an entire row
Microsoft Excel

How to conditional format an entire row based on dates older than today

It seems my conditional formatting posts have become quite popular and with that, I’ve had some amazing questions asked about variations of how to use conditional formatting. If you haven’t …

Read Now →
How to create a Sway presentation
Microsoft Sway

How to create a digital presentation using Microsoft Sway

This past week I had the pleasure of presenting at the Leading a Digital School Conference and showing attendees how to use Microsoft Sway. To provide participants with some additional …

Read Now →
Create a quiz using Microsoft Forms
Microsoft Forms

How to create an online quiz using Microsoft Forms

This week I am presenting a few sessions at the Leading a Digital School Conference being held in Melbourne, Australia. This post outlines my second session which is going to …

Read Now →
3D Model Animations in PowerPoint
Microsoft PowerPoint

3D Model Animations in PowerPoint 365

This week I am presenting a few sessions at the Leading a Digital School Conference being held in Melbourne, Australia. To provide participants with some additional resources I am publishing …

Read Now →
Conditional Formatting date ranges
Microsoft Excel

Use conditional formatting to identify dates within a specific range

My conditional formatting to identify dates earlier than today post has proven to be extremely popular. This post talks about how to conditional format dates within occur in the past. …

Read Now →
BIDMAS acronym
Microsoft Excel

Excel giving you the wrong answer? Discover BIDMAS and Excel

An important part of understanding how Excel calculates formulas and functions is understanding BIDMAS. Let’s think back to math class. I remember the teacher talking about BIDMAS and vividly thinking …

Read Now →
How to display a second time zone in your Outlook Calendar
Microsoft Outlook

How to display a second time zone in your Outlook Calendar

For anyone with friends, relatives or colleagues living in a different time zone, it can be a fun maths game to work out what the time is where they are …

Read Now →
How to change line spacing between bullet and number lists
Microsoft Word

How to change spacing between items in a list in Word

I use bullet and numbered lists a lot. They help me to summarise information and make my text stand out. I like to have my list items spaced apart a …

Read Now →
How to Mail Merge bulk emails in Word
Microsoft Outlook

How to send bulk emails using Mail Merge in Word

For the most part, I find people have heard of a Mail Merge. The process of combining a list of contacts with a letter which you can then merge together …

Read Now →
Create a custom list in Excel
Microsoft Excel

How to store a custom list in Excel

Do you have a list of entries you use frequently in Excel? Sick of having to type them in or copy and paste from another workbook? What if I told …

Read Now →
Create folders to store emails in Outlook
Microsoft Outlook

Create folders to store emails in Outlook

Inspired by my achievement this week of reducing the number of emails in my inbox from over 1,000 down to 296, I thought it would be a great idea to …

Read Now →
Receive automatic updates from your favourite websites using RSS
Microsoft Windows

How to subscribe to your favourite websites using RSS

How often do you check back on your favourite website to see if new content has been uploaded? How would you like to automatically subscribe to your favourite websites? If …

Read Now →
How to reuse text and images using Quick Parts in Outlook
Microsoft Outlook

How to reuse text and images using Quick Parts in Outlook

As a business owner, I spend a significant amount of time responding to and sending email messages. Often I need to respond to the same question once or twice a …

Read Now →
Rehearse timing for your presentation
Microsoft PowerPoint

Rehearse timings of your PowerPoint presentation

A common concern for any presenter is knowing if they have enough content or too much in their presentation. The Rehearse Timings feature in Microsoft PowerPoint provides a quick and …

Read Now →
Create a shortcut to a specific folder on the Taskbar
Microsoft Windows

How to create a folder shortcut on the Taskbar

Last week one of my clients experienced a hardware failure on their main computer. It’s a computer users worst nightmare and occurred in the middle of an important week of …

Read Now →
Microsoft Windows

How to crop an image using Microsoft Paint

This week I had a request to show participants how to crop an image using Microsoft Paint. Most of the Microsoft Office products include a cropping tool but it only …

Read Now →
How to back up data using Windows Backup and Restore
Microsoft Windows

Back up data using Windows Backup and Restore

In an earlier post titled Backing up your files – a vital step to securing your data, I outlined the basic information needed for any user to begin the process of …

Read Now →
How to backup data using File History (Windows 10)
Microsoft Windows

Backup data using File History (Windows 10)

In an earlier post titled Backing up your files – a vital step to securing your data, I outlined the basic information needed for any user to begin the process of …

Read Now →
Use PowerPoint animations to make an object appear and disappear
Microsoft PowerPoint

Use PowerPoint 2016 animations to make an object appear and disappear

This week I saw a great question on an online forum relating to Microsoft PowerPoint. The question asked how to make an object appear on screen for a few seconds, …

Read Now →
Pin a file or folder to the Open list
Microsoft Excel

Save time! Pin a file to the Open list in Microsoft Office

At the start of every training course, I show participants through a few really useful features of the Microsoft Office programs. These features save you time during a busy workday. …

Read Now →
Quick Parts - the quickest way to insert reusable information in Word
Microsoft Word

Quick Parts – the quickest way to insert reusable information in Word

Today I saw a question on an online forum where a user needed to insert the same name and address quite frequently into a Word document. The user had asked …

Read Now →
Free up mailbox space and download email to Microsoft Outlook
Microsoft Outlook

Free up mailbox space and download email to Microsoft Outlook

I’ve encountered more than a few clients now who have run into issues with their allocated mailbox space. Depending on your hosting provider, you could be provided with email storage …

Read Now →