SORTBY Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sortby/ Bestselling Excel and Power BI Courses Fri, 10 Mar 2023 23:19:08 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png SORTBY Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sortby/ 32 32 Office 2021 – New Functions and Enhancements https://www.xelplus.com/office-2021-new-features/ Thu, 14 Oct 2021 08:10:00 +0000 https://www.xelplus.com/?p=9771 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 Generate Random Numbers in Excel https://www.xelplus.com/excel-generate-random-numbers/ Thu, 24 Jun 2021 08:00:00 +0000 https://www.xelplus.com/?p=9988 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.

]]> How to Use Excel XLOOKUP, FILTER, SORT, UNIQUE, SORTBY and SEQUENCE Functions https://www.xelplus.com/excel-functions-office-365/ Thu, 07 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=10369 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.

]]> Excel LAMBDA Function Explained https://www.xelplus.com/excel-lambda-function-explained/ Thu, 17 Dec 2020 10:00:00 +0000 https://www.xelplus.com/?p=9037 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 https://www.xelplus.com/excel-da-dynamic-sorted-chart/ Thu, 19 Mar 2020 10:00:00 +0000 https://www.xelplus.com/?p=11421 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.

]]>