FILTER function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/filter-function/ Bestselling Excel and Power BI Courses Tue, 21 Nov 2023 16:20:51 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png FILTER function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/filter-function/ 32 32 Excel’s Checkboxes Are Incredibly Cool! Here’s why https://www.xelplus.com/excel-checkboxes/ Tue, 21 Nov 2023 16:18:58 +0000 https://www.xelplus.com/?p=19747 Excel's new Checkbox feature makes lists and interactive reports easier than ever. See how to add, customize, and use the new checkbox feature in a creative and interesting ways.

The post Excel’s Checkboxes Are Incredibly Cool! Here’s why appeared first on Xelplus - Leila Gharani.

]]> Excel Find and Highlight Duplicates https://www.xelplus.com/excel-find-and-highlight-duplicates/ Thu, 24 Aug 2023 15:12:21 +0000 https://www.xelplus.com/?p=17558 Learn to locate duplicate values in a list, between multiple lists, as well as duplicate rows in a table. Generate a report that lists all duplicates.

The post Excel Find and Highlight Duplicates appeared first on Xelplus - Leila Gharani.

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

]]> 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 Use Excel BYROW and BYCOL Helper Functions for LAMBDA https://www.xelplus.com/excel-byrow-bycol-functions/ Thu, 23 Sep 2021 08:00:00 +0000 https://www.xelplus.com/?p=8880 Find out how you can use the new Excel BYROW and BYCOL functions. These are called Lambda helper functions and they can help you save a lot of time if your analysis is based on a whole row or an entire column. Check out this practical example to find out more.

The post How to Use Excel BYROW and BYCOL Helper Functions for LAMBDA 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.

]]> How to Use Checkboxes in Excel https://www.xelplus.com/how-to-use-checkboxes-in-excel/ Thu, 15 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9954 Quickly learn how to create a checkbox in Excel. You can also easily create multiple checkboxes. It's important to learn how to use the outcome of the checkbox in formulas or conditional formatting - for example to get a strikethrough effect. Find out in this comprehensive tutorial.

The post How to Use Checkboxes in Excel 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.

]]>