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 68 results
Simon Hurst
Exclusive This month’s highlights
  • Article
  • 18 Sep 2025
  • Simon Hurst
Perhaps every month you wonder how sales have gone compared to the same month last year. This post demonstrates one way of automatically highlighting the comparison using conditional formatting. Also, just because we can, we’ve used an example based on a PivotTable to demonstrate the technique.
hands raised image
Exclusive Power BI Tips & Tricks Live: your questions answered
  • Webinar
  • 16 May 2025
  • Excel Community
Attend this webinar to gain a better understanding of using Power BI and its applications in accounting.
Is this the end of Pivot Tables
  • Webinar
  • 21 Mar 2025
  • PDF (1,340kb)
  • ICAEW Excel Community
This webinar will explore the basics of Pivot Tables before diving into new and alternative functionality that can also be used to analyse and work with data in Excel.
graph image
Exclusive Is this the end of Pivot Tables?
  • Webinar
  • 21 Mar 2025
  • Excel Community
This webinar will explore the basics of Pivot Tables before diving into new and alternative functionality that can also be used to analyse and work with data in Excel.
meeting on laptop
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.
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.
Lego graph image
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 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.
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
EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #388 - Power Pivot: Filtering measures
  • Article
  • 06 Apr 2021
  • David Lyford-Smith
Hello all and welcome back to the Excel Tip of the Week! This week we have a Developer post in which we’re taking a look at a common request for PivotTables – a way to easily switch between different ways of summarising the data.
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #386 - Power Pivot: RELATEDTABLE
  • Article
  • 23 Mar 2021
  • David Lyford-Smith
This week, we have a Developer level post in which we are returning to Power Pivot for a look at how to use a clever trick to expand the range of measures you can calculate. For a refresher on measures, check out TOTW #369.
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK Excel Tip of the Week #369 - Power Pivot: Measures
  • Article
  • 24 Nov 2020
  • David Lyford-Smith
The second part of our two-part examination of the wonders of Power Pivot.
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK Excel Tip of the Week #368 - Power Pivot: Connections
  • Article
  • 17 Nov 2020
  • David Lyford-Smith
This week we have a Creator level post in which we are starting a short series introducing you to the essentials of Power Pivot. This is a follow-up to our recent webinar on the topic.
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK Excel Tip of the Week #367 - PivotCharts
  • Article
  • 10 Nov 2020
  • David Lyford-Smith
This week, David Lyford-Smith looks at how to extend a basic PivotTable with PivotCharts.
Exclusive Super charge your PivotTables with Power Pivot
  • Webinar
  • 02 Nov 2020
  • Excel Community
Power Pivot is freely available in Excel, but is often overlooked. But the powerful add-in can supercharge your PivotTables, allowing more nuanced and detailed calculations and summaries than ever before.
Modelling 101: Part 62 - Searching Slicers
  • Article
  • 31 Jul 2020
  • Liam Bastick
First appearing in Excel 2013, slicers are a visual filter that can be used to interact with PivotTables, PivotCharts or Tables. They are very popular with end users as they are highly intuitive requiring little more than a quick point and click. The problem was that although are great for selecting one or more elements to filter, if there are many records to scroll through, searching is cumbersome. There appears to be no search facility.
Displaying 1-20 of 68 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