Quick Tip
-
What’s An Excel Formula vs Function
Excel users often get the two things mixed so please allow me to briefly explain the difference between an Excel Function vs an Excel Formula.…
-
My 15 Favourite Excel Shortcuts using Ctrl +
You are probably well aware that by using shortcuts you can perform actions in Excel with the press of a key, or with the press…
-
SUM() Formula in Excel
The SUM() formula in Excel is one of the simplest and most used formulas available. The SUM() formula shows the total of the selected range…
-
How To Transpose Data in Excel a.k.a. move data from rows to columns
So, picture this, you have all your data set up in tidy columns and rows. Then you realise that you’d prefer rows of your data…
-
Reminder: Excel Is FREE Online
For anyone who is reluctant or unable to pay for the full version of Excel, may I remind you that the online version of Excel…
-
This Is PROPER() Good In Excel
In this blog post, we’ll take a look at the PROPER function in Excel, which is guaranteed to save you time and effort when handling…
-
Use EDATE() To Add (Or Remove) Months To A Date
I only recently found out about the EDATE() function in Excel and I love it. I wish I’d known about it long before now. It’s…
-
How to use Flash Fill
What did we do before Excel offered Flash Fill? I can’t quite recall but I do remember it involved lots of Find, Left, Right and…
-
SEARCH or FIND in Excel?
The =SEARCH and =FIND functionality in Excel may sound very similar, and they are. I use =SEARCH when I’m trying to find text regardless of…