Start course

Additional information


If I have a table of data where I have a heading row, I can go to my insert tab and select table. It will recognise where my table is, understand that I have a header row and then I can click OK. My table is now being created. A new table tools design tab will appear. Here I can change the style of my table for a different look and feel. And I can change the format of my table by changing the formatting on the first column, as you can see, that's going bold there on the left and similarly for the last column. I can also show banded rows, like so, or a place with banded columns or show both. There is also a feature called total row. If I click total row, we're brought to the bottom of our table. This is around 154 rows.

You can also notice that our columns, which were originally labeled A/L have been replaced by the headings of the table at the top there. Also notice that I'm able to do filtering and sorting features still from these column headers. Now the total row at the bottom of this table at the moment shows that I have 152 items in this list as the last column automatically gets a total dropdown arrow. However, every other column can also have a total. For example, if I click salary, I can click the dropdown arrow, pick some and work out the grand total, salaries. If I go to age, I can hit the dropdown again and work out the average age of my employees. If I go to hours per week, I can click the drop down arrow, and then I can count to tell me how many people I have in my list. Now what's very interesting here about the total row is if I decide to sort by or filter by a particular column, then those totals will change. For example, if I'd only like to show people in IT, I select IT, and you will see that my table reduces to a small size. And you can see the number of people, average age and salary have all changed to represent the filter data. 

We have now removed the filters from the table. The table can be extended to add additional columns and rows simply by typing new information to the right of the last column. Notice that I've just typed in pension contribution and the table has automatically expanded to include this new column. What's also good about a table is the way that we can create a function that gives us a natural wording of the data that we've got. I'm going to create a simple if function that says, "If you have a pension, this pension contribution will be 2% of your salary." So I'm going to say if, select the cells for your pension, notice that it actually says the word pension and not the cell reference, is equal to yes. Then what I want to do is say that your salary is multiplied by 2%. Otherwise you haven't got a pension contribution, so it will be zero. And the function is complete. Now, once we press enter, the table is very clever. And once you hit enter, the table will ensure that the content is populated for every row in that column.

About the Author
Learning Paths

A world-leading tech and digital skills organization, we help many of the world’s leading companies to build their tech and digital capabilities via our range of world-class training courses, reskilling bootcamps, work-based learning programs, and apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.