Custom Number Formatting Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/custom-number-formatting/ Bestselling Excel and Power BI Courses Tue, 26 Sep 2023 14:08:41 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Custom Number Formatting Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/custom-number-formatting/ 32 32 Number Rows in Excel – Dynamic Solution with SEQUENCE https://www.xelplus.com/number-rows-in-excel-sequence-function/ Tue, 26 Sep 2023 14:08:36 +0000 https://www.xelplus.com/?p=18384 Learn how to create self-numbering lists for Excel tables and traditional lists using the SEQUENCE function.

The post Number Rows in Excel – Dynamic Solution with SEQUENCE appeared first on Xelplus - Leila Gharani.

]]> Excel What-If Analysis: Data Table Tool https://www.xelplus.com/excel-what-if-analysis-data-table/ Fri, 02 Dec 2022 16:47:00 +0000 https://www.xelplus.com/?p=8648 Excel's What-if Analysis Data Table allows you to quickly create simulations.

This tutorial takes you through a simple example of how you can create a Data Table from scratch.

The post Excel What-If Analysis: Data Table Tool appeared first on Xelplus - Leila Gharani.

]]> Combining Data from Multiple Cells – Text and Numbers https://www.xelplus.com/excel-combine-text-number/ Fri, 14 Jan 2022 15:05:00 +0000 https://www.xelplus.com/?p=9575 Learn practical and easy methods (including a hidden tip not many know about) to combine data from multiple cells into a single cell in Excel.

The post Combining Data from Multiple Cells – Text and Numbers appeared first on Xelplus - Leila Gharani.

]]> How to Add Text to Cell values in Excel – Add Text to Beginning or End of Cell values https://www.xelplus.com/excel-add-text-to-values/ Thu, 02 Sep 2021 08:00:00 +0000 https://www.xelplus.com/?p=9825 You can easily add text to your cell values in Excel. You don't have to do this manually. You have 3 easy options to choose from. The 3rd one will surprise you. You can use it in many other circumstances as well.

The post How to Add Text to Cell values in Excel – Add Text to Beginning or End of Cell values 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.

]]> How to Use Excel Histogram Chart https://www.xelplus.com/excel-histogram-chart/ Thu, 03 Sep 2020 09:00:00 +0000 https://www.xelplus.com/?p=10774 Histogram charts are easy to make in Excel. It might not be straightforward though how to adjust the bin numbers. It's really easy once you know. Check out this quick tutorial.

The post How to Use Excel Histogram Chart appeared first on Xelplus - Leila Gharani.

]]> Excel Conditional Formatting FUN Trick – Introducing the Mosaic Chart https://www.xelplus.com/excel-fun-mosaic-trick/ Thu, 01 Aug 2019 10:15:00 +0000 https://www.xelplus.com/?p=12265 Practice a lot of useful Excel techniques by setting up a fun game. You can create a mosaic puzzle in Excel with the help of the RANDBETWEEN function and features such as conditional formatting, custom number formatting, Excel backgrounds, row and column hiding and resizing, and Form Controls.

The post Excel Conditional Formatting FUN Trick – Introducing the Mosaic Chart appeared first on Xelplus - Leila Gharani.

]]> 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.

]]> How to Present Survey Results in Excel with a Chart https://www.xelplus.com/charting-survey-results-excel/ Sat, 20 Apr 2019 19:24:00 +0000 https://www.xelplus.com/?p=12518 What's an effective way to visualize survey results in Excel? Specially results of an employee satisfaction survey? In this tutorial, you'll find an impressive way to chart survey results in Excel. It's not as difficult as you think.

The post How to Present Survey Results in Excel with a Chart appeared first on Xelplus - Leila Gharani.

]]>