Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    Step 6  Click on the OK button.

                     Subtotal Outline

                     When you use the Subtotals tool, Calc inserts an outline to the left of the row number column.
                     This outline represents the hierarchical structure of your subtotals and can be used to hide or
                     show data at different levels in the hierarchy using the numbered column indicators at the top of
                     the outline or the group indicators, denoted by plus (+) and minus (-) signs.

                     To remove the outline feature from the sheet at any time, go to Data to select Group and
                     Outline and choose the Remove Outline option. To apply again, go to Data to select Group
                     and Outline and choose the AutoOutline option.

                           ANALYSING DATA USING PIVOT TABLES

                     Pivot Tables help you summarise and analyse data by arranging it in rows and columns. They
                     make it easier to view and compare data.

                     Pivot Tables have the following advantages or uses:
                         ✶  Summarises large data quickly.

                         ✶  Helps to compare data easily.
                         ✶  Allows dynamic data filtering.

                         ✶  Organises data in rows and columns.
                         ✶  Provides clear insights and trends.

                     To create a Pivot Table in Calc, follow the given steps:

                     Step 1  Select the range of cells or table where you want to use for the Pivot Table.

                                                                                            Using Calc as Database       53

| 50 51 52 53 54 55 56 57 58 59 60 |