SEQUENCE 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 the Number of Days Between Two Dates in Excel

Leila Gharani — Thu, 05 Aug 2021 08:00:00 +0000

It's easy to calculate the difference between dates in Excel and exclude weekends and holidays. But how can you exclude ANY weekday of your choice? There is an Excel trick you can use.

The post How to Calculate the Number of Days Between Two Dates in Excel appeared first on Xelplus - Leila Gharani.

How to Generate Random Numbers in Excel

Leila Gharani — Thu, 24 Jun 2021 08:00:00 +0000

This tutorial shows you different methods to generate random numbers in Excel (including no repeats). You might need random numbers if you're preparing test data. Or if you need to share your files with consultants and have to replace official values with random ones.

The post How to Generate Random Numbers in Excel appeared first on Xelplus - Leila Gharani.

When to Use the Hash Sign (#) in Excel Formulas

Leila Gharani — Thu, 21 Jan 2021 10:00:00 +0000

What is the Hash sign (#) in Excel formulas and when should you use it? The hash sign was the best addition to Excel and you SHOULD be using it. But most people use it wrong. Check out this post to learn when and why you should use the pound sign in your formulas.

The post When to Use the Hash Sign (#) in Excel Formulas appeared first on Xelplus - Leila Gharani.

How to Use Excel XLOOKUP, FILTER, SORT, UNIQUE, SORTBY and SEQUENCE Functions

Leila Gharani — Thu, 07 Jan 2021 10:00:00 +0000

This is the list of the most useful Excel Functions you need to know in 2021. There are the new functions available in Excel for Microsoft 365 and also on Excel for the web (available for free).

The post How to Use Excel XLOOKUP, FILTER, SORT, UNIQUE, SORTBY and SEQUENCE Functions appeared first on Xelplus - Leila Gharani.

How to Create a Yearly Calendar with ONE Excel Formula (Use in Google Sheets too)

Leila Gharani — Thu, 12 Nov 2020 10:00:00 +0000

Use this simple formula to create a dynamic yearly calendar in Excel (It works for Google Sheets as well). All you need to update is the year and you will automatically get the calendar for that year.

The post How to Create a Yearly Calendar with ONE Excel Formula (Use in Google Sheets too) appeared first on Xelplus - Leila Gharani.

How to Get Top Values in Excel with the FILTER Function

Leila Gharani — Thu, 07 May 2020 09:00:00 +0000

Create an Excel report with the top values and categories. Sort them by ranking and also handle duplicated (tied) values. Get it done fast with Excel new dynamic array Sort & Filter formulas.

The post How to Get Top Values in Excel with the FILTER Function appeared first on Xelplus - Leila Gharani.

Practical Excel Dashboards Tips – Ideas to Get Creative

Leila Gharani — Wed, 11 Dec 2019 03:18:00 +0000

This Excel dashboard combines 4 strange features to create a dynamic and practical dashboard. It includes FILTER function with XLOOKUP, XOR function, Linked Picture as well as an Icon. You'll find a lot of hidden gems in the way this Excel dashboard was created.

The post Practical Excel Dashboards Tips – Ideas to Get Creative appeared first on Xelplus - Leila Gharani.