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

Master the art of dashboard customization in Excel with this engaging and informative tutorial. Ideal for HR professionals, data analysts, or anyone looking to enhance their Excel reports, this video guides you through creating visually appealing slicers using symbols.

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

Here's what you'll learn:
Dataset and Pivot Table Creation: Starting with an HR dataset, you'll see how to create a pivot table to analyze average salaries by cost center, sex, and full-time equivalent (FTE) status.

Transforming Tables and Slicers: Learn to convert a standard Excel table into an official one for dynamic pivot table updates. Plus, get insights into creating and formatting standard slicers.

Inserting Symbols in Data Source: Discover how to add unique character codes and symbols directly into your data source for a more intuitive slicer design.

Creating Custom Slicers with Symbols: Watch step-by-step as we replace traditional text slicers with symbol slicers, enhancing the dashboard's visual appeal and user-friendliness.

Fine-tuning Slicer Appearance: Learn how to adjust slicer settings for size, header display, and design, including creating a custom slicer with no borders.

Practical Examples: See how these techniques are applied in real-time to analyze different combinations, such as the average salary for male and female full-time or part-time workers.

My Online Excel Courses ► https://www.xelplus.com/courses/

️ 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