Welcome to your weekly 3 tip Friday update, it’s just a short dose of Excel help before you start the weekend. Each week we’ll cover a tip, a shortcut and a function - making it super easy for you to get better at Excel.
If you find this useful or have requests or ideas for future editions, send me a message or comment at the bottom of this post! Now, on with the tips.
A quick win you can learn today -
I never cease to be amazed at how many reports or dashboards have no explanation as to what metrics mean or how they were calculated. It can lead to misinterpretation of reporting, and ultimately can mislead decision making.
Whenever I create a report or dashboard or even a data file which will be used by others, I always try to include a data dictionary or glossary to explain the workings behind the file. Even if it ends up not being used, you can use it as a reference guide to answer frequently asked questions and build procedure notes for your work.
A keyboard shortcut I'm adding to my list -
Ctrl + V is the shortcut to paste, and is one of the best known shortcuts in Excel. I suppose you already know it. But do you still use the right click menu to ‘paste special’?
Did you know there is a shortcut for this too - Ctrl + Alt + V will show the paste special menu.
A function I've found super useful this week -
Another numerical function I often find useful is to know if a number, or output of a function is odd or even. You can do this using the ISODD and ISEVEN.
Each function only has one element - the cell or number you wish to check, and the output will be a TRUE or FALSE value.
You could then combine this with an IF function to create different outcomes based on if the value is odd or even.
Hope these were useful, until next time all the best.