Consolidation Worksheet. First of all, insert a new worksheet and name it “total” (or whatever you want) and select cell a1 in that worksheet. Obtain in a simplified way the total.
Consolidation worksheets and online exercises. Prepare the consolidation worksheet entries for the preparation by zack ltd of its consolidated financial statements at 30 june 2016. Use the excel consolidated balance sheet model spreadsheet to enter your company data, and let the formulas do all the work and calculations for you.