A Drop of Excel - 05 | How to create a Formula across Sheets and or Files in Excel
Many times you have data in multiple sheets instead of only 1 sheet.
You want to do some calculations based on data in these multiple sheets. This is where you will see the need to create formulas across sheets in Excel.
Sometimes you may also need to carry out calculations on data across multiple Excel files.
In this video, we will learn both of them, in a very simplified explanation.
Example file link
https://drive.google.com/file/d/1prRr...
\ Previous video: • A Drop of Excel - 04 | How to create ...
/ Understanding of the data being used in the examples: • A Drop of Excel | Understanding the d...
Related Videos/Posts
18 Most Useful Excel shortcuts -- • 18 Most Useful Excel Shortcuts
