Become more proficient with these short tips

- We're looking at a worksheet called "TinyTips,"…and on the left-hand side in Column A,…you'll see a list of the tips we're gonna be discussing.…Now, many of these I've used…in different movies in this course.…Overall they'll make you a more efficient user of Excel.…Let's start with the first one,…"Press 'Control + Return' to complete a cell entry…"and keep the active cell in place."…I'm about to write a formula in cell "D2."…"=,"…the salary that's in "C2,"…times "%" and "E1,"…I want that to be an absolute address,…so I'll press "Command + T,"…and then I'll finish the formula…by putting in a "+" and clicking on cell "C2."…I don't want to press "Return" because…that moves the active cell downward,…I simply will press "Control + Return."…It keeps the active cell in place.…

I'm ready to copy this now.…Don't have to re-position the cell.…I'll double-click the lower-right hand corner,…and another tip, press "Control + ." just to make sure…we know this got copied as far…as we would have wanted it to be copied.…"Control + ." moves the active cell…