Free Online Microsoft Training
Free tips and tricks for using Microsoft 365 and Windows
Free Online Microsoft Training
A very common request in any of my Excel courses is “how to show duplicates in Excel”. When we are working with any data set you may need to be
With the popularity of Microsoft Planner continuing to go up, I often have people ask me how they can get a list of tasks which have been tracked using Excel,
I recently had an email from a client asking me to assist with an error in one of their Excel files. I opened the file to take a look and
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
Recently I was asked about how to automatically create calendar appointments in Outlook (Classic version) using dates in an Excel workbook. This was something I’d not been asked before and
Are you still using VLOOKUP or HLOOKUP in Excel? It’s time to upgrade and learn how to use XLOOKUP in Excel which provides a powerful and more flexible lookup function.
Flash Fill in Excel is by far one of my favourite Excel features. Learning how to use Flash Fill in Excel should be on everyone’s to do list. It is
One of the first features that many users begin using is the ability to sort data in Excel. Being able to automatically have your data displayed in a specific order,
For those that are new to Pivot Tables, or PivotTables in Excel, a pivot table allows you to summarise, analyse, sort, group, sum, count, total, and calculate data all with
Last week I received an SOS from a good friend. She had data that was exported from an LMS and being used for analysis within Excel. A particular column contained
I’ve run a lot of Excel training. One of the most common questions is “How do I print an Excel sheet on one page?”. The idea sounds simple doesn’t it?
If you have ever seen a drop down menu in Excel and wondered how to set one up, you are in the right place. Creating an Excel drop down list