As the weather gets warmer and we all start to feel antsy from being inside while it is so nice out, we are striving to get our work done faster. Instead of rushing through and making mistakes, below are some Excel tips and tricks on how to make yourself more efficient in getting your work done.
One of the biggest timesavers is getting to know your keyboard.
CTRL + P = Print
CTRL + C = Copy
CTRL + X = Cut
CTRL + V = Paste
CTRL + Z = Undo
CTRL + Y = Redo
CTRL + Q = Quit *
* This works on multiple PDFs, much more useful than trying to find all the little X’s in the upper right-hand corner
Making an effort to use those shortcuts instead of lifting your hand to your mouse and then back to your keyboard will save you hours in the long run.
Another timesaver favorite is when you want to enter the same information in cells that are not connected. Hold CTRL while you are clicking on the cells that you would like to alter. Once you have those cells highlighted, you can type normally and then once you are ready to enter the information, hold CTRL down and hit enter.
Another way to save time is to use formulas. Contrary to what many might think, formulas do not only have to be used for numeric information. You can easily use a formula to calculate the number of days between two dates, which is very useful for interest calculations.
Further, if you only wanted to calculate the weekdays in between two dates, you can use the formula ”NETWORKDAYS” and then select the two dates you want to calculate between, which can be helpful for HR or administrative functions.
These Excel shortcuts are often overlooked but once you get the hang of them, you won’t remember why you were so attached to your mouse.