Back in 2016 I wrote the following blog post about changes to the way Excel 365 generated MDX queries for PivotTables connected to Analysis Services, Power Pivot/the ...

The automation of repetitive tasks has become part of today’s workplace, whether CPAs are engaged in industry, governmental, not-forprofit, or public accounting. This automation can consist of ...

If you want to be a true spreadsheet power user, you need to learn about the Power Query and Power Pivot features in Excel. While you can get a lot done with Excel alone, using these built-in “Power” ...

If you’ve ever found yourself wrestling with Excel’s traditional Pivot Tables, you know the frustration of hitting their limitations. They’re great for basic tasks but can leave you scratching your ...

Consider the following hypothetical scenario: You have some PivotTables in a Microsoft Excel workbook that rely upon an underlying set of data. That dataset gets ...

Liam Bastick looks at the new PivotTable enhancements and updates in Office 2019. PivotTables were enhanced beyond recognition with the advent of Excel 2010 and Excel 2013, and the introduction of ...

Whether you're applying for a role that requires Excel expertise, want to add more strings to your data analysis bow, or simply want to do more with your data in Microsoft's spreadsheet program, add ...