🛠️ Scheduled Maintenance | We’ll be undergoing scheduled maintenance and upgrades between 00:00 PST Jan 26th until 00:00 PST Jan 28th. There may be brief interruption of services in that period. We apologize for the inconvenience.

The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

What do you mean by “multi-layer calculations”?

What do you mean by “multi-layer calculations”?


Can you elaborate a bit on it or provide a simple example..

1 Answer

365 Team

Hi Fernanda!  
Great to have you in the course and thanks for reaching out!  
Great question!  
Multi-layered calculations refer to Excel.
What do we mean by a layer?   
Sort of a step of a calculation, that can have its own meaning and application.  
For instance, think of the creation of a Balance Sheet, Income Statement, a Cash Flow statement (in Accounting and Finance).
These three are stored on separate sheets, and carry different types of information. However, they are interrelated. So, as you fill certain cells in one statement, then Excel can automatically calculate:
1) the TOTAL value at the bottom of this statement
2) specific values in the second sheet
3) specific values in the thirds sheet.  
So, we express this as the capacity of Excel to do multi-layer calculations. They can be way more layers than that, depends on the example.   Hope this helps.
365 Team