LET function Archives - Xelplus - Leila Gharani

Office 2021 – New Functions and Enhancements

Leila Gharani — Thu, 14 Oct 2021 08:10:00 +0000

Here's why you should upgrade to Office 2021 if you're on 2019 or 2016 (and for some reason you can't upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.

The post Office 2021 – New Functions and Enhancements appeared first on Xelplus - Leila Gharani.

How to Calculate Ratios in Excel

Leila Gharani — Thu, 25 Mar 2021 10:00:00 +0000

Easily calculate the ratio of two numbers in Excel with Excel formulas. Ratios are a common way to compare amounts. To calculate ratios, you need to calculate the highest common factor. You can easily do this with the GCD function.

The post How to Calculate Ratios in Excel appeared first on 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.

Excel VBA Data types, DIM & SET (Learn to use them correctly)

Leila Gharani — Sun, 20 Jan 2019 02:21:00 +0000

If you like to create efficient Excel macros, it's important to assign the correct data type to each variable. In this tutorial find out why you need to use the DIM statement and when you should use SET instead.

The post Excel VBA Data types, DIM & SET (Learn to use them correctly) appeared first on Xelplus - Leila Gharani.