Excel 3D Reference - easily reference data on another worksheet

A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination. You can use multiple functions when creating a 3D reference. Functions such as Sum, Average, Count, Counta, Max, and Min all work with a 3D reference.

Bookmarks/Chapters
0:00 Intro
0:20 Put in Time in Excel
1:25 3D reference
2:17 Update source

Examples of 3D references
=B2 changes in B2 will reflect in another cell.
=Monday!B2 reference the Monday worksheet. Changes in cell B2 on the Monday worksheet will update.
=Sum(East:West!B2) changes in the worksheets that start with East and go to West for cell B2 will reflect. We could have multiple worksheets between the East and West worksheets.

3D videos by Chris Menard for multiple worksheets - Excel how to use a 3D reference to add worksheets - https://www.youtube.com/watch?v=wdXTIRPEBio

Keyboard shortcuts
CTRL + Shift + ; current time
CTRL + ; current date

Blog post by Chris Menard https://chrismenardtraining.com/post/excel-3d-reference-easily-reference-data-on-another-worksheet

#chrismenardtraining #msexcel #microsoftexcel

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

Видео Excel 3D Reference - easily reference data on another worksheet канала Chris Menard