When you are entering data in Excel you may want to ensure your data is entered in a consistent way. Maybe you have multiple people working on the same file and you are constantly having to correct entries due to ...

Being able to access OneNote online offers convenient and flexibile access to your notes from anywhere with an internet connection. Whether you're at work, traveling, or away from your primary device, accessing your OneNote notebooks online ensures that your crucial ...

If you are new to Microsoft Teams, this article is for you. Here I will outline how to log in to Microsoft Teams, the Teams window, how to change your account settings, and show you some quick shortcuts for moving ...

Microsoft Teams provides an amazing collaboration and communication platform which builds in many fantastic features including video conferencing, file sharing, chat and more. One of the common questions I am asked relates to being able to see all participants in ...

Microsoft Forms is a great program which allows you to create interactive forms including surveys, quizzes, evaluations and much more. Once you have created the form, you are going to need to share that form with others. Those people may ...

Recently I saw a question asking how to create a "memory game", or a game of concentration using Microsoft 365. While there are third-party programs that can do this, I assumed that there would be a way to create this ...

A great question I saw online related to creating a spelling test using Microsoft 365. The teacher did not want students to have access to a spell check function for obvious reasons. This ruled out using Microsoft Word or PowerPoint ...

If you create a presentation using Microsoft Sway, you can give access to others by sharing the Sway link. You may, however, want a little more security for your Sway by means of password protection. Applying a password to your ...

That time of year has come around again when this website celebrates another milestone. This year we turn 6. When I started this website back in July 2014, I didn't have a long term goal. I simply wanted to create ...

Immersive Reader is an amazing tool which uses proven techniques to help users read and comprehend text regardless of age or reading ability. If you have not yet discovered Immersive Reader in OneNote then you are missing out. The Immersive ...

If you are creating forms using Microsoft Forms then let me show you how to incorporate sections into those forms. Sections allow you to divide your form into, as the name implies, sections! This allows your users to fill out ...

Wondering how to convert a document from Word to PDF format? Well many moons ago, Microsoft added this feature directly into the Microsoft products and lots of people didn't notice and still haven't. Whilst there are lots of programs on ...

When working with a large amount of data in Excel, you may find yourself needing to count the number of records which meet a specific criteria. This is when the Excel Countif function is going to save you a lot ...

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 being able to tell which version of OneNote you have ...

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 already taken a look at my other conditional formatting posts, ...

In 2021 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 resources I have published a series of posts which contain information ...

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 show you how to create an online quiz using Microsoft ...

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 a series of posts which contain information from my sessions ...

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. I have had plenty of questions and comments based on ...

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 that I'd never need to use it. Attend any Excel ...

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 located. Personally I'm having to do this now after a ...

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 little, I don't want them all squashed together. Let me ...

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 and print. Did you know that you can also use ...

Do you have a list of data you use frequently in Excel? Sick of repeatedly typing them in, or having to copy and paste from another workbook? What if I told you that you could save these entries in Excel ...