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.

Learn how to create and and forms to Excel spreadsheets to help make data entry easier. This guide makes it easy to create Excel forms for ...

Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Why You Should Add a Table of Contents to Excel What would you do if you had hundreds of sheets in an Excel workbook and needed to find a specific one for updating or modifying data? Searching ...

Here are my top 10 secrets for managing lists of data using Excel Tables. 1. Create a Table in Any of Several Ways You can create a table from the Insert tab or (as here) from the Home tab, where ...

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.

Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.

While Access 2003 and 2002 include a wizard for importing data from an Excel file into an Access table, you may want to create a command button that will perform all of the steps of the wizard for ...