The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Ben Richardson is the director of Acuity Training, one of the UK’s leading providers of classroom-based Excel training. Microsoft Excel allows you to clean and explore data, as well as add advanced ...

Please note: This item is from our archives and was published in 2018. It is provided for historical reference. The content may be out of date and links may no longer function. Because the field names ...

Q. I usually like Excel PivotTables, but because they don’t allow me to do certain things, such as delete cells or insert new columns or rows, I’m wondering if there is a reasonable alternative? A.

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

The first thing you’ll see when you open Excel is a brand new look. It’s cleaner, but it’s also designed to help you get professional-looking results quickly. You’ll find many new features that let ...

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

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