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.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
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”?

0
Votes
1
Answer

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

1 Answer

365 Team
0
Votes

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.
 
Best,
365 Team