How to use XLOOKUP in Excel
Many users of Excel will be familiar with the lookup functions called Vlookup and Hlookup. Many Excel users however, have not yet explored how to use Xlookup. Xlookup is an
Free tips and tricks for using Microsoft Office and Windows
Free tips and tricks for using Microsoft Office and Windows
Many users of Excel will be familiar with the lookup functions called Vlookup and Hlookup. Many Excel users however, have not yet explored how to use Xlookup. Xlookup is an
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 onto one page in Excel?”. The idea sounds simple, doesn’t it? I
When you are entering data in Excel you may want to ensure your data is entered in a consistent way. Maybe you have multiple people working on the same file
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. If you haven’t
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.