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

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

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.

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.

Excel Online supports sorting by multiple columns. How to sort by two columns Grouping is a common database task, and sorting by multiple columns is essentially the same thing.

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

The Data Analysis for Excel Video Series is designed to supplement Lesson 3 in the AQ-IQ curriculum. Learn about units of Air Quality PollutantsAQ-IQ Mentor Elise Mesenbring explains the concentration ...

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

How to Put Two Sets of Data on One Graph in Excel. One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as ...