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.

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

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

Microsoft Excel offers several tools you can use when you need to fill a column with the same text or numbers. Instead of completing each cell manually, you can quickly fill in the entire column ...

Learn how to parse data in Microsoft Excel easily using our step-by-step guide.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

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

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.