Premium Only Content
![Excel 3D Formulas Explained (Includes a Bonus Excel Hack!)](https://1a-1791.com/video/s8/1/s/a/z/u/sazuk.qR4e.2-small-Excel-3D-Formulas-Explained.jpg)
Excel 3D Formulas Explained (Includes a Bonus Excel Hack!)
23 January 2020 Excel Hacks: Tips & Tricks
Excel 3D formulas can be used to consolidate data from multiple worksheets into a summary sheet. 3D formulas aren't that well known except to advanced Excel users.
If you ever needed to reference the same cell or the same range on multiple Excel worksheets you'll know this can be quite a tedious process. Plus the reference is not dynamic. So, if another Excel sheet gets added in the middle, the formula will not update.
It doesn't have to be this way! In this video I'll show you an alternative approach to gather data from multiple Excel sheets to one sheet. With Excel 3-d reference formulas you can replace this cumbersome process with a short and flexible formula.
In addition, I'll show you a bonus Excel trick I received from Bob Umlas. With this hack we can even add cells or ranges on worksheets that aren't beside one another. This works as long as the sheets have a common name. It's like using wildcards in the 3d reference.
00:47 Excel 3D Formula explained
06:21 Bob's Bonus Trick for using 3d formulas in Excel
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-3d-formulas
Excel Tips & tricks playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxVeel8DFjewBSlZYdfd38A
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
-
LIVE
Wendy Bell Radio
5 hours agoThe Rats Are Scrambling
15,009 watching -
LIVE
Jeff Ahern
1 hour agoMonday Madness with Jeff Ahern (put a fork in them)
682 watching -
42:43
Dad Dojo Podcast
7 hours ago $0.35 earnedEP19: Cashing In Crypto
5.61K -
2:30:07
TheDozenPodcast
21 hours agoEpstein island, fake news, Royal Family scandal: Dan Wootton
3.63K3 -
LIVE
The Pete Santilli Show
4 hours agoRASKIN THREATENS CLASS ACTION TO STOP MUSK. BERNIE LIES TO THE PUBLIC ABOUT DOGE [EP 4434-8AM]
1,452 watching -
10:31
Space Ice
23 hours agoHardcore Henry - A Average Day In The Life Of Space Ice - Best Movie Ever
5.28K22 -
8:03
Colion Noir
21 hours agoA Judge Just Ruled You Can Own A Machine Gun
14.5K54 -
46:13
Survive History
22 hours ago $0.49 earnedCould You Survive in the Roman Special Forces?
8.28K -
19:40
Fit'n Fire
22 hours ago $0.02 earnedThe Best PDW -- Sig Sauer MPX 8" PDW
4.34K4 -
1:03:12
Game On!
13 hours ago $2.56 earnedOUCH, That Hurts! Eagles DOMINATE Chiefs in Super Bowl 59!
11.4K16