Aggregation Exercise 1

In this exercise we want to consolidate a number of buildings we own into a total, but we may want to sell or buy some buildings and we don’t want…

Adding cells by moving sheets around

When you build financial models, you often need to be able to aggregate a number of sheets or else do some consolidation of sheets. The common way is just to…

OFFSET

The OFFSET function is a great way to get Excel to look at different areas of your spreadsheet based on some general rules. Watch the video clip below and then…
We need to create a formula in the yellow…