PivotTable Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/pivottable/ Bestselling Excel and Power BI Courses Tue, 03 Oct 2023 06:42:11 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png PivotTable Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/pivottable/ 32 32 You Won’t Believe These Excel PIVOT TABLE Hacks! https://www.xelplus.com/pivot-table-pro-tips/ Thu, 24 Aug 2023 15:21:37 +0000 https://www.xelplus.com/?p=17817 Discover 10 pro hacks that will make creating pivot tables easier. Learn how to customize layouts, create dynamic reports, conduct in-depth analysis.

The post You Won’t Believe These Excel PIVOT TABLE Hacks! appeared first on Xelplus - Leila Gharani.

]]> 4 Excel Settings to Review to be More Productive https://www.xelplus.com/excel-settings-to-change/ Thu, 25 Aug 2022 09:00:00 +0000 https://www.xelplus.com/?p=9064 Excel comes with default settings and options. You can change these to support your workflow and be more productive. This post covers my list of options to review.

The post 4 Excel Settings to Review to be More Productive appeared first on Xelplus - Leila Gharani.

]]> How to Properly Handle Dates in Excel Pivot Tables https://www.xelplus.com/pivottable-dates-grouping/ Thu, 19 May 2022 08:00:00 +0000 https://www.xelplus.com/?p=9286 Handling dates in Excel Pivot Tables can get tricky. How can you quickly ungroup the dates? Or get your own custom grouping for fiscal periods? How can you show all the dates including the ones with no values? This tutorial covers it all!

The post How to Properly Handle Dates in Excel Pivot Tables appeared first on Xelplus - Leila Gharani.

]]> DAX CALCULATE Function Made Easy to Understand https://www.xelplus.com/dax-calculate-function/ Thu, 09 Dec 2021 10:00:00 +0000 https://www.xelplus.com/?p=1491 If you'd like to "see" how the DAX CALCULATE function works, then you need this tutorial. It will show you how the CALCULATE function works and delivers results.

The post DAX CALCULATE Function Made Easy to Understand appeared first on Xelplus - Leila Gharani.

]]> 3 Hidden Tips for Excel Power Pivot https://www.xelplus.com/3-hidden-tips-for-power-pivot/ Tue, 30 Nov 2021 08:17:00 +0000 https://www.xelplus.com/?p=9707 These 3 hidden Excel Power Pivot tips will help you to: Copy your data model from one file to another, create a dedicated measures table and convert your pivot table data to formulas.

The post 3 Hidden Tips for Excel Power Pivot 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 Convert Multiple Rows to Columns (Transpose but with Multiple Values) https://www.xelplus.com/excel-switch-columns-multiple-values/ Thu, 29 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9917 Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.

The post Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) appeared first on Xelplus - Leila Gharani.

]]> How to Create a Pivot Table from Multiple Sheets in Excel https://www.xelplus.com/create-pivot-table-from-multiple-sheets/ Thu, 01 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9978 Easily create ONE Pivot Table in Excel from data in multiple sheets. Sometimes you need to "merge" the data and sometimes you have to "append" data from multiple sheets for your Pivot Table. Don't use formulas! Instead use this method.

The post How to Create a Pivot Table from Multiple Sheets in Excel 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.

]]> Best Excel Features for Accountants https://www.xelplus.com/top-excel-features-for-accountants/ Thu, 18 Mar 2021 08:18:00 +0000 https://www.xelplus.com/?p=10203 Learn the 10 most important Excel features for accountants. This list is not just for those that work in accounting but also anyone who uses Excel for data analysis. You'll discover new Excel tips and tricks that will make your working life a lot easier.

The post Best Excel Features for Accountants appeared first on Xelplus - Leila Gharani.

]]>