Blog

Excel Fill Handle To Copy Formula Rules Deep Dive – Episode 2611

Posted on August 7, 2023 by Annie D

Microsoft Excel Tutorial – Troubleshooting when you double-click fill handle to copy a formula.

A great question this morning: Is there a bug in double-click the fill handle to copy a formula? Someone was convinced that Excel was being fooled by the formatting.

The behavior of copying a formula by double-clicking the fill handle changed in Excel 2010. Excel now looks at all columns to the left and the right when figuring out how far to copy down. Imagine if Excel does Ctrl+* to select the current region. Excel will copy down to the last row in the current region.

There are two Continue reading “Excel Fill Handle To Copy Formula Rules Deep Dive – Episode 2611” →

XLOOKUP or VLOOKUP Based on Sheet Tabe Name!?! Excel Magic Trick 1833

Posted on August 7, 2023 by Annie D

Download Excel File: https://excelisfun.net/files/EMT1833-1834.xlsx
Learn how to use the worksheet tab name as the lookup value in XLOOKUP or VLOOKUP..
Topics:
1. (00:00) Introduction
2. (00:24) CELL Function
3. (01:21) TEXTAFTER Function
4. (01:49) RELPACE and SEARCH functions.
5. (02:22) XLOOKUP or VLOOKUP
6. (03:27) Copy Lookup Formula
7. (04:13) Summary
8. (04:26) 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

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

Posted on August 4, 2023 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

ESPN showing Excel battle Friday at 7AM – At Least The Sun Is Up!

Posted on August 4, 2023 by Annie D

Don’t forget to tune into the second ever Microsoft Excel competition to air on ESPN.
Friday, August 4, 2023 at 7AM Eastern.
That is Noon in the UK/Ireland
1 PM Amsterdam / Berlin / Paris
4:30 PM New Delhi
7 PM Hong Kong
9 PM Melbourne

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

Posted on August 4, 2023 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 August 1, 2023 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

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

Posted on July 29, 2023 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 Esports Returns on “ESPN8: The Ocho”! on August 4, 2023

Posted on July 28, 2023 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 July 26, 2023 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

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

Posted on July 24, 2023 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 July 23, 2023 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

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

Posted on July 21, 2023 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” →

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this: