June 2013
Intermediate to advanced
912 pages
27h 36m
English
Sorting out your data analysis options
Using tables to organize and analyze data
Using conditional formatting to highlight cells based on their content
Using sparklines to visualize trends within a range
EXCEL is no one-trick pony. Yes, the program works wonders with number-crunching tasks, but its rows and columns are also tailor-made for managing data that goes beyond basic bean counting. With minimal effort, you can keep address lists and membership rosters, track temperatures and rainfall, monitor stock prices, and record your performance in whatever sport or hobby you happen to fancy.
In this chapter, we look at the many options you have for entering, ...