Page 18 - Computer - 8

2 Databases in Excel

Pre-Processing

• Working with Databases in Excel • Displaying Subtotals
• Data Validation • Goal Seek
• Scenario Manager • Pivot Table

A database is an organized collection of structured information, or data, typically stored electronically
in a computer system. Data within most common types of databases is typically organised in rows and
columns. The data can then be easily accessed, managed, modified, updated, controlled, and organised.

WORKING WITH DATABASES IN EXCEL
Excel is not a database management system but still provides several features that let you work with
data and manipulate it in different ways. Excel databases provide a simple way to analyse data (such as
sales numbers and forecasts), look at various calculations, and compare different data sets.

Creating a Database Table
A Table in Excel is a simple way to organise
data in the form of a database. Tables enable
sorting, filtering, and presenting data in a
lucid manner. Creating a database table is
similar to creating any spreadsheet in Excel.
The important point to remember is that
each column of values in the data must have
a heading.

To create a database table in Excel: 1
1. Create a worksheet as shown in the
image.

2. On the Insert tab, click the Table button in the Tables group.

The Create Table dialog box appears.

3
2
3. Specify the cell range that holds the data in the required data.
4 Mark the My table has headers check box.

16