Before
you continue the Excel 2016 from Scratch series with exercises
on advanced visualization, we recommend that you try this
exercise.
The Excel features Peter Kalmström shows in the two demos
below have been described earlier in this series, and here
you have a chance to see if you remember them – and
to refresh your knowledge if you don't.
Content
This is shown in the first demo below:
How to convert a range of cells to a table.
How to give the table a custom name.
How to add a totals row that summarizes the values
in the column where the cursor is placed.
How to add data bars to the cells in a column.
How to visualize the table data in a chart.
This is shown in the second demo below:
How to create a new sheet and give it a name.
How to fetch data from another sheet and add it
to a formula.
How to format a range of cells as a table.
How to add data bars to the cells in a column.
How to visualize the table data in a chart.
Peter uses Excel 2016 for his demo, but the Excel visualization
tools are the same for later versions of Excel.
Before
you continue the Excel 2016 from Scratch series with exercises
on advanced visualization, we recommend that you try this
exercise. 
