Tables Group properties
Let’s switch gears and move back to the table group. This group will let you analyze your data using tables and pivot tables. We will cover pivot tables in an advanced video training, so let’s try the table command.
Utilizing the table feature, you can sort filter and format portion of your workbook. This gives you the ability to manipulate a subset of the data in an Excel Sheet.
You will notice that as you select the table, you will be provided the Table Tools Menu which includes the Design Tab. This is one of those contextual tabs that only show up when you are working with a certain object. Using this tab you can change the layout and formatting of your table.
We would like to add some bright color to our table so let us browse to the Table Styles group. We will choose table style Medium 3 from our styles gallery. Notice as you move your mouse around, you will get a live preview of the new graphic settings.
The last thing I want to talk about the tables is Sorting and Filtering capability. If I want to sort the Amount (Column C) from highest to lowest, I can click on the dropdown and choose sort largest to smallest.
Now all the data in our table has been sorted from the highest to lowest expense in order: mortgage, car payment, credit cards etc. If you are satisfied with all the changes, go ahead and save the file.
Pivot tables allow you to quickly summarize and analyze large amounts of data in lists and tables–independent of the original data layout in your spreadsheet–by dragging and dropping columns to different rows, columns, or summary positions.
We will discuss in details about Pivot Table in Module -6.