The one thing marketers agree on is there is not enough time in the day to accomplish everything. Often the best way to find more time is to save time.
Improving your excel skills is a great place to begin to claw back a few minutes on every project, because Excel is a tool used by most of us on a regular basis. It has so many incredible capabilities that are not immediately apparent. Just finding one trick can save you minutes every day.
Excel Tip No. 1: Automatically SUM() with ALT+=
Quickly add an entire column or row by clicking in the first empty cell in the column. Then enter ALT+'=' to add up the numbers in every cell above.
Excel Tip No. 2: Logic for number Formatting Keyboard Shortcuts
At times keyboard shortcuts seem random, but there is logic behind them. Let's break an example down. To format a number as a currency the shortcut is CTRL + Shift + 4.
Both the SHIFT and 4 keys seem random, but they are intentionally used because SHIFT + 4 is the dollar Sign($). Therefore if we want to format as a currency, It's simply: CTRL + '$'. The same is true for formatting a number as a percent.
Excel Tip No. 3: Display Formulas with CTRL +'
when you are troubleshooting misbehaving numbers first look at the formulas. Display the formula used in a cell by hitting just two keys: CTRL + ' (known as the acute accent key) - this key is furthest to the left on the row with the number keys. When shifted it is the tilde(~).
Excel Tip No. 4: Jump to the Start or End of a Column Keyboard Shortcut
You are thousands of rows deep into your data set and need to get to the first or last cell. Scrolling is OK but the quickest way is to use the keyboard shortcut CTRL + ↑ to jump to the top cell, or CTRL + ↓ to drop to the last cell before an empty cell.
When you combine this shortcut with the SHIFT key, you will select a continuous block of cells from your original starting point.
Excel Tip No. 5: Repeat a Formula to Multiple Cells
Never type out the same formula over and over in new cells again. This trick populates all of the cells in a column with the same formula, but adjusts to use the data specific to each row.
Create the formula you need in the first cell. Then move your cursor to the lower right corner of that cell and, When it turns into a plus sign, double click to copy that formula into the rest of the cells in that column. Each cell in the column will show the results of the formula using the data in that row.
Excel Tip No. 6: Add or Delete Columns Keyboard Shortcut
Managing Columns and rows in your spreadsheet is an all-day task. Whether adding or deleting, you can save a little time when you use this keyboard shortcut. CTRL+ '-' will delete the column your cursor is in and CTRL + SHIFT " '=' will add a new column. From and earlier tip, think about CTRL _ '+'.
0 comments:
Post a Comment