Free Online Microsoft Training
Free tips and tricks for using Microsoft 365 and Windows
Free Online Microsoft Training
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
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. One such question
My conditional formatting to identify dates earlier than today post has proven to be extremely popular. This post talks about how to use conditional formatting for dates which occur in
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
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
At the start of every training course, I show participants through a few really useful features of the Microsoft 365 programs. These features help save you time during a busy
During a Microsoft Excel training session a few week’s ago, I had a great question about using conditional formatting based on dates, in particular to highlight dates earlier than the current one,
Did you know that you can insert Excel into Word? That’s right, you can have the functionality of an Excel worksheet sitting inside your Word document. This is one of
Want to become more efficient using Excel? Let me show you the best Excel shortcuts that I personally use every day. If you’ve ever attended one of my training sessions,
In the recent versions of Microsoft 365, you’ll notice a Start screen appear whenever you open apps like Word, Excel or PowerPoint. It’s designed to give you quick access to
For those starting out using the Microsoft 365 apps and even for those familiar with the programs, our computers can sometimes be a treasure trove full of so many programs
Each of the Microsoft programs includes some basic clipboard options which incorporate the Cut, Copy and Paste functions. Generally users are pretty familiar with these tools. What many users have