News

What is SaveToDB add-in? For those unfamiliar, SaveToDB is a powerful and user-friendly add-in for Microsoft Excel that unlocks essential database features right in your spreadsheet program.
Not everyone is familiar with Excel. You can protect the data input process by using Excel's UserForm object to collect data. Susan Harkins explains how.
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 ...
Open the Excel 2010 spreadsheet where you want to add your tooltip. Select the cell you want to alter, then click the "Data" tab at the top of the screen. Click the "Data Validation" button ...
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 ...
It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp.
Is there a way to display all the underlying formulas in an Excel spreadsheet? Sure. The convenient way (that allows you to toggle back and forth between formulas and results) is to press Ctrl+~ (the ...