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, ...
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 resources I am publishing a series of posts which contain ...
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 having to repeatedly type them in or copy and paste from another workbook? What if I told you that you could save these entries as a ...
Inspired by my achievement this week where I reduced the number of emails in my inbox from over 1,000 down to 296, I thought it would be a great idea to touch on the processes of how to create folders ...
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 you are like me, then the answer to this question ...
As a business owner, I spend a significant amount of time managing my emails. I often need to respond to the same questions several times a week. This is where Quick Parts in Outlook saves me time and sanity. Not ...
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 simple way to rehearse the timing of your presentation. This ...
The 24th of July marked the 4th birthday of "The Training Lady" blog. This year I spent this occasion with my two girls playing in the snow! We had a lovely break away with friends in the crisp clear air of ...
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 work. Long story short, I was able to source a ...
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 crops the image within that specific program. Microsoft Paint can ...
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 backing up data on a regular basis. In this post, ...
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 backing up data on a regular basis. In this post, ...
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, and then make it disappear only to be replaced with ...
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. One such feature is AutoCorrect, another is the ability to ...
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 if a drop-down menu in Word would provide a quicker ...
