You can add and use Slicers to select items to filter a PivotTable in a more visual way. If you have Excel 2010, you can use the new Slicers tool to make your PivotTable even easier to work with.

In Excel 2013, if you want to add Slicer to your charts, select the data range and click on insert > Slicer. Now, select the part of the data you want to use as a filter.

In Microsoft Excel, you can use the Zoom features such as Zoom, 100%, and Zoom to selection to Zoom in and out of your spreadsheets. There is also a Zoom control slicer on the status bar that also ...