Slicers | Using Slicers to build an Interactive Report

Slicers | Using Slicers to build an Interactive Report

You can download the workbook here to follow along with the Video!

In this video, I show you how you can use slicers to build an Interactive report in Excel in combination with a Pivot Chart.

I also show you how you can slice and dice your data by WeekDay, and MonthName by creating calculated columns that contain the MonthName and WeekDay, and this would work on any Excel version!

I also show you a feature in Excel 2016 and Office 365, which is that Excel automatically groups the dates into MonthNames.

So make sure to watch the video to learn these tricks!

I hope you like that Tutorial.

Please watch the video and let me know if you have any comments or feedback in the comments section below.

Please share

If you like this post, don’t forget to Share it with your friends on different social media platforms using the share buttons!

Ace your Excel Career by learning how to create Excel Dashboards!

Learn Step by Step how to create Professional, Interactive Dashboards & Charts using Excel including:

1- Learning the Important functions that you need to know for building Dashboards such as VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET and others

2-Learning how to implement Interactivity tools such as Form Controls, Slicers, and others.

3-Learning Dashboarding techniques.

4- Building a Complete Excel Dashboard.

Click here Find out more

Check course contents!