Fiverr Tutorial 4: How to create a Database or Datatable in Microsoft Excel?

In this tutorial, you will learn how to create a Database or DataTable in Microsoft Excel. Please follow these simple steps to create your Microsoft Excel Database or Datatable.

Step 1: Open Microsoft Excel Workbook

Step 2: Enter below data

Image 1: Sample data

 

Step 3: Select all data

Step 4: Click on Insert | Table

Step 5: A dialog box will appear where the data range was automatically selected based on your data.

 

Image 2: Insert | Datatable

 
Step 6: Place a check mark on "My table has headers".

 

Image 3: Create "Ok"

 Step 7: Click on "Ok".

Your current data is now converted to Database or Datatable.