- Advanced Excel Tutorial
- Advanced Excel - Home
- Excel New Features
- Excel - Chart Recommendations
- Advanced Excel - Format Charts
- Advanced Excel - Chart Design
- Advanced Excel - Richer Data Labels
- Advanced Excel - Leader Lines
- Advanced Excel - New Functions
- Fundamental Data Analysis
- Excel - Instant Data Analysis
- Excel - Sorting Data by Color
- Advanced Excel - Slicers
- Advanced Excel - Flash Fill
- Powerful Data Analysis
- Excel - PivotTable Recommendations
- Powerful Data Analysis – 1
- Advanced Excel - Data Model
- Advanced Excel - Power Pivot
- Excel - External Data Connection
- Advanced Excel - Pivot Table Tools
- Powerful Data Analysis – 2
- Advanced Excel - Power View
- Advanced Excel - Visualizations
- Advanced Excel - Pie Charts
- Advanced Excel - Additional Features
- Advanced Excel - Power View Services
- Advanced Excel - Format Reports
- Advanced Excel - Handling Integers
- Other Features
- Advanced Excel - Templates
- Advanced Excel - Inquire
- Advanced Excel - Workbook Analysis
- Advanced Excel - Manage Passwords
- Advanced Excel - File Formats
- Excel - Discontinued Features
- Advanced Excel Useful Resources
- Advanced Excel - Quick Guide
- Advanced Excel - Useful Resources
- Advanced Excel - Discussion
Advanced Excel - Slicers
Slicers were introduced in Excel 2010 to filter the data of pivot table. In Excel 2013, you can create Slicers to filter your table data also.
A Slicer is useful because it clearly indicates what data is shown in your table after you filter your data.
Step 1 − Click in the Table. TABLE TOOLS tab appears on the ribbon.
Step 2 − Click on DESIGN. The options for DESIGN appear on the ribbon.
Step 3 − Click on Insert Slicer. A Insert Slicers dialog box appears.
Step 4 − Check the boxes for which you want the slicers. Click on Genre.
Step 5 − Click OK.
The slicer appears. Slicer tools appear on the ribbon. Clicking the OPTIONS button, provides various Slicer Options.
Step 6 − In the slicer, click the items you want to display in your table. To choose more than one item, hold down CTRL, and then pick the items you want to show.
To Continue Learning Please Login
Login with Google