A slicer will be created for every field that you selected. Clicking any of the slicer buttons will automatically apply that filter to the linked table or PivotTable.

Much like a slicer for filtering data, you can insert a Timeline one time, and then keep it with your PivotTable to change the range of time whenever you like. Here’s how:

Filters and slicers are controls that enable you to focus on the data that you are most interested in viewing. For example, a time filter enables you to view information for a specific unit of time.

Choose the fields you want to create slicers for, and select OK. Excel will place one slicer for each selection you made onto the worksheet, but it's up to you to arrange and size them however is …

Slicers and Timelines allow you to quickly filter your PivotTables and PivotCharts so you can see just the information that's meaningful to you. Select any PivotTable and go to PivotTable …

Use member_expression as a slicer to define the portion of the cube for which the aggregated value is returned. If no measure is specified in member_expression, the default measure for …

PivotTable on iPad is gradually rolling out to customers running Excel on iPad version 2.80.1203.0 and above. In a PivotTable, press and hold an item you want to Expand or Collapse.

How to use a PivotTable in Excel to calculate, summarize, and analyze your worksheet data to see hidden patterns and trends.

If an item contains a date, the value must be expressed as a serial number or populated by using the DATE function so that the value will be retained if the worksheet is opened in a different …

Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or the top 10 students.