{"id":18783,"date":"2013-05-08T15:53:14","date_gmt":"2013-05-08T10:23:14","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=18783"},"modified":"2024-04-12T14:24:23","modified_gmt":"2024-04-12T08:54:23","slug":"consolidate-data","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/consolidate-data\/","title":{"rendered":"Consolidate Data"},"content":{"rendered":"

Consolidate Data<\/strong><\/h4>\n

Consolidate data. Govt of India Certification for Excel . Get Certified and improve employability. Certification assesses candidates in excel 2003 concepts<\/p>\n

    \n
  1. Set up the data to be consolidated on each separate worksheet.<\/li>\n<\/ol>\n

    How to set up the data<\/p>\n

      \n
    1. Click the upper-left cell of the area where you want the consolidated data to appear in the master worksheet.<\/li>\n<\/ol>\n

      NOTE<\/strong><\/span>\u00a0\u00a0\u00a0 Make sure that you leave enough cells to the right and below this cell for the consolidated data. TheConsolidate\u00a0command populates the area as needed.<\/p>\n

        \n
      1. On the\u00a0Data\u00a0tab, in the\u00a0Data Tools\u00a0group, click\u00a0Consolidate.<\/li>\n<\/ol>\n

        \"63\"<\/a><\/p>\n

          \n
        1. In the\u00a0Function\u00a0box, click the\u00a0summary function<\/a>\u00a0that you want Microsoft Office Excel to use to consolidate the data.<\/li>\n
        2. If the worksheet is in another workbook, click\u00a0Browse\u00a0to locate the file, and then click\u00a0OK\u00a0to close the\u00a0Browsedialog box.<\/li>\n<\/ol>\n

          The file path is entered in the\u00a0Reference\u00a0box followed by an exclamation point.<\/p>\n

            \n
          1. Type the name that you gave the range, and then click\u00a0Add. Repeat this step for each range.<\/li>\n
          2. Decide how you want to update the consolidation. Do one of the following:\n