Consolidate data most likely to be useful in the preparation of reports or periodic data aggregation.Let’s be more practical today and learn some advanced accounting techniques.Prepare consolidated statement of financial position of Mommy Group as at 31 December 20X4.Measure NCI at its proportionate share of Baby’s net assets.Therefore, when a group controller calls you every five minutes to remind you the consolidation package, you’ll know why!In our case study, combined numbers looks as follows: Of course, there are some strange and redundant numbers, for example both Mommy’s and Baby’s share capital, but we haven’t finished yet!For starters, it is noteworthy that the tables are not identical and there are even different sizes. Consolidation of the sales table in Excel start with ribbons.
Then we need to recognize any non-controlling interest and goodwill.The result looks like this: On the left side shows the digits 1 and 2 and pluses.We also see that the individual lines are not in sequence as if some rows were hidden.Select the location where you want the summary table and click Consolidate.You get the following dialog box: You can select up to 11 different functions for data consolidation. The tables contain the label in the top row and left column, then select the appropriate check boxes in the dialog box.
If you do not need as this level of detail, you can develop only a plus, eg sales data Salesman2.