MS Excel: Convert Data Into Table [Video Included]

MS-Excel-Convert-Data-Into-Table-Video-Included

If you are new to microsoft excel and trying to learn excel basics, you should read this blog. In this blog, I am going to explain how to convert ordinary data into a good looking table in excel step by step.

Tables in ms excel not only look nice but also make your data look way more organized. So if you are targeting to represent your research or data professionally to your client, try converting it in tables. I am sure your client will be impressed.

(I have also added the video tutorial at the end of this blog for you to understand the entire process in a better way + Tips to expand table and sort table data in alphabetical order)

Let’s take a look at how to convert Data into Tables in microsoft office excel:

Step 1: Go to your excel spreadsheet and populate data in different columns.

MS-Excel-Convert-Data-Into-Table

Step 2: Select your data.

MS-Excel-Convert-Data-Into-Table

Step 3: Upon selecting the data you will notice an icon at the bottom right corner of your selection. Click on that to open the icon menu.

MS-Excel-Convert-Data-Into-Table

Step 4: Click on TABLESMS-Excel-Convert-Data-Into-Table

Step 5: Clicking on Tables will prompt you to 2 Options. Click on Table.

MS-Excel-Convert-Data-Into-Table

Step 6: As soon as you click on the table, it will convert your data into a table with added headers to it. Your data should look like this

MS-Excel-Convert-Data-Into-Table

Step 7: Update Column Headers as per your preference. I replaced Column 1 with Connect with me and Column 2 with Handles. (These are my social media handles, please do connect with me)

MS-Excel-Convert-Data-Into-Table

Step 8: Watch the full video attached below for a brief tutorial + Tips on how to expand table or sort table data in alphabetical order.

For more ms excel tutorials subscribe my YouTube Channel:  Click here to subscribe

Related Articles

MS Excel / Word – 2 Ways To Change Author Name

Microsoft Excel: How To Merge Data Of 2 Or More Columns

30 Keyboard Shortcuts To Create Symbols

Leave a Reply

avatar
  Subscribe  
Notify of