"Give it to me in Excel." There's a high probability that you've heard this phrase in school, at work, or from someone that needs data. Excel has made it tremendously easy to sift through data and make it more interpretable. The vast majority of users in the business world use Excel, so it pays to be well-versed in this powerful tool. During my time working in the finance industry, I found Excel invaluable, and I committed these tips to muscle memory. I learned that these shortcuts helped me save a tremendous amount of time.
So, let's jump right to it! Here are 4 Excel quick tips to help you navigate data faster.
Note: These keyboard shortcuts apply to Windows computers.
1. Moving to the last column or row in a dataset
- CTRL + Up arrow/down arrow/left arrow/right arrow
2. Navigating to other tabs in the workbook
- CTRL + Page up/Page down - Windows/full keyboard
- CTRL + fn + up arrow/down arrow - Windows/most laptops
3. Highlighting/selecting multiple cells
- SHIFT + arrows
4. Highlighting / selecting an entire row or column
- SHIFT + space bar: highlight entire row
- CTRL + space bar: highlight entire column
Here's my challenge to you: as you go through your next dataset, try resisting the urge to use your mouse (or mousepad) when you have to perform any of the actions above. Keep using these keyboard shortcuts until it becomes second nature. Once you master these shortcuts, you can combine them with other keyboard shortcuts to perform commands in seconds! Save seconds, save time, and navigate data faster!E
Enrique graduated with a BS in Finance and Statistics from New York University's Stern School of Business and earned his MBA from Columbia Business School, graduating with Dean's Honors with Distinction. Enrique has been running a data analytics consulting startup out of the Columbia Startup Lab Incubator since he completed his MBA.
Enrique has years of experience tutoring MBA students in various subjects including accounting, statistics, business, and Excel. He is a CFA Charterholder, so he is comfortable in helping with anything finance related as well.
Interested in learning more quick tips and tricks to help you with your studies and/or work? Check out some of our previous blog posts below: