Category: Business

Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1828-1832.xlsx
Learn about how to rearrange multiple lookup tables to allow you to use the FILTER function to lookup multiple tables, then use LOOKUP to do approximate match lookup.
Topics:
1. (00:00) Introduction
2. (00:53) rearrange multiple lookup tables to allow you to use the FILTER function
3. (01:08) Filter Function to lookup multiple tables
4. (02:13) LOOKUP to do approximate match lookup
5. (02:52) Summary of five LOOKUP videos
6. (03:22) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #lookup #xlookup #vlookup #vlookupformula #filter #filterfunction #tables #multiple

Excel Battle on ESPN – Sketch Comedy – 3 Dimes on Diarmuid Early

Posted on by Annie D

The second ever Excel Battle to air on ESPN will happen on Friday August 4, 2023 at 7 AM Eastern time. This short is a bit of sketch comedy … wouldn’t it be great if Excel on ESPN were so commonplace that bookies would start to allow betting on the competition? That’s when you know that you’ve made it to the big time.

This fictitious sketch imagines a day far in the future when you can just call up a bookie and place some action on Diarmuid Early or your favorite Excel competitor.

For 2023, set your alarm and tune in Continue reading “Excel Battle on ESPN – Sketch Comedy – 3 Dimes on Diarmuid Early” →

Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1828-1832.xlsx
Create lookup formula when you have multiple lookup tables for approximate match lookup using the LOOKUP and SWITCH functions.
Topics:
1. (00:00) Introduction
2. (00:46) Multiple Discount Lookup Tables
3. (01:11) Link to other videos with many solutions
4. (01:17) SWITCH function to lookup multiple tables
5. (02:21) LOOKUP to do approximate match lookup
6. (03:14) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #lookup #xlookup #vlookup #vlookupformula #switch #tables #multiple

LOOKUP Beats XLOOKUP For Horizontal / Vertical Lookup. Excel Magic Trick 1830

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1828-1832.xlsx
Learn about how to lookup an item in a horizontal range and return an item from a horizontal range using the LOOKUP function.
Topics:
1. (00:00) Introduction
2. (00:43) Lookup an item in a horizontal range and return an item from a horizontal range?
3. (00:58) XLOOKUP
4. (01:02) LOOKUP
5. (01:56) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #lookup #xlookup #vlookup #vlookupformula

Excel Esports Returns on “ESPN8: The Ocho”! on August 4, 2023

Posted on by Annie D

Mark your calendars for 7 AM (ET), August 4, 2023, as we gear up for an adrenaline-pumping Excel Esports Elimination Battle – a completely new Excel Esports game format will be revealed!

8 Excel enthusiasts will be competing in a fierce 30-minute battle, but every 5 minutes one of them will be eliminated: Andrew Ngai, Isaac Lee, Diarmuid Early, David Brown, Alana Reid, Brittany Deaton, Michael Holmes, and Emilie Williams.

Hosted by Excel rock stars Leila Gharani, Bill Jelen, and Oz du Soleil!

From precision plays to amazing strategies, the Excel world’s finest content is being brought to your screens.

Whether you’re a die-hard Continue reading “Excel Esports Returns on “ESPN8: The Ocho”! on August 4, 2023″ →

LOOKUP Beats XLOOKUP For Single Cell Revenue Calculation. SUMPRODUCT Too! EMT 1829

Posted on by Annie D

Learn about how to create a single cell revenue formula that lookups up all prices and multiplies by all quantities and then adds.
Topics:
1. (00:00) Introduction
2. (00:49) About Revenue Calculation
3. (00:59) Three Step Method
4. (01:27) XLOOKUP & SUMPRODUCT
5. (01:32) LOOKUP & SUMPRODUCT
6. (03:06) Summary
7. (03:21) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #lookup #xlookup #vlookup #vlookupformula

Unleashing The Power Of OpenAI’s Code Interpreter For Data Analysis — This Changes Everything!

Posted on by Annie D

Dive into the world of data science with OpenAI’s Code Interpreter. This video showcases the power and potential of this innovative tool in performing advanced data analysis tasks. We’ll explore a customer service call dataset, demonstrating how Code Interpreter automates the creation of BI notebooks, performs time series analysis, predictive modeling, and more. Discover how Code Interpreter is democratizing data science, making complex analyses accessible to a wider audience. Join us on this exciting journey into the future of data analysis with OpenAI’s Code Interpreter!

Key Takeaways:

– The video introduces and explores the use of OpenAI’s Code Interpreter for advanced data Continue reading “Unleashing The Power Of OpenAI’s Code Interpreter For Data Analysis — This Changes Everything!” →

Federal Income Tax Calculation: LOOKUP Function Beats VLOOKUP & XLOOKUP! EMT 1828 Part 2

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1828-1832.xlsx
Learn how to calculate federal Income tax using the LOOKUP function..
Topics:
1. (00:00) Introduction
2. (00:10) Progressive Tax Brackets
3. (00:46) Manual Formula
4. (01:32) LOOKUP Function formula
5. (02:33) Summary
6. (02:51) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #lookup #xlookup #vlookup #vlookupformula

LOOKUP Function Can Do VLOOKUP or HLOOKUP, But Be Careful! EMT 1828 Part 2

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1828-1832.xlsx
Learn that the LOOKUP function can do vertical lookup or horizontal lookup. Also see warning about vertical tables with more columns than rows.
Topics:
1. (00:00) Introduction
2. (00:27) LOOKUP Function Can Do VLOOKUP or HLOOKUP
3. (01:04) LOOKUP to do Vertical Lookup, where rows greater than columns
4. (01:22) LOOKUP to do Horizontal Lookup, where columns greater than rows
5. (01:37) LOOKUP to do Vertical Lookup, where rows equal columns
6. (01:47) Error if you try to do Vertical Lookup when columns greater than rows
7. (02:10) What to do if columns greater than rows
8. (02:37) Summary
9. (02:56) Closing, Video Links

#excel Continue reading “LOOKUP Function Can Do VLOOKUP or HLOOKUP, But Be Careful! EMT 1828 Part 2” →

LOOKUP Beats XLOOKUP at Approximate Match for Discounts, Taxes, Commissions. EMT 1828

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1828-1832.xlsx
Learn about how it is faster to create approximate match lookup formulas with LOOKUP than it is with XLOOKUP when you have discount, tax or commission lookup tables.
Topics:
1. (00:00) Introduction
2. (00:50) Approximate Match Lookup
3. (01:05) XLOOKUP
4. (01:28) LOOKUP
5. (02:22) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #freeclass #freecourse #freeclasses #excelclasses #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #lookup #xlookup #vlookup #vlookupformula

Leagues Cup Tie Probability / Will Messi Play in Orlando in August – Excel episode 2610

Posted on by Annie D

Microsoft Excel Tutorial: Tiebreakers in Leagues Cup Soccer Group Stage.

Lionel Messi’s debut in the US for Miami is in the Leagues Cup. This four-week tournament includes 47 clubs from across the USA, Canada, and Mexico. What are the odds of a tiebreaker in group play for the Leagues Cup? If Miami finishes first or second in their group, who will they play in the knockout stage?

To download this workbook: https://www.mrexcel.com/youtube/M6xbdRFASnI/

Table of Contents
(0:00) Problem Statement: Odds of tiebreaker
(0:21) Orlando City Soccer two home matches in Leagues Cup
(0:48) Lionel Messi’s US debut will be in Leagues Cup
(1:00) Leagues Continue reading “Leagues Cup Tie Probability / Will Messi Play in Orlando in August – Excel episode 2610” →