It’s amazing how passionate some people can be about zeroes. I have known people who hate, with a passion, to see zeroes displayed in their reports. They will sometimes use some formula acrobatics to avoid having a zero displayed.
Monthly Archives: January 2013
Getting dragging right in Excel
Tricks of the trade
Ever tried using your right mouse button to click, hold and drag things around in Excel? You might be pleasantly surprised with the results.
Excel’s shorthand shortcut
Save typing
Excel has a feature that can save you a lot of typing, it’s called AutoCorrect. Yes it’s the same system that fixes your spelling mistakes. Well did you know it has two handy features?
Using Excel’s IF function differently
A Shorter IF
The IF function is typically used to display one result or text when a condition is met and another if it is not met. There is another technique using the IF function that can reduce formula size in certain circumstances.
Right Clicking in Excel
Shortcuts to save time
Right clicking in Excel offers many productivity benefits. If you don’t already right click try it, it’s fun to see all the options that are just a click away.