What is consolidating data? Write the steps to consolidate data and calculating subtotals.
Answers
Answered by
1
Answer:
Step 1: Open all files (workbooks) that contain the data you want to consolidate. Step 2: Ensure the data is organized in the same way (see example below). Step 3: On the Data ribbons, select Data Tools and then Consolidate. Step 4: Select the method of consolidation (in our example, it's Sum).
Similar questions
Chemistry,
26 days ago
Geography,
26 days ago
Political Science,
26 days ago
English,
9 months ago
Math,
9 months ago