XMATCH Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/xmatch/ Bestselling Excel and Power BI Courses Mon, 11 Dec 2023 12:06:20 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png XMATCH Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/xmatch/ 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.

]]> When to Use the Hash Sign (#) in Excel Formulas https://www.xelplus.com/excel-hash-sign-formulas/ Thu, 21 Jan 2021 10:00:00 +0000 https://www.xelplus.com/?p=10332 What is the Hash sign (#) in Excel formulas and when should you use it? The hash sign was the best addition to Excel and you SHOULD be using it. But most people use it wrong. Check out this post to learn when and why you should use the pound sign in your formulas.

The post When to Use the Hash Sign (#) in Excel Formulas appeared first on Xelplus - Leila Gharani.

]]>