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.

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

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.

Microsoft Excel's form controls let you add buttons to your spreadsheet to perform functions. For example, if a spreadsheet invites coworkers to enter sales predictions, they might press a 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 ...

In this tutorial, we will explain the steps to view a Properties dialog box in Excel. How to display Document Properties in Excel from Info settings Click the File tab on the ribbon.

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.