MICROSOFT EXCEL
SELECT ALL DATA Press this command to quickly select all the data in your worksheet. FIND Use this shortcut to quickly open the find and rep...
Fri, 15 May, 2020 at 1:09 PM
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 ...
Fri, 5 Nov, 2021 at 12:24 PM
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 c...
Fri, 5 Nov, 2021 at 12:43 PM
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 hav...
Fri, 5 Nov, 2021 at 12:58 PM
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 fi...
Fri, 5 Nov, 2021 at 1:33 PM
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 ...
Fri, 5 Nov, 2021 at 1:38 PM
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 con...
Fri, 5 Nov, 2021 at 2:04 PM
SELECT ALL DATA Press this command to quickly select all the data in your worksheet. FIND Use this shortcut to quickly open the find and rep...
Fri, 5 Nov, 2021 at 2:08 PM
An important part of understanding how Excel calculates formulas and functions is understanding BIDMAS. When anyone starts using Excel for formulas it is...
Fri, 5 Nov, 2021 at 2:48 PM
Do you have a list of entries you use frequently in Excel? Sick of having to type them in or copy and paste from another workbook? What if I told you that...
Fri, 5 Nov, 2021 at 2:52 PM