Home >Tips >Excel 2016 from Scratch >Visualization E – Quick Analysis, data bars kalmstrom.com site map icon Site map  

Excel 2016 from Scratch Exercise

Visualization F – Repetition

An Excel tutorial by Peter Kalmstrom

Excel 2016 iconBefore 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.

Exercise

Please download the Excel file Peter uses in the demo and try the exercise before you watch the demos.

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 earlier versions of Excel.











Always the latest news in the kalmstrom.com blog


Follow kalmstrom.com on LinkedIn Facebook, Google+  or Twitter!



back icon next icon