Often I find myself writing a sum formula in MS Excel. It's not difficult and with Excel's Formula AutoComplete it really is simple to do, but today I have a technique that can improve our efficiency when it comes to this particular formula.
MS Excel: The Quick Way to Turn Formula AutoComplete On or Off
Learn to turn Excel's Formula AutoComplete feature on or off without going all the way into the programs options.
MS Excel: The F6 Key – Worksheet, Ribbon, Zoom, Worksheet, Ribbon, Zoom
Reach virtually any command in MS Excel with this incredibly quick keyboard shortcut!
MS Excel: Insert and Paste In One Step
Here's a super-helpful MS Excel tip that will teach you the painless way to insert and paste rows and columns.
MS Excel: Text to Numbers in Just 2 Clicks
Unfortunately it happens way too often - we receive a worksheet containing numbers but the cells were formatted as text. Too bad we need them as numbers! Thankfully, there's a quick and easy solution!
MS Excel: Print One Sheet, All Sheets or Maybe Just Some Sheets
Be default, when we tell Excel to print we end up with whatever worksheet is currently selected spitting out of the printer. Usually that's great since it's exactly what we want most of the time... but what about the other times? You know, when you wanted the entire workbook or even multiple worksheets, but not all of them? Learn how to remedy this problem by reading this tip!