Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more.

Learn simple Excel design tips to make your spreadsheets look professional and organized. Improve readability with color, fonts, and layouts. Most Excel users would agree the program is a godsend when ...

Excel is pretty smart about how it handles updates. It builds a dependency tree, essentially a map of which cells rely on others, and uses it to recalculate only the cells that need updating. When you ...

I have a background that includes spreadsheets, programming, and electronics, so this book piqued my interest. I didn't run into any surprises until I thought a bit more about its contents and my ...

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

If you manage data in multiple Excel spreadsheets, you can use the Consolidate Data wizard to merge data from several spreadsheets or workbooks into one master sheet. The Consolidate Data wizard ...