Excel Hack Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/excel-hack/ 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 Excel Hack Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/excel-hack/ 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.

]]> Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks) https://www.xelplus.com/excel-formula-hack-count-text/ Thu, 05 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11441 Check out this Excel formula hack to count text cells only. This mysterious syntax excludes blank cells, numbers and also cells with formulas that result in an empty string.

The post Use this Excel Trick to Only Count Cells with Text (Exclude Numbers and Blanks) appeared first on Xelplus - Leila Gharani.

]]> Excel Advanced Filter Trick https://www.xelplus.com/excel-advanced-filter-trick/ Thu, 14 Nov 2019 10:00:00 +0000 https://www.xelplus.com/?p=11782 Here is an Excel trick when using the Advanced Filter Feature in Excel. It's about copying a filtered result to another sheet. Did you know that you can copy the filtered results for the columns that you need, and you can ignore the columns that you don't need?

The post Excel Advanced Filter Trick appeared first on Xelplus - Leila Gharani.

]]> Excel Hack to Change Horizontal Data to Vertical https://www.xelplus.com/excel-horizontal-data-to-vertical/ Sat, 11 May 2019 20:40:00 +0000 https://www.xelplus.com/?p=12358 Here's an Excel Hack that shows an unusual but simple method to change horizontal data to vertical. The advantage of this hack is it's dynamic so if you add more values to the horizontal data it will reflect in the vertical one.

The post Excel Hack to Change Horizontal Data to Vertical appeared first on Xelplus - Leila Gharani.

]]> Copy Excel Formulas Without Changing Cell References https://www.xelplus.com/copy-excel-formulas-without-changing-cell-references/ Mon, 26 Feb 2018 19:31:00 +0000 https://www.xelplus.com/?p=11059 Would you like to copy your Excel formulas from one place to another without the cell references changing? In this step by step tutorial I show you a very simple trick that does that.

The post Copy Excel Formulas Without Changing Cell References appeared first on Xelplus - Leila Gharani.

]]>