Updated: Mar 5, 2020
Tips and pointers you find online will never replace the value of a dedicated course for Excel. That being said, there are some simple shortcuts and functions that can make your life easier before you can come see us. Without further to do, here are Training to You's 10 Quick Excel Tips.
1. Navigate to the end of a data range or the next data range with Ctrl + Arrow
Excel shortcuts can help you become faster and more efficient. This shortcut is especially useful when there are many rows/columns to navigate.
2. Use Ctrl + Shift + Arrow keys to select multiple cells at the same time.
Expounding on the shortcut above, if you would like to highlight multiple cells the shift key is very useful.
3. Pivot Tables - Data Organization
When faced with a large data sheet, sometimes it is difficult to view just what you need. Pivot tables organize data in a table that is highly configurable. Excel gives you a lot of options on what you want to view. For example, I will show you how I will use a pivot table to show the average of Training to You's feedback on a scale from one to five.
4. Add Multiple Rows or Columns
You will most likely need to add rows or columns when working on spreadsheets. Sometimes you'll need to add numerous rows or columns at once in order to save time. In order to do this highlight the amount of rows you would like to insert and then add a new row like usual.
5. Use $ in Formula's to Keep the Formula the Same no Matter Where it's Copied.
A dollar sign ensures that the column and row remain the same even if you copy the same formula in adjacent rows. This creates and absolute formula that you can drag to other cells as shown below:
6. Double Click to Insert a Formula into Multiple Rows
Instead of dragging a formula down, you can double click the fill handle on the bottom right corner of the cell to apply the formula faster.
7. Use Shortcuts to Efficiently Format Values
Shortcuts make your life easier and the more you know the quicker you can manage your spreadsheets. Sometimes you will want to change values from a percentage, dollar amount, or decimal point. In order to format these values:
Percentage: ctrl + shift + %
Dollar: ctrl + shift + $
Decimal: ctrl + shift + !
8. Create Averages Quickly with =AVERAGE
=AVERAGE is a very common and useful formula for finding the average of a range of cells. If you are beginning to learn how to use formulas in Excel, this is a great place to start. For example, if I want the average of sales from the spreadsheet below, the formula is =AVERAGE(B2:B10).
9. Hyperlinks - Shortcut and Uses
Hyperlinks allow Excel users to link to websites, direct to emails, and link to other sheets on an excel file. This can be helpful in a reference section of a spreadsheet or just to be more efficient when working on multiple sheets at the same time.
10. Creating Charts
One of the best ways to express data is with charts. In presentations most people don't want to look at a grid to get the big picture on your data. Excel has many options when it comes to this and is very flexible with what you are able to do. Also, for creating graphs very quickly you can use the shortcut: alt + F1.
These are some quick tips to get you started with excel. Becoming competent at excel takes a lot of time, trial and error, and effort, but the payoff is definitely worth it. You can use excel in many ways in order to calculate massive amounts of data and to express that data in an digestible way.
If you are thinking about starting your journey with Microsoft Excel and you live in the Phoenix Arizona area, look no further than Training to You! We have highly qualified instructors that are equipped to instruct all levels of professionals. We help employees develop the skills they need to be effective in the workplace and beyond.