SORTBY Archives - 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.

Must-Know Excel Functions for 2024

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

This is the list of the most useful, new Excel Functions you need to know. These will save you from wasting time with complex formulas!

The post Must-Know Excel Functions for 2024 appeared first on Xelplus - Leila Gharani.

Excel LAMBDA Function Explained

Leila Gharani — Thu, 17 Dec 2020 10:00:00 +0000

With the new Excel Lambda function you can create your own custom functions that you can reuse. The best thing about Excel Lambdas is you can create a function that loops through many cells. You can do this with ZERO coding! In part 1, discover the LAMBDA logic and learn how to write your first Lambda.

The post Excel LAMBDA Function Explained appeared first on Xelplus - Leila Gharani.

How to Create Excel Interactive Charts with Dynamic Arrays

Leila Gharani — Thu, 19 Mar 2020 10:00:00 +0000

Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.

The post How to Create Excel Interactive Charts with Dynamic Arrays appeared first on Xelplus - Leila Gharani.