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.

How to Disable Date Auto Fill in Excel. Microsoft Excel's Auto Fill features help you quickly enter the same value in more than one cell or fill a series of cells with related or sequential values.

To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

Microsoft Excel users, follow these two easy methods to reduce data entry time and errors when customized features aren't available.

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

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.