Become a more proficient Excel user with these short tips

- [Instructor] This movie is called 10 Tiny Tips.…That's also the name of the worksheet that we're seeing…at the bottom of the screen.…These tips you might've seen, some of them in other movies.…They're designed to make your daily work with Excel…more efficient.…Tip number one, press Control Enter to keep the active cell…in place.…We're talking about the idea that when you're…entering data into a cell, and particularly…if you're going to be copying that,…could be a formula or text, or number.…But as I put this formula in cell C2,…after I do that, I want to be able to copy that formula…down the column.…I don't want the active cell to jump into cell C3.…

So as I type the formula here, it's equal B2…times D1, I want that to be an absolute address,…I'll press the function key F4.…And then plus B2, I will not press Enter,…I'll press Control Enter, the active cell will not move.…I do want to copy that down the column,…I'll double click the lower right hand corner.…Tip number two, don't capitalize function names…as you type them.…