The science involves recognizing which series of data on a worksheet represent the patterns you’re trying to describe.
#Where's the quick analysis tool in excel 2013 how to
In this chapter, we look at Excel’s extraordinarily versatile charting engine and explain how to communicate a situation or a series of events in a single visual impression, with only a few well-chosen words required.īuilding a visually compelling, information-rich chart from a series of numbers and dates is part science, part art. When that’s not enough to tell a story, you can turn a collection of data into an elegant, information-based graphic and let it do the talking. You can use conditional formatting to add colors and custom text treatments, and you can make at-a-glance analysis easier by inserting tiny trend lines and markers called sparklines. We also explain how to highlight trends and patterns in a sea of gray data to make it more interesting. In this chapter, we look at the many options you have for entering, storing, sorting, filtering, cross-tabulating, and summarizing that data. 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. 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. Using sparklines to visualize trends within a rangeĮXCEL is no one-trick pony.
![where where](https://www.techonthenet.com/excel/questions/images/developer_tab2013_001.gif)
![where where](http://theapptimes.com/wp-content/uploads/2013/02/Quick-Analysis_thumb.png)
Using conditional formatting to highlight cells based on their content Using tables to organize and analyze data