Have you found this content useful? Use the button above to save it to your profile. Simon Hurst continues his KPI reporting casebook by incorporating some of the more advanced features available with ...

Have you found this content useful? Use the button above to save it to your profile. In the first part of this series we looked at how some of the changes in Excel 2010 and 2013 have given us new ...

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 free Excel tutorials. Bill "MrExcel" Jelen is the author of 67 books about ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. Once you select the portion of your spreadsheet that contains the target data, then define it as a ...

How to convert a Microsoft Excel slicer into a series of filtering buttons on a PivotChart Your email has been sent PivotCharts and slicers go together like peanut butter and jelly — the slicer ...

Slicers provide an intuitive, user-friendly interface for filtering data in a spreadsheet. Here’s how to create slicers, format them, and use them to filter data in Excel. Spreadsheets’ greatest ...

Get traffic data and keyword intel on competitors instantly. Wrapping up my series on dashboards, I want to address an issue I see in just about every spreadsheet I’ve seen in my career as a marketer: ...

How to display the top n records in an Excel PivotTable using built-in options Your email has been sent In a previous TechRepublic article, How to highlight the top n values in a Microsoft Excel sheet ...