Analyse data using scenarios and goal seek

• Analysing data is the process to extract useful information for making effective decisions
• You need to check the following before consolidating data.

  • Open each sheet in the spreadsheet and check that the data types must match which you want to consolidate.

  • Match the labels from all the sheets which are used for consolidating.

  • Enter the first column as the primary column on the basis of which the data is to be consolidated.
• Choose Data > Consolidate option that will open Consolidate dialog
• the default function is sum
• Group and Outline in Calc is used to create an outline of the selected data and can group rows and columns together so that one can collapse (-) to hide it or expand (+) it using a single click on it.
• The Subtotal tool in Calc creates the group automatically and applies common functions like sum, average on the grouped data.
• Menu for subtotals:

  Data>Subtotals
• What-if scenario is a set of values that can be used within the calculations in the spreadsheet
• What if scenario is used to explore and compare various alternatives depending on changing conditions.
• For scenarios, choose tools menu
• What-if tool uses Data > Multiple Operations and

  is a planning tool for what-if questions
• Goal seek helps in finding out the input for the specific output.
• Place the cursor in the formula cell, choose Tools > Goal Seek.