How to show duplicates in Excel
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 alerted when duplicate records exist. This process is surprisingly simple to set up and have Excel alert you with a change in formatting when a […]
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 analysing survey results, COUNTIFS allows you to count exactly what you need with precision. If […]
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 (Classic version) 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 of using Power Automate, and unfortunately found no options. A few weeks later […]
How to use Flash Fill in Excel
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 those features which amazes participants during any of my Excel training courses and it’s the most frequent feature that people come back and […]
How to sort data in Excel
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, whether that be number, alphabetical or date order, is a huge time saver. Excel allows you to sort by one column at a time or […]
How to create a Pivot Table in Excel
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 a few simple steps. Pivot tables can seem quite daunting to users who have not used them before. Learning how to create a Pivot Table […]
How to convert text to date format in Excel
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 a date and time in each cell that needed to be filtered and sorted by month. This was proving impossible as the data was being […]
How to use COUNTIF in Excel
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 of time. Let’s take a look at how the Excel COUNTIF function works and how […]