How to Use 3d Referencing in Excel: Utilize Multiple Sheets for One Formula
Excel 3d referencing or 3D formulas are well known productivity tip to advanced excel user. This can help you to remove manual process of selecting same cell from different sheets and consolidating data in Excel. This can help you to summarize the data on Summary Sheet Quickly.
Also its gonna help you to update Excel Formulas and ranges automatically when new sheets get inserted into Excel.
Let's understand what we talked in this video about Excel 3D Formula including one bonus Excel Trick.
00:00 Why we need 3D Referencing?
02:14 How to use 3D Referencing with a Cell?
03:50 Update Formula Automatically If New Sheet is Inserted
04:50 Use Excel Range in 3D Excel Formulas
06:08 Shortcut Key to Use 3D Excel Formulas
06:50 Use 3D Formulas with Wildcharacters
08:50 Bonus Trick: Apply Formula and Formatting on multiple Sheets without VBA
Hope you like this video, Please share it
Excel Filter Basics check out this video https://www.youtube.com/watch?v=LpOBi...
Most common Excel Date Functions - https://bit.ly/2Nif0LZ
VBA Course for beginners https://bit.ly/3swKX2S
You can also get this training and more resources here https://www.excelsirji.com
If you wanna support us and want us to write more. You can buy us a coffee from here:
https://www.buymeacoffee.com/excelsirji
Share the videos with your friends. Thank you
#Msexcel #excelfunctions #office365