Administration and Executive AssistantTier 330 minintermediate

Slicers and Timelines

Give readers buttons to filter a report without touching the data.

What you will learn

• Insert a slicer and connect it to one or more PivotTables
• Add a timeline for date filtering
• Explain what a filtered report is and is not showing
• Clear filters before sharing a report

Excel skills

Slicers, Timelines, Report Connections · Interactive Filtering

The quiz

5 scenario-based questions, each with an explanation once you answer.

Try this lesson free