Skip to main content

Posts

Showing posts from March, 2021

New Article

How to SUM by matching partial text in Excel

How to add Zero before numbers in Excel 2016

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.

How to make a drop down menu in Excel 2016