Custom formulas let you dictate exactly what goes into cells.

They may look harmless, but they're certainly capable of turning your spreadsheets into traffic jams.

When I do a presentation that includes spreadsheets, I usually use arrows to illustrate the relationship between numbers, and while it works OK, it lacks pizazz. Is there some way I can add more ...

Microsoft Excel spreadsheets hold more than a million rows of data and automate number crunching, but they can do so much more. Excel’s simple interface lends itself to uses well beyond those that its ...

Navigating through a complex Excel workbook or spreadsheet can be a real headache, especially when you’re dealing with multiple sheets and endless data. But what if there was a way to simplify this ...

Stop Excel errors by using these 8 key symbols, like ' to keep leading zeros and ~ to search for literal * or ? characters in data.