Page 60 - modular4.0
P. 60

Chapter Profile
                 6                            Chapter Profile                         Form in Excel


                                                                                        Using Form in Excel
                                                                                            Sorting Data
                                                                                             Filtering Data
                                         Excel as                                            Conditional Formatting
                                                                                              Using Data Validation

                                      Database                                                  Using Subtotal Command
                                                                                                 Using Pivot Table










                  As you  know  that the  Excel 2019  is used  to store data. Excel 2019  allows you  to use  an Excel
                  workbook as a database. A database implies that organising the data in a manner which helps to
                  store and retrieve a large amount of data efficiently. The database concept is one of the oldest ways
                  to maintain records in a conventional file-oriented data collection system. For example, students
                  record in school, items record in shop and employees record in an organisation are some examples
                  of database.
                  A database contains data in the form of rows and columns. A column is called a Field. It contains only
                  a single piece of data. Every column has a name like Employee Code, Employee Name, Department,
                  etc. A set of values for the fields is called a Record.










                               Field








                             Record







                                                             Data in Excel Worksheet

                         FORM IN EXCEL


                  One of the most important features of Excel 2019 is form. A form is a window used to display or
                  enter a record in an Excel worksheet. It provides various controls like text box and buttons to enter
                  and update data.



                58   Modular (Ver. 4.0)-VII
   55   56   57   58   59   60   61   62   63   64   65