XLOOKUP Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/xlookup/ Bestselling Excel and Power BI Courses Fri, 08 Dec 2023 14:27:10 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png XLOOKUP Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/xlookup/ 32 32 Excel Dashboard to Track Budget and Actuals with Variances https://www.xelplus.com/excel-budget-actual-dashboard/ Fri, 08 Dec 2023 14:25:28 +0000 https://www.xelplus.com/?p=19902 Learn to build a budget vs actual dashboard in Excel. Master key formulas and chart customization for effective year-over-year variance analysis.

The post Excel Dashboard to Track Budget and Actuals with Variances appeared first on Xelplus - Leila Gharani.

]]> How to use Excel’s LOOKUP Function https://www.xelplus.com/excel-lookup-function/ Thu, 05 May 2022 08:00:00 +0000 https://www.xelplus.com/?p=9330 The lookup function is the simplest function in Excel. It can return exact or approximate matches and it's super easy to write. Yet many people prefer VLOOKUP because it's easier to understand. In this tutorial, I'll explain the LOOKUP function by using a simple, followed by a more complex example.

The post How to use Excel’s LOOKUP 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.

]]> 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 vs. Google Sheets – Is Excel Better? https://www.xelplus.com/excel-vs-google-sheets/ Thu, 01 Oct 2020 09:00:00 +0000 https://www.xelplus.com/?p=10646 These are 10 Excel features that are better than Google Sheets. This post is like a "top 10 tips and tricks" type of post. Even if you're currently using Excel, you might discover new tips you can use.

The post Excel vs. Google Sheets – Is Excel Better? appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel IFS Function https://www.xelplus.com/excel-ifs-function/ Thu, 09 Jul 2020 10:48:00 +0000 https://www.xelplus.com/?p=10875 The IF function is one of the most popular functions in Excel. But what about the IFS function? Does it really make writing nested IF functions easier? Let's find out.

The post How to Use Excel IFS Function appeared first on Xelplus - Leila Gharani.

]]> How to Create Excel Searchable Drop-Down Lists for Every Row https://www.xelplus.com/excel-searchable-drop-down-every-row/ Thu, 16 Apr 2020 09:00:00 +0000 https://www.xelplus.com/?p=11372 Learn to create a simple searchable drop-down list in Excel on multiple rows. Searchable lists make it much easier to find an item from a large data validation list.

The post How to Create Excel Searchable Drop-Down Lists for Every Row appeared first on Xelplus - Leila Gharani.

]]> Practical Excel Dashboards Tips – Ideas to Get Creative https://www.xelplus.com/excel-hash-2019/ Wed, 11 Dec 2019 03:18:00 +0000 https://www.xelplus.com/?p=11674 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.

]]> How to Use Excel XLOOKUP Function – 5 Examples https://www.xelplus.com/excel-xlookup-5-examples/ Thu, 28 Nov 2019 10:00:00 +0000 https://www.xelplus.com/?p=11766 Excel's New & Improved XLOOKUP function will be the answer to most of your Excel Lookup problems. Learn from these 5 examples to see how you can apply the new XLOOKUP function to your files.

The post How to Use Excel XLOOKUP Function – 5 Examples appeared first on Xelplus - Leila Gharani.

]]> How to do a Left LOOKUP with XLOOKUP https://www.xelplus.com/excel-lookup-to-the-left-with-xlookup/ Thu, 21 Nov 2019 11:37:00 +0000 https://www.xelplus.com/?p=9417 If you'd like to do a lookup to the left in Excel use the new XLOOKUP function. Forget about using INDEX MATCH or a VLOOKUP workaround. Just go with XLOOKUP.

The post How to do a Left LOOKUP with XLOOKUP appeared first on Xelplus - Leila Gharani.

]]>