Free Online Microsoft Training

Free tips and tricks for using Microsoft 365 and Windows

Free Online Microsoft Training

Recent Posts

How to use the COUNTIFS Function in Excel

How to use the COUNTIFS Function in Excel

When managing data in Excel, it’s common to need a quick way to count entries based on more than one condition. That’s where the COUNTIFS function in Excel becomes incredibly useful. Whether you’re sorting customer orders, tracking project tasks, or ...
How to time-limit access to a Microsoft Form

How to time-limit access to a Microsoft Form

Microsoft Forms is still a relatively new app within the Microsoft 365 ecosystem but allows you to easily create surveys, quizzes and feedback forms and is available as part of any existing Microsoft 365 subscription. One particularly useful feature is ...
/ Microsoft Forms, Quiz, Survey
How to embed Sway into a website

How to embed Sway into a website

There are multiple ways to share a Sway with others, whether with individuals or groups. In addition to sharing via a link, you can also embed a Sway directly into your website. This allows your interactive content to be displayed ...
How to create a Plan in Microsoft Planner

How to create a Plan in Microsoft Planner

In the second post of the Microsoft Planner category I will step you through the process to create a Plan using the Planner interface. We'll also look at some of the other basic functions including how to make a copy ...
How to use the Cameo feature in PowerPoint

How to use the Cameo feature in PowerPoint

The Cameo feature in PowerPoint is a relatively new feature and allows users to integrate live video feeds into a presentation. By embedding your live webcam feed directly onto slides you can create a more personal and interactive experience for ...
How to create a channel in Microsoft Teams

How to create a channel in Microsoft Teams

When users begin working with Microsoft Teams, it is important to understand the concept of using channels. The use of channels in Microsoft Teams provides a powerful way to organise conversations, files, and tasks within a team. Channels allow you ...
What is Microsoft Planner?

What is Microsoft Planner?

YAY Planner is now a category with The Training Lady! I've been training Microsoft Planner for years but so far hadn't added any content for it to the website. Well the time is here and this marks the first of ...
How to Shuffle Questions in a Microsoft Form

How to Shuffle Questions in a Microsoft Form

Microsoft Forms is a part of the Microsoft 365 suite of programs and allows you to create surveys, quizzes, and polls with ease. It is a popular choice for educators, businesses, and individuals alike. One of its wonderful features is ...
/ Microsoft Forms, Quiz, Survey
How to take a screenshot on Windows 11

How to take a screenshot on Windows 11

Several years ago I wrote about using the Snipping Tool in Windows 10. Now that Windows 11 is available I wanted to give an update on how to take a screenshot on Windows 11 using the newest version of the ...
How to delete a Notebook in OneNote

How to delete a notebook in OneNote

Knowing how to delete a notebook in OneNote is an important part of managing your notebooks effectively. Regularly reviewing and removing notebooks you no longer need helps keep things organized and makes it easier to find important information. There are ...
/ Microsoft OneNote, Note Taking
How to create an Index in Word

How to create an Index in Word

Being able to create an index in Word is an invaluable skill for organising and navigating long documents. The Index feature in Word allows you to automatically generate a list of page numbers corresponding to a word or phrase within ...
How to create appointments in your Outlook Calendar from dates in Excel

How to create appointments in your Outlook Calendar from dates in Excel

Recently I was asked about how to automatically create calendar appointments in Outlook using dates in an Excel workbook. This was something I'd not been asked before and it peaked my curiousity. I did some research online around the idea ...
How to edit the design of a Sway

How to edit the design of a Sway

One of the great aspects of creating with Microsoft Sway is the fact you don’t need to spend a huge amount of time trying to style the presentation. Sway has a built-in design gallery which lets you switch between different ...
How to create links between slides in PowerPoint

How to create links between slides in PowerPoint

Whenever we create a presentation, we want to captivate our audience and highlight the important information we are delivering. While many users are familiar with the basics of creating slides, many users are not aware that you can create links ...
How to create Quick Steps in Outlook

How to create Quick Steps in Outlook

Quick Steps in Outlook allow you to automate actions that you use on a regular basis. These actions may include forwarding emails to a specific person or group, moving emails to a specific folder or replying to an email. Quick ...
How to use XLOOKUP in Excel

How to use XLOOKUP in Excel

Many users of Excel will be familiar with the lookup functions called Vlookup and Hlookup. Many Excel users however, have not yet explored how to use Xlookup. Xlookup is an extension of the original VLOOKUP and HLOOKUP functions but removes ...
/ Formulas, Functions, Microsoft Excel
How to create a To Do List in OneNote

How to create a To Do List in OneNote

Microsoft OneNote is a versatile note-taking application that can help you stay on top of your to-do list by allowing you to organise your daily tasks. I'm personally a huge fan of OneNote and it's one of my favourite courses ...
The best keyboard shortcuts in Microsoft Teams

The best Microsoft Teams keyboard shortcuts

If you are using Microsoft Teams then you will want to stick around and find out about some time saving keyboard shortcuts you can use within the Teams desktop app. Keyboard shortcuts are not just for Word, Excel or PowerPoint ...
/ Microsoft Teams, Shortcuts
How to add a Rating question in Microsoft Forms

How to add a Rating question in Microsoft Forms

For those who are new to exploring Microsoft Forms, you may have noticed the Rating question type. The Rating question type allows users to provide a rating based on how much they like or dislike the scenario you have proposed ...
/ Evaluation, Microsoft Forms, Quiz, Survey
Use Cut, Copy and Paste in Microsoft Word

Use Cut, Copy and Paste in Microsoft Word

Microsoft Word is known as the go-to option for any type of word processing tasks. To ensure you are maximising your productivity when creating new documents or working with existing documents, it's crucial to master fundamental features such as Cut, ...
How to get the NEW Microsoft Teams app

How to get the NEW Microsoft Teams app

In late 2023 Microsoft released an entirely new Microsoft Teams desktop app. The new desktop app has been rebuilt from the ground up to provide a faster, simpler, and more flexible user experience. The original Microsoft Teams app is now ...
/ Microsoft Teams, Teamwork
How to create a folder in Windows

How to create a folder in Windows

Folders are an important feature of any computer as they allows users to organise and store files in a logical way. A folder is a container for files and other folders, and it can be used to group related files ...
/ Microsoft Windows
How to customise the Image card in Sway

How to customise the Image card in Sway

The Image card in Microsoft Sway allows you to display images. Image sources can include OneDrive, Flickr, Bing Images, Pickit, YouTube or directly uploaded from your computer. The use of images and photos with your Sway helps to convey information ...
/ Microsoft Sway, Presentation, Slide show
How to compress images in PowerPoint

How to compress images in PowerPoint

A common issue that arises with many PowerPoint presentations is an inflated file size. It's too big to email or it's slowing down the computer during the presentation. So let's look at how to compress images in PowerPoint to reduce ...