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

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.

Go to the Data tab, click on Data Validation, and set your criteria. By following these tips and tricks, you can create custom templates in Excel that are not only efficient but also user-friendly.

How to Subset Data in Excel. Filters are used to create subsets of data in a Microsoft Excel worksheet. The "AutoFilter" or "Sort and Filter" function in Excel allows you to create views of data ...

How to Create a Graph in Excel & Make It Relative in Size. Microsoft Excel 2010 features a tool set that offers you the option of performing assorted functions on your data, including turning that ...

Are you constantly changing your Excel chart's data range as new information becomes available? Mary Ann Richardson shows how to set up the chart to automatically update as you add new rows of ...