In the first part of this Working with accounting data tutorial series we looked at ways to apply some of the new features in Excel 2010 and 2013 to management reporting situations. We showed how the ...

Excel tables could be linked into the PowerPivot data model as well as data from external sources and the PivotTable would be created from within the PowerPivot window. Excel 2013 still has the ...

This post is brought to you by Diego Oppenheimer a Program Manager on the Excel team. I am very happy to be writing this blog post today. Not just because I will be showing you another way Excel can ...

Excel 2016 introduces new and efficient capabilities. PivotTables, both native and data model based, now support automatic time grouping, and PivotCharts include drill-down buttons. Today we will walk ...