Home >Tips >Excel 2016 from Scratch >Visualization F, 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.

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.












Follow kalmstrom.com on LinkedInFacebook or Twitter!


back icon next icon
Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved