ICAEW.com works better with JavaScript enabled.

Pivot-tables

View a list of articles and webinars produced by the Excel Community on pivot-tables.

Displaying 1-20 of 77 results
David Beniam
Excel’s GROUPBY & PIVOTBY functions vs PivotTables
  • Article
  • 29 Nov 2024
  • David Benaim
One of Excel’s most significant updates this decade is without a doubt the new GROUPBY and PIVOTBY functions, these can replicate PivotTables functionality through formulas, so here I will compare and contrast both methods whilst providing possibly the most complete guide on the internet currently of GROUPBY.
David Beniam
Excel’s GROUPBY and PIVOTBY functions vs PivotTables
  • Article
  • 29 Nov 2024
  • David Benaim
One of Excel’s most significant updates this decade is without a doubt the new GROUPBY and PIVOTBY functions, these can replicate PivotTables functionality through formulas, so here I will compare and contrast both methods whilst providing possibly the most complete guide on the internet currently of GROUPBY.
Lego graph image
Exclusive Power Tools Part 4: Build dynamic dashboards with Power Pivot
  • Webinar
  • 04 Mar 2024
  • ICAEW
This webinar explores the fundamentals of Power Pivot and how to best use this functionality in Excel to structure and analyse data, based on real-life examples accounting and finance professionals will encounter.
Liam Bastick
Excel's new functions might change data analysis forever
  • Article
  • 29 Feb 2024
  • Liam Bastick
Excitement is building, as a range of new functions introduced by Microsoft towards the end of last year are – hopefully – edging closer to general release. Here, Microsoft MVP Liam Bastick explores how they work and what they might mean for you.
Liam Bastick
Exclusive Formatting Slicers
  • Article
  • 30 Aug 2023
  • Liam Bastick
In earlier versions of Microsoft Excel, you can use report filters to filter data in a PivotTable report, but it is not easy to see the current filtering state when you filter on multiple items. In Microsoft Excel 2010 and later versions (that is, from when Slicers were introduced), you have the option to use Slicers to filter the data
Simon Hurst
Exclusive Coming soon: graphic details in PivotTables
  • Article
  • 24 Jul 2023
  • Simon Hurst
An imminent Excel enhancement will allow you to include Data Types and images in your PivotTables. Is this your chance to build PivotTables containing employee photos and product pictures?
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #472 – Conditional formatting components
  • Article
  • 18 May 2023
  • Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post where we explore how to use different components of conditional formatting including data bars, colour scales and icon sets.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #471 – Refreshing GETPIVOTDATA
  • Article
  • 12 May 2023
  • Bani Lamba
A Creator level post where we’re refreshing our coverage of the PivotTable extraction function GETPIVOTDATA
Simon Hurst
Exclusive TECH NEWS Excel fundamentals training – what should be included?
  • Article
  • 04 May 2023
  • Simon Hurst
Should basic Excel training stick to simple formulas and functions or should it extend the horizons of learners to consider the likes of Dynamic Arrays, PivotTables and Power Query?
Simon Hurst
Exclusive Not dead yet? Do Dynamic Arrays mean the end of PivotTables?
  • Article
  • 16 Feb 2023
  • Simon Hurst
Several Excel commentators have questioned the future of PivotTables in the new era of Dynamic Arrays. Simon Hurst gives his personal and intemperate views on the subject
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #439 - Power Pivot - Creating a running total
  • Article
  • 29 Mar 2022
  • David Lyford-Tilley
Hello all and welcome back to the Excel Tip of the Week! This week we have a Developer level post in which we’re going to look at how to make some more unusual types of measures in Power Pivot. If you want a refresher on how Power Pivot measures work, check out TOTW #369 for the lowdown.
David Lyford-Smith
Exclusive Power Pivot management reporting - your questions answered!
  • Article
  • 24 Mar 2022
  • David Lyford-Tilley
This blog post accompanies our recent webinar, Power Pivot: Management reporting. In this post I will go through all the questions we received during the live session – including the ones we didn’t have time for on the day – and answer every single one.
Exclusive Power Pivot for management reports
  • Webinar
  • 22 Mar 2022
  • Excel Community
“Excel Tip of the Week” author David Lyford-Tilley takes us on a deep dive into how the powerful and flexible Power Pivot add-in can be used to connect datasets together to make simpler management reporting dashboards.
David Lyford-Smith
Exclusive TECH NEWS Comprehensive guide to PivotTables: your questions answered
  • Article
  • 23 Feb 2022
  • David Lyford-Tilley
We recently held our latest Excel Community webinar, an updated version of “The comprehensive guide to PivotTables.” in this blog we take you through all the questions we received on the day.
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #434 - Revisiting making sets of PivotTables
  • Article
  • 22 Feb 2022
  • David Lyford-Tilley
Hello all and welcome back to the Excel Tip of the Week! This week, we have a Creator level post in which we’re taking a second look at a handy but very hidden feature of PivotTables. This is an update of the original from TOTW #291.
Lego graph image
Exclusive A comprehensive guide to PivotTables (2022 webinar)
  • Webinar
  • 21 Feb 2022
  • Excel Community
Join David Lyford-Tilley as he walks you through everything you need to know about summarising and condensing your data using Excel’s famous PivotTables.
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #416 - PivotTable layouts
  • Article
  • 19 Oct 2021
  • David Lyford-Tilley
This week, we have Creator post in which we’re taking a look at some options for how to lay out your PivotTables.
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #406 - Power Pivot: Filtering active contracts
  • Article
  • 10 Aug 2021
  • David Lyford-Smith
This week, we have a Creator level post in which we’re going to look at how to use Power Pivot to filter or calculate on a list of active contracts, when given just the start and end dates. This same approach can of course be applied to any data with start and end dates – be it employment terms, contracts, or more specific applications like hotel stays or population tracking.
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK Excel Tip of the Week #399 Power pivot - KPIs
  • Article
  • 17 Jun 2021
  • David Lyford Smith
Hello all and welcome back to the Excel Tip of the Week! This week we have a Creator post in which we are going to look at how to build visual KPIs into PivotTables created with Power Pivot.
David Lyford-Smith
TECH NEWS Live Q&A 4 – ALL your questions answered!
  • Article
  • 28 May 2021
  • David Lyford-Smith
Answers to all the Excel questions posed at our recent open Q&A webinar.
Displaying 1-20 of 77 results

Search the Excel Community archive

This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.

Search the archive Access the knowledge base
Excel polaroid