From simple lists to dynamic spill ranges and cascading menus, Excel drop-downs offer flexible control over data entry.

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

Quit the data-search struggle by organizing your raw data into a Microsoft Excel spreadsheet. Rather than manually scrolling through a list of disorganized records, use Excel's built-in tools to find ...

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

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...