SORT function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sort-function/ Bestselling Excel and Power BI Courses Tue, 10 Oct 2023 08:06:18 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png SORT function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/sort-function/ 32 32 How To Use Excel FILTER Function With Multiple Criteria https://www.xelplus.com/excel-filter-function-with-multiple-criteria/ Thu, 24 Aug 2023 15:02:59 +0000 https://www.xelplus.com/?p=17612 Learn to use Excel's FILTER function with multiple criteria (AND/OR) and how to return only the columns you need with the help of CHOOSECOLS.

The post How To Use Excel FILTER Function With Multiple Criteria appeared first on Xelplus - Leila Gharani.

]]> Excel VSTACK Function – The One Excel Formula to Append Them All https://www.xelplus.com/excel-vstack-function/ Thu, 26 May 2022 23:55:00 +0000 https://www.xelplus.com/?p=9237 This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

The post Excel VSTACK Function – The One Excel Formula to Append Them All appeared first on Xelplus - Leila Gharani.

]]> How to Properly Use the Excel TEXTSPLIT Function https://www.xelplus.com/excel-textsplit-function/ Thu, 31 Mar 2022 08:00:00 +0000 https://www.xelplus.com/?p=9374 Excel's TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.

The post How to Properly Use the Excel TEXTSPLIT Function appeared first on Xelplus - Leila Gharani.

]]> 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.

]]> Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) https://www.xelplus.com/excel-switch-columns-multiple-values/ Thu, 29 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9917 Pivoting columns in Excel is a common task when cleaning and organizing data. Sometimes you have a complex scenario where you have multiple values when switching columns. You'll have to combine these multiple values into one cell. I'll show you 3 methods to get this done.

The post Excel Convert Multiple Rows to Columns (Transpose but with Multiple Values) appeared first on Xelplus - Leila Gharani.

]]> Google Sheets – How to Create a Unique List from Multiple Columns https://www.xelplus.com/sheets-unique-list-from-multiple-columns/ Wed, 28 Jul 2021 17:20:00 +0000 https://www.xelplus.com/?p=9943 Use the hidden Google Sheets FLATTEN function to get a unique list of values from multiple columns. You just have to combine it with UNIQUE and you're done!

The post Google Sheets – How to Create a Unique List from Multiple Columns appeared first on Xelplus - Leila Gharani.

]]> Top Excel Interview Questions – Be Ready for your Next Interview https://www.xelplus.com/excel-job-interview-questions/ Mon, 12 Jul 2021 06:49:00 +0000 https://www.xelplus.com/?p=9965 In this article, I summarize the MOST COMMON Excel questions that are currently asked during interviews. This covers positions such as business or MIS analyst, Data Analyst, Financial Analyst or more senior positions. You'll be surprised at the level of Excel that's currently required for some of these positions.

The post Top Excel Interview Questions – Be Ready for your Next Interview 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 Radio Buttons in Excel to Create Interactive Dashboards https://www.xelplus.com/excel-dashboards-with-radio-buttons/ Thu, 17 Jun 2021 08:00:00 +0000 https://www.xelplus.com/?p=9999 Quickly learn how to add option buttons (radio buttons) to your files to create interactive Excel Dashboards and dynamic charts. It's really easy once you learn this one trick!

The post How to Use Radio Buttons in Excel to Create Interactive Dashboards appeared first on Xelplus - Leila Gharani.

]]> Top 10 Tips to Make the Most of Google Sheets https://www.xelplus.com/top-10-tips-for-google-sheets/ Sun, 28 Feb 2021 22:02:00 +0000 https://www.xelplus.com/?p=10240 This is the list of my favorite tips and functions in Google Sheets. If you're new to Google Sheets, this list will give you an overview of the potential of Sheets. If you're advanced, you'll probably find some new features and functions you didn't know about.

The post Top 10 Tips to Make the Most of Google Sheets appeared first on Xelplus - Leila Gharani.

]]>