Hiding Zeros Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/hiding-zeros/ Bestselling Excel and Power BI Courses Fri, 10 Mar 2023 23:15:14 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Hiding Zeros Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/hiding-zeros/ 32 32 How to Create and Use Excel Custom Number Formatting https://www.xelplus.com/why-you-should-be-using-custom-number-formatting/ Fri, 24 May 2019 23:42:00 +0000 https://www.xelplus.com/?p=12335 Taking advantage of Excel's custom number formatting is a must for any advanced Excel user. Learn some easy and useful tricks when it comes to custom formatting.

The post How to Create and Use Excel Custom Number Formatting 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.

]]> Quick Excel Trick to Unstack Data from One Column to Multiple Columns https://www.xelplus.com/unstack-data-to-multiple-columns/ Sat, 12 Jan 2019 02:15:00 +0000 https://www.xelplus.com/?p=9820 Find out the quickest way to unstack data in Excel from one column to multiple columns. You don't need complicated excel formulas or VBA. Find out how in this tutorial.

The post Quick Excel Trick to Unstack Data from One Column to Multiple Columns appeared first on Xelplus - Leila Gharani.

]]> Smart Uses of Custom Formatting in Excel https://www.xelplus.com/smart-uses-of-custom-formatting/ Wed, 30 Aug 2017 14:36:00 +0000 https://www.xelplus.com/?p=14129 Conditional formatting is great at bringing attention to specific values, whether high/low, deviations, variances. It makes interpreting the data easier. But it can also significantly slow down your workbook. There is a faster alternative. You can use Custom Number Formatting to bring attention to data. Learn how to use it, how to add color-coded up/down errors and percentage deviations.

The post Smart Uses of Custom Formatting in Excel appeared first on Xelplus - Leila Gharani.

]]>