Use buttons to filter articles by category..
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 …
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 …
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 …
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 …
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 …
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 …
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. …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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, …
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. …
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 …
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 …
