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

Custom formulas let you dictate exactly what goes into cells.

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 ...

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

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 ...

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 ...

The open source community has created many open source Java projects, which range from charting software to game frameworks to word processors. In this post, I introduce an open source library project ...