From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Become a more proficient Excel user with these short tips

Become a more proficient Excel user with these short tips

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Become a more proficient Excel user with these short tips

“

- [Voiceover] The Chapter 13 file contains one worksheet called Quick Tips and down the left-hand side we see 10 short, we might call them tiny tips, and I'll cover them in order. Press Ctrl + Enter to keep the active cell in place. I'm about to write a formula in C2 and when I finish the formula, if I press Enter, the active cell will move into C3, but I want to copy the formula down the column. So here's the formula. Everybody's going to get a salary increase here of 2.1%. So I'll be using cell D1 in the calculation. I'll start using cell B1 for the first formula. = B1 x D1 I want that to be an absolute address so I'll press the function key F4 and then + B2 but I won't press Enter. I'll press Ctrl + Enter. I want the active cell to stay in place. Then I can copy it down the column quickly, double click. I'll come back to the format in a bit. Now second tip, don't capitalize function names as you type them. Equal, I want a median of those values. I don't have to capitalize the word…

Contents