3D Formulas In Excel (a.k.a. Cross Sheet Calculations)

Discover how to create 3D formulas in Excel which pick up data from several different worksheets.
(for your convenience, topic time codes are listed below - click SHOW MORE).

This video explains why and how to create 3D formulas, which are much shorter and more compact than regular formulas.

3D formulas are also quicker to create and the chance of errors is reduced.

While the video shows how to create SHOSS SHEET formulas you can create CROSS WORKBOOK formulas in exactly the same way.

What’s not to like !

😃 TIME CODES (click the link to go directly to that spot in the video)
- (0:00) Intro to 3D formulas
- (0:20) My example data
- (0:39) How most people create formulas
- (1:17) BTW, here's a big benefit of using formatted tables ...
- (1:26) ... but watch out for this
- (1:54) How to create a 3D formula
- (3:23) And yet another benefit of using formatted tables
- (3:43) Creating another 3D formula

I trust you found this video useful. What ONE thing resonated with you the most? Let me know by adding a quick comment below and click the thumbs up button under the video! Oh, and subscribe if you'd like to see more like this. Much appreciated.

😃 USEFUL LINKS:
Share this Video:

😃 SUBSCRIBE if you want to see more content like this

😃 HIRE JASON to fix your broken spreadsheets or to get private 1-on-1 Zoom coaching

😃 ABOUT THE PRESENTER:
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.

😃 LET'S CONNECT!

Have a fantastic day!