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,
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,
Learning how to create a Pivot Table in Excel is one of the most useful skills you can have when working with large amounts of data. A pivot table allows
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 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
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.
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 having to repeatedly type them in or copy and paste from another workbook? What if I