Deviations Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/deviations/ Bestselling Excel and Power BI Courses Fri, 10 Mar 2023 23:15:25 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Deviations Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/deviations/ 32 32 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.

]]> Smart Uses of Custom Formatting in Excel – Part 2 https://www.xelplus.com/smart-uses-of-custom-formatting-part-2/ Wed, 30 Aug 2017 14:36:00 +0000 https://www.xelplus.com/?p=14155 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. In part 2, learn how to add any symbol to custom number format, how to use up/down arrows for percentage variances, and how custom formatting works with thresholds and icons.

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

]]>