advanced excel by pinaki - 3D Formula || MS Excel Ep - 04 || Career Development

Advanced Excel Course-এর 4th ক্লাসে আপনাদের স্বাগতম । আজকে আমরা শিখবো কিভাবে 3D Formula Use করে MS Excel এ কাজ করতে হয় । (How to use 3D Formula in MS Excel ? ). Course টি সম্পূর্ণ দেখতে "Advanced Excel Tutorial" Playlist টি সেভ করে রাখুন । Don't Forget To subscribe Career Development. Advanced Excel Tutorial - https://www.youtube.com/playlist?list=PL8FzFHtDnRdq2zJ9sGaVWb3ezwLhmiQTo Practice Sheet -https://docs.google.com/spreadsheets/d/1MQeN_Zio0TW__DKsTH1t6vUDewmMzukN/edit?usp=sharing&ouid=112467127323432164096&rtpof=true&sd=true Exercise file courtesy: Linkedin Learning A 3D formula is a formula that refers to the same cell (or range of cells) on multiple worksheets. The 3D formula "=SUM(Sheet1:Sheet4! A2)" can be used to add up the numbers in cell "A2" on 4 different worksheets. If you copy or insert a new worksheet after Sheet1 the reference will automatically include it. 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. #excel #namerange #namerangeinexcel