Slicer Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/slicer/ Bestselling Excel and Power BI Courses Fri, 22 Dec 2023 17:39:48 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Slicer Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/slicer/ 32 32 How to Improve Data Analysis in Power BI with Slicers https://www.xelplus.com/power-bi-slicers/ Wed, 21 Dec 2022 10:42:00 +0000 https://www.xelplus.com/?p=8862 Power BI Slicers add interactivity to your reports. Managers love to slice and dice. But which Power BI slicers are available? Which should you choose? This tutorial will make you a master in Power BI slicers.

The post How to Improve Data Analysis in Power BI with Slicers appeared first on Xelplus - Leila Gharani.

]]> How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick https://www.xelplus.com/excel-interactive-dashboard-trick-dax/ Thu, 09 Sep 2021 08:43:00 +0000 https://www.xelplus.com/?p=9812 With Pivot Charts in Microsoft Excel, you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. You just need a tiny bit of DAX.

The post How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick appeared first on Xelplus - Leila Gharani.

]]> Excel Advanced Pivot Table Techniques for Serious Data Analysts https://www.xelplus.com/excel-advanced-pivot-tables/ Thu, 08 Apr 2021 08:00:00 +0000 https://www.xelplus.com/?p=10162 These 10 advanced Excel Pivot Table tips are going to help you analyze your data faster. PivotTables are one of Excel's most important tools. Not everyone knows these Pivot Table tricks though. Make sure you do!

The post Excel Advanced Pivot Table Techniques for Serious Data Analysts appeared first on Xelplus - Leila Gharani.

]]> Excel vs. Google Sheets – Is Excel Better? https://www.xelplus.com/excel-vs-google-sheets/ Thu, 01 Oct 2020 09:00:00 +0000 https://www.xelplus.com/?p=10646 These are 10 Excel features that are better than Google Sheets. This post is like a "top 10 tips and tricks" type of post. Even if you're currently using Excel, you might discover new tips you can use.

The post Excel vs. Google Sheets – Is Excel Better? appeared first on Xelplus - Leila Gharani.

]]> How to Create a Pivot Table in Excel https://www.xelplus.com/pivot-tables/ Sat, 20 Jun 2020 18:26:00 +0000 https://www.xelplus.com/?p=11288 Learn how to use Excel Pivot Tables to quickly summarize your data and create meaningful reports. In 10 minutes, we cover everything you need to know about Pivot Tables.

The post How to Create a Pivot Table in Excel appeared first on Xelplus - Leila Gharani.

]]> Excel – Use Symbols in Pivot Slicers https://www.xelplus.com/symbols-in-pivot-slicers/ Wed, 04 Oct 2017 06:46:00 +0000 https://www.xelplus.com/?p=11915 Learn how you can use symbols instead of text in your Pivot slicers to create visually effective Excel dashboard reports.

The post Excel – Use Symbols in Pivot Slicers appeared first on Xelplus - Leila Gharani.

]]> Excel Pivot Chart with Slicers https://www.xelplus.com/pivot-slicer-excel/ Thu, 13 Jul 2017 18:03:00 +0000 https://www.xelplus.com/?p=12179 In this tutorial you'll find out to how to use Pivot Slicers in Excel and create Slicers for months based on dates. You'll also learn how to create a dynamic Pivot Chart controlled by the slicer.

The post Excel Pivot Chart with Slicers appeared first on Xelplus - Leila Gharani.

]]>