Lesson 6: Excel Table Overview

Learn How to use Table in Microsoft excel.

This video is a part of free Excel Training Singapore, where I show you how to use Table in Microsoft excel from the basics and also cover a lot of advanced Features.

Most times people confuse between data arranged in tabular form and tables in excel. These might sound similar but are very different in excel. Tables in excel are a collection of boxes containing similar or same kind of data. There are many features of Microsoft Excel tables that such as table slicers, structured reference and many others that add to the utility of Microsoft Excel tables.

Benefits of tables in Microsoft Excel –

The benefits of using Microsoft Excel tables are many, some of which are mentioned below –

• Microsoft Excel tables allow users to convert a list of data into formatted excel table having well structured forms of rows and columns.
• Microsoft excel tables enables users to carry on variety of tasks onto the table data without effecting the other data in the worksheet.
• Microsoft Excel tables comes with various features such as sorting and filtering to make data more systematic and presentable. Microsoft excel tables Comes with the feature of color variations that allows to differentiate between various types of data.
• Another benefit of using Microsoft Excel tables is that it makes data entry easy and allows structured reference of cells to move from one cell to another very easily despite the number of rows and column in the row.
• Microsoft Excel tables have the feature that enables easy addition and deletion of rows and columns by a single click of mouse. Moreover, it never hides the header of the data no matter how long the rows be to enable easy work experience.

Learn how to convert tabular data into a Microsoft Excel table.

There are a number of features that Microsoft excel allows you to perform when your data is in the format of Microsoft tables. To learn how to convert tabular data into Microsoft Excel table, follow the following steps –

• Select the entire tabular data that you want to convert just by right clicking the mouse key over the entire data
• Click on insert option in the task bar. You will have the option table. Click on that. A dialogue box appears that shows the address of the entire data to be converted and asks you to confirm the data selected
• If your data consists of headers, tick the box that asks for headers and click OK
• The entire data gets converted into a table, consisting of headers in various colors

How to apply changes to data in a Microsoft Excel table.

Microsoft excel is smart enough to detect any pattern of change required to a type of data and automatically applies the change to the entire set of data. To learn how to properly be able to operate this function, follow the following mentioned steps –

• Let’s assume, that one more column is added to the same table called sales target. The sales target Happen to be 10% higher than the previously mentioned amount.
• Type “equals to” in the first cell of the sales target. Then, select the corresponding amount
• You’ll notice “@amount” starts to show in that cell. That’s how excel refers to data in a table known as the structured reference.
• Type your desired increment which is 1.1 in the sales target cell starting with an “*” symbol. Press enters.
• You’ll notice that the entire column gets filled with the increased value of the data

How to remove duplicates using contextual tabs?

Contextual tabs are those tabs that get activated or visible only when you click inside the table or any chart or any pivot table. There appears a design option in the tab of the Microsoft excel work sheet. The design tab automatically disappears when you click on the working area outside the table. To learn how to remove duplicates from the table, follow the following mentioned steps –

• Simply right click on the corner of the table and drag it down to select the entire table.
• Click on remove duplicates option in the tab bar above.
• A dialogue box pops up that asks you the fields from where you wish to remove the duplicates. Just select those options and click OK
• All duplicates from the selected column will be removed.

Learn how to work properly with Microsoft Excel tables now!

Microsoft Excel tables not only help to organize data in a professional manner but also helps to save a lot of time and efforts by providing special features on those tables. To lean how to work with them join a Microsoft Excel Class Singapore now!

In this video, you’ll learn how to use tables in Microsoft Excel.

Excel tables are interesting, especially if you plan to work with bulk data/dashboards/models.

And now that new tools (such as Power Query and Power Pivot) are available, it has made Excel tables even more powerful.

In this video, I cover the following topics:

• Creating an Excel Table
• Excel Table features
• Structured references
• Table slicers
• Note that table slicers became available only from Excel 2013

This video is a part of Excel Training Singapore where I show you how to use Excel from the basics and also cover a lot of advanced topics.