You searched for xlookup - Xelplus - Leila Gharani https://www.xelplus.com/ Bestselling Excel and Power BI Courses Wed, 13 Dec 2023 13:38:56 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png You searched for xlookup - Xelplus - Leila Gharani https://www.xelplus.com/ 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.

]]> Guerrilla Data Analysis Using Microsoft Excel (eBook) https://www.xelplus.com/course/guerrilla-data-analysis-ebook/ Thu, 07 Dec 2023 08:41:12 +0000 https://www.xelplus.com/?post_type=xp_course&p=20086 Upgrade your Excel knowledge with this guide.
Perfect for any skill level. Dive into hands-on analysis with real-world cases and tools.

The post Guerrilla Data Analysis Using Microsoft Excel (eBook) appeared first on Xelplus - Leila Gharani.

]]> Excel Essentials for the Real World – Limited Offer https://www.xelplus.com/course/excel-essentials-for-the-real-world-ob/ Tue, 31 Oct 2023 08:25:18 +0000 https://www.xelplus.com/?post_type=xp_course&p=19450 Learn time-saving hacks to work smarter in Excel. Our members also consistently report a newfound enthusiasm for using Excel after taking our course.

The post Excel Essentials for the Real World – Limited Offer appeared first on Xelplus - Leila Gharani.

]]> ChatGPT Prompts for Best Results https://www.xelplus.com/chatgpt-prompts-for-best-results/ Mon, 16 Oct 2023 12:07:24 +0000 https://www.xelplus.com/?p=19183 Don't use ChatGPT without making these very important customizations. These settings will take your ChatGPT responses from generic to incredibly accurate.

The post ChatGPT Prompts for Best Results appeared first on Xelplus - Leila Gharani.

]]> Insert Image in Excel Cell (and Lookup Images) https://www.xelplus.com/excel-insert-image-in-cell/ Tue, 26 Sep 2023 14:58:44 +0000 https://www.xelplus.com/?p=18599 Learn how to use the new "Image in Cell" feature in Excel to store and lookup images from cells.

The post Insert Image in Excel Cell (and Lookup Images) appeared first on Xelplus - Leila Gharani.

]]> Excel Insights by 24 Excel MVPs (eBook) https://www.xelplus.com/course/excel-insights/ Thu, 16 Mar 2023 07:57:29 +0000 https://www.xelplus.com/?post_type=xp_course&p=15391 Written by MVPs. Edited by MVPs. This book shares a wide variety of advanced and new techniques. Bonus videos on Data Presentation included.

The post Excel Insights by 24 Excel MVPs (eBook) appeared first on Xelplus - Leila Gharani.

]]> Master NEW Excel Functions in Office 365 & Office 2021 https://www.xelplus.com/course/excel-dynamic-array-365-formulas/ Mon, 13 Feb 2023 17:19:08 +0000 https://www.xelplus.com/?post_type=xp_course&p=8798 Ready to supercharge your Excel skills? This course will help you master the new set of functions introduced to Excel for Office 365. You'll create professional-grade reports in a fraction of the time it used to take you.

The post Master NEW Excel Functions in Office 365 & Office 2021 appeared first on Xelplus - Leila Gharani.

]]> Visually Effective Excel Dashboards https://www.xelplus.com/course/excel-dashboards/ Mon, 13 Feb 2023 17:13:22 +0000 https://www.xelplus.com/?post_type=xp_course&p=8787 Create eye-catching Excel Dashboards with actionable tips you can use right away.

The post Visually Effective Excel Dashboards appeared first on Xelplus - Leila Gharani.

]]> Excel Essentials for the Real World https://www.xelplus.com/course/learn-excel-essentials/ Sat, 15 Oct 2022 22:01:31 +0000 https://www.xelplus.com/?post_type=xp_course&p=314 Learn time-saving hacks to work smarter in Excel. Our members also consistently report a newfound enthusiasm for using Excel after taking our course.

The post Excel Essentials for the Real World 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.

]]>