[go: up one dir, main page]
Scribd
Upload
4 views2 pages

B Ing

The document provides a step-by-step guide on how to use Microsoft Excel as a simple database for managing data like customer lists and inventory. It covers setting up data, entering information, using filter and sort features, applying data validation, utilizing formulas, and saving or exporting data. Following these instructions allows users to effectively manage and analyze information within Excel.

Uploaded by

yuviskn
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views2 pages

B Ing

The document provides a step-by-step guide on how to use Microsoft Excel as a simple database for managing data like customer lists and inventory. It covers setting up data, entering information, using filter and sort features, applying data validation, utilizing formulas, and saving or exporting data. Following these instructions allows users to effectively manage and analyze information within Excel.

Uploaded by

yuviskn
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Name:Imam Sholihin

Nim:3202402080

Class:MIF 2B

How to Use Excel as a Database

Microsoft Excel can be used as a simple database to manage data such as


customer lists, inventory, or financial reports. Follow these procedural
steps to use Excel as a database:

1. Opening and Setting Up Data

Open Microsoft Excel.

Create a new worksheet by pressing Ctrl + N or selecting File > New.

Define the columns to structure your data, for example:

Column A: ID

Column B: Name

Column C: Address

Column D: Phone Number

2. Entering Data

Click on the first cell in the appropriate column.

Type the data according to the category.

Press Enter to move to the next row.

Repeat until all data is entered.

3. Using Filter and Sort Features

Select the entire dataset, including column headers.

Click the Data tab and select Filter to filter data based on specific criteria.

To sort data, click the Data tab, choose Sort, and set sorting based on the
desired column.

4. Applying Data Validation

Select the cell or column you want to validate.

Click the Data tab and select Data Validation.


Choose the type of validation, such as numbers, text, or a dropdown list.

5. Using Formulas and Functions

Use formulas like SUM to calculate totals, AVERAGE for averages, or


VLOOKUP to search for data.

Example of SUM function:

excel

Salin kode

=SUM(B2:B10)

Example of VLOOKUP to find data based on ID:

excel

Salin kode

=VLOOKUP(101, A2:D10, 2, FALSE)

6. Saving and Exporting Data

Click File > Save As to save the file in .xlsx or .csv format.

To export data to another database system, use CSV format for


compatibility with MySQL, PostgreSQL, or other database management
systems.

By following these steps, you can effectively use Excel as a simple


database to manage and analyze information.

You might also like