- Data analysis with excel or organizing data with excel how to#
- Data analysis with excel or organizing data with excel series#
For all-text ranges, the options allow you to identify duplicates, unique values, or entries that include a specific text string. We provide in-depth details about these analytical options in the remainder of this chapter.įormatting The options available here depend on whether your selection contains only text or whether it also includes numbers. The following list briefly describes each of your options and what you should and shouldn’t expect from each one using Quick Analysis. If you like what you see, click to apply the selected option otherwise, move the mouse pointer to another option (or click a different category). When you let the pointer hover over an option, the selection changes to preview the effect of that option. To use the Quick Analysis tool, choose a category and then move your mouse pointer over any of the options available beneath the headings.
Each of the five headings at the top of the box leads to a selection of options that vary slightly depending on the selection.įigure 13-1 The Quick Analysis tool consolidates five common options in one place and offers live previews of their effects. If you choose the latter option, you can select a single cell and Excel will expand the selection to include the current region.)įigure 13-1 shows the Quick Analysis tool in action. (You can also press Ctrl+Q, or right-click and click Quick Analysis on the shortcut menu.
To get started, select a range (at least two cells containing data) and click the Quick Analysis tool that appears in the lower-right corner of the selection. You can still create charts, insert tables, and add totals manually, but this tool dramatically simplifies the process. The single most important new feature of Excel 2013 is the Quick Analysis tool, which puts formatting, charting, tables, and other options in an easy-to-access place. The art is in arranging and fine-tuning the colors, shading, shapes, labels, and other pieces of your chart so that they tell the story most effectively.
Data analysis with excel or organizing data with excel series#
The science involves recognizing which series of data on a worksheet represent the patterns you’re trying to describe.
Data analysis with excel or organizing data with excel 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. Using conditional formatting to highlight cells based on their content Using tables to organize and analyze data
0 kommentar(er)
