Home
>
Tips
>
Excel 2016 from Scratch
>
Visualization E, Quick Analysis, data bars
Site map
Excel 2016 from Scratch Exercise
Visualization E, Quick Analysis, data bars
An Excel tutorial by Peter Kalmstrom
Most people think it is easier to understand data when data is visualized, and Excel can help with that in many ways.
In this demo in the Excel 2016 from Scratch series, Peter Kalmstrom shows how to use data bars and the Quick Analysis tool.
Exercise
If you want to try the exercise yourself, please
download the Excel file Peter uses in the demo
.
Content
This is what Peter shows in the demo below:
How to convert a range of cells to a table.
How to
sort column data
in a table ascending.
How to
filter column data
in a table to only show values less than a certain value.
How to add conditional formatting in the form of data bars to a column.
How to reach and use the Quick Analysis.
How to
reach the Rules Editor
to create custom formatting.
Peter uses Excel 2016 for his demo, but the Excel visualization tools are the same for earlier versions of Excel.
Tweet
Follow kalmstrom.com on
LinkedIn
,
Facebook
or
Twitter
!
Products
Buy
FAQ
Services
Tips
Books
Contact
About Us
Tools
Security and integrity
Copyright Kalmstrom Enterprises AB All rights reserved
Most
people think it is easier to understand data when data is
visualized, and Excel can help with that in many ways.
