Essential to Expert Skills progression

Excel tutorials

The only Excel books you will ever need

  • The only constantly updated Excel 365 titles more…
  • Thoroughly covers Power Pivot and Power Query more…
  • Covers business intelligence and OLAP features more…
  • Simple, easy, understandable, 2-page lessons more…
  • Available as both printed books and e-Books more…
  • Used by schools, colleges and universities  more…
  • Available for 365, 2019, 2016 and Mac versions more…

Category: Pivot tables

Search again:

Refreshing slicers in Excel

Refreshing Slicers in Excel

This article explains how to change Excel’s Slicer settings to stop displaying items that have been deleted from the data source.

Missing field list in Pivot table

Missing Field List – Pivot Table

This article explains how to bring back the Pivot Table Field List if it has been closed or moved and explains a bug that can prevent it from appearing.