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

