MICROSOFT EXCEL

Top 15 Shortcuts That You Must Know to Save Time
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
How to create a Pivot Table in Excel
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
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 c...
Fri, 5 Nov, 2021 at 12:43 PM
How to print data on one page in Excel
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
How to create an Excel drop down list
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
How to use Countif in Excel
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
How to conditional format an entire row based on dates older than today
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
TOP 15 SHORTCUTS THAT YOU MUST KNOW TO SAVE TIME
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
Excel giving you the wrong answer? Discover BIDMAS and Excel
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
How to store a custom list in Excel
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