Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    Step 8  Click on the OK button to generate the Pivot Table.

                     The Pivot Table will be created, displaying Item Name in the Row Fields, Brand in the Column
                     Fields and the Price in the Data Fields. This allows you to see how data is distributed across
                     different items and companies. You can apply filters to refine your data further.

                            Restart

                           The Form is a tool that makes it easier to add, edit and remove rows in tables within
                          spreadsheets.
                           Calc can arrange the selected data in ascending or descending order.

                          Multiple Sort is used to apply sorting on more than one column in selected range on
                          different criteria.

                          Calc  can  apply  filters  to  show  only  required  information  while  hiding  the  unwanted
                          information.
                          The filters once applied can be easily removed.
                          Validity is used to restrict users from entering specific values in a cell or range of cells.

                          Calc offers the Subtotals tool to create subtotals for data arranged in labelled columns.
                          Pivot Tables help you summarise and analyse data by arranging it in rows and columns.
                          They make it easier to view and compare data.

                                                                                            Using Calc as Database       55

| 52 53 54 55 56 57 58 59 60 61 62 |