Join 400,000+ professionals in our courses here https://link.xelplus.com/yt-d-all-courses

This type of interactive chart is great for impressive dashboards. Quickly learn how to create an Excel Pivot chart that's driven by pivot slicers.

⬇️ Download the workbook here: https://pages.xelplus.com/weekday-slicer-file

What You'll Learn:
- Excel's Weekday Function: Understand how to use the Weekday function to identify weekdays corresponding to specific dates.
- Creating Pivot Charts: Learn the process of transforming raw data into meaningful pivot charts.
- Adding Slicers for Interactivity: Discover how to incorporate slicers for a dynamic data exploration experience.

In This Tutorial:
- Data Preparation: Starting with a stock price dataset, we use the Weekday function to assign weekdays to dates.
- Custom Formatting: Convert weekday numbers to names using Excel's custom formatting features.
- Pivot Table Insights: Convert your data into a pivot table and then into a pivot chart for a visual representation of weekdays vs. average closing prices.
- Slicer Integration: Enhance your pivot chart with slicers to filter data by specific months or criteria.
- Design Tips: Get insights into adjusting chart styles and slicer formats for a professional look.
- Data Expansion: See how easily you can update your charts by adding new data to your Excel table.

Pro Tips:
- Use the Weekday function for more than just identifying days; use it to discover trends and patterns.
- Leverage pivot charts and slicers to make your data presentations more interactive and informative.

In this example I cover two topics:
1. How to get Weekday name from a given date in Excel
2. How to create a Pivot Chart controlled by a Slicer

In addition I show you how you can customize slicers in Excel to better match your report layout.

️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join

Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

RESOURCES I recommend: https://www.xelplus.com/resources/

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel