How-To Geek on MSN

7 Excel tricks that are offensively simple (but surprisingly effective)

From secret shortcuts to clever formatting tricks, these Excel hacks will make you wonder why nobody mentioned them sooner.
How-To Geek on MSN

Your Excel workbook has a game-changing productivity tool you've probably never used

Use Excel's overlooked Name Box to jump between worksheets, select huge ranges, create named ranges, and organize even the ...
note

Automating Outlier Detection with Excel Conditional Formatting: 3 Steps to Reduce Expense Digit Errors from 8 to 0 per Month Using AVERAGE and STDEV.P

No one could stop the "132,000 yen travel expense" Three years ago, I was helping a client with accounting outsourcing. A "Travel Expense: 132,000 yen" entry had slipped into the end-of-month expense ...
note

Table where rows turn red 3 days before the deadline | 4 types of deadline alerts created with conditional formatting

I hear this phrase a few times a year. Not as the person being told, but as the person saying it. Nice to meet you, I am Roki, a tax accountant. I am a practicing tax accountant. I spend my days ...