How to create pivot table + slicer in Excel

Jyggalag

New Member
Joined
Mar 8, 2021
Messages
39
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hello everybody!

It's nice to be back on the MrExcel forum :)

I am currently managing a list that essentially looks like this (just a lot bigger):

1615211377950.png


I would like to create a pivot table and a slicer for this (the real file is over 1000 cells) so it becomes much easier to look up specific cases!

Does anybody have some nice experience with this? I have never ever in my entire life created a pivot table or a slicer in Excel before, but I have been told that it's a nice way to create an easy overview of your data :)

Any assistance would be greatly appreciated!!

Thank you everybody :)

Best regards,
Jyggalag
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

arthurbr

Well-known Member
Joined
Dec 8, 2006
Messages
2,219
Office Version
  1. 2010
There are lots of examples on YouTube
 

Jyggalag

New Member
Joined
Mar 8, 2021
Messages
39
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
There are lots of examples on YouTube
I tried looking online and on youtube as well.

They make it seem very simply. Just go to insert --> slicer and boom you got it.

However, when I do that I get this error :(
1615213463768.png
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,696
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You need to create the pivot table first, then the slicer.
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,129,479
Messages
5,636,574
Members
416,925
Latest member
malamutus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top