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 ...

Learn how to calculate and display variance inside Excel pivot tables. Perfect for financial analysis, reporting, and data ...

How to show details in a grouped PivotTable in Microsoft Excel Your email has been sent Microsoft Excel PivotTables turn data into useful information the same as other reporting tools. Most reports ...

How to display multiple subtotal rows in a Microsoft Excel PivotTable Your email has been sent Microsoft Excel PivotTables are a great way to summarize data. They’re easy to create and display ...

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 ...

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: using Excel’s (hideous) default formatting for ...