How to Filter Excel Data Using Slicers

PivotTables and PivotCharts are fantastic Excel features that allow you to analyze data. Sometimes you need an easy way to manipulate only specific data and view it. This Trainer Tip will show you how to filter data in PivotTables and PivotCharts using Slicers. Though...

What is an Excel PivotTable?

Sharing the Wonder of Excel PivotTables! The PivotTable is a powerful tool for summarizing, analyzing, exploring and presenting data, extracted from larger amounts of data elsewhere in your workbook. It enables you to query the data in user-friendly ways, subtotal and...

Get a Handle on Excel AutoFill!

Use AutoFill to fill in data…With the AutoFill feature, you can have Excel automatically continue a series of numbers, number and text combinations, dates, or formulas, based on a pattern that you establish. Select the first cell in the range that you want to...

Here’s a few of our favorite Excel tips…

Learn some new tricks in Microsoft Excel! To summarize your Excel data without using formulas: Sort the data by what you would like to subtotal Go to the Data tab On the right of the ribbon, click Subtotal in the Outline group. Choose the field you’d like to...