Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 70 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 70

    CONSOLIDATING DATA
                      Data consolidation refers to collecting and integrating data from multiple spreadsheets or sheets

                      into a single/master spreadsheet. During this process, the ‘Data Consolidation’ function takes
                      data from a series of sheets or spreadsheets and summarise it into a single spreadsheet.
                      This tool is most useful when you are working with the same data over and over.

                      Before consolidating data, ensure the following:
                           Open each sheet in the spreadsheet and verify that the data types you want to consolidate
                          match.
                          Ensure the labels used for consolidation are consistent across all sheets.

                          Use the first column as the primary column for consolidating the data.
                      To consolidate data, we are using sheets for District A, District B and District C, which contain the
                      cell ranges for the total consumption of drinks in the months of January, February, March, April

                      and May. Also, create a sheet named Consolidate Data.
                      Sheet of District A

                      Sheet of District B

                      Sheet of District C

                      To consolidate the data, follow these steps:
                      Step 1    Click on the Data menu.

                      Step 2    Select Consolidate option.
                                A Consolidate window appears on the screen.

                     68     Premium Edition-VII

| 65 66 67 68 69 70 71 72 73 74 75 |