I usually prefer writing my own logic in Excel, so I was hesitant to start using the Formula by Example tool. But when it turned my manual patterns into a perfectly structured formula, it became the ...

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

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