Symbols Archives - Xelplus - Leila Gharani

How to Use Excel’s New LET Function

Leila Gharani — Thu, 13 Aug 2020 09:00:00 +0000

The new Excel LET function can make your formulas easier to read. PLUS it can improve the performance of your formulas so they run faster. Should you use this function in your files? Find out more in the complete tutorial.

The post How to Use Excel’s New LET Function appeared first on Xelplus - Leila Gharani.

BMW Corporate Report Makeover in Excel: Better Tables in Reports

Leila Gharani — Mon, 30 Oct 2017 14:36:00 +0000

How could BMW improve the presentation of their tables in their 2015 annual report? Take a look at some suggestions for better presenting data in tables in this tutorial.

The post BMW Corporate Report Makeover in Excel: Better Tables in Reports appeared first on Xelplus - Leila Gharani.

Excel – Use Symbols in Pivot Slicers

Leila Gharani — Wed, 04 Oct 2017 06:46:00 +0000

Learn how you can use symbols instead of text in your Pivot slicers to create visually effective Excel dashboard reports.

The post Excel – Use Symbols in Pivot Slicers appeared first on Xelplus - Leila Gharani.

Smart Uses of Custom Formatting in Excel

Leila Gharani — Wed, 30 Aug 2017 14:36:00 +0000

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

Leila Gharani — Wed, 30 Aug 2017 14:36:00 +0000

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.

Excel Conditional Formatting Symbols

Leila Gharani — Thu, 29 Jun 2017 09:47:00 +0000

If the conditional formatting icon selection doesn't meet your needs, you can customize your design and still make it dynamic with the help of the IF function and symbols. Explore the example of a project planning dashboard tracking overdue tasks.

The post Excel Conditional Formatting Symbols appeared first on Xelplus - Leila Gharani.