CO
Upload

Loading...

You're viewing YouTube in English (US).
Switch to another language: | View all
You're viewing YouTube in English.
Switch to another language: | View all

Excel Magic Trick #184: Setup Database in Excel

417,733

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Jan 2, 2009

See how to create a simple database in Excel using the List or Table feature.
A simple database can be created in Excel using the Excel 2003 "List" feature or the Excel 2007 "Table" feature.
Fields names must be in first row (no blanks).
Records are in rows (no blanks).
Other data in the sheet cannot be next to the Table/List (at least one blank row or column between other data and the Table/List
Keyboard shortcuts: Excel 2003 List: Ctrl + L. Excel 2007 Table: Ctrl + T.
The ranges are dynamic: formulas, pivot tables, charts will all automatically update

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...