Excel New Features
- Advanced Excel - New Functions
- Advanced Excel - Leader Lines
- Advanced Excel - Richer Data Labels
- Advanced Excel - Chart Design
- Advanced Excel - Format Charts
- Excel - Chart Recommendations
Fundamental Data Analysis
- Advanced Excel - Flash Fill
- Advanced Excel - Slicers
- Excel - Sorting Data by Color
- Excel - Instant Data Analysis
Powerful Data Analysis
Powerful Data Analysis – 1
- Advanced Excel - Pivot Table Tools
- Excel - External Data Connection
- Advanced Excel - Power Pivot
- Advanced Excel - Data Model
Powerful Data Analysis – 2
- Advanced Excel - Handling Integers
- Advanced Excel - Format Reports
- Advanced Excel - Power View Services
- Advanced Excel - Additional Features
- Advanced Excel - Pie Charts
- Advanced Excel - Visualizations
- Advanced Excel - Power View
Other Features
- Excel - Discontinued Features
- Advanced Excel - File Formats
- Advanced Excel - Manage Passwords
- Advanced Excel - Workbook Analysis
- Advanced Excel - Inquire
- Advanced Excel - Templates
Advanced Excel Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Advanced Excel - Spcers
Spcers were introduced in Excel 2010 to filter the data of pivot table. In Excel 2013, you can create Spcers to filter your table data also.
A Spcer is useful because it clearly indicates what data is shown in your table after you filter your data.
Step 1 − Cpck in the Table. TABLE TOOLS tab appears on the ribbon.

Step 2 − Cpck on DESIGN. The options for DESIGN appear on the ribbon.
Step 3 − Cpck on Insert Spcer. A Insert Spcers dialog box appears.
Step 4 − Check the boxes for which you want the spcers. Cpck on Genre.
Step 5 − Cpck OK.

The spcer appears. Spcer tools appear on the ribbon. Cpcking the OPTIONS button, provides various Spcer Options.

Step 6 − In the spcer, cpck 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.
