July 2007
Beginner
256 pages
7h 29m
English
Content preview from Excel® 2007: Top 100 Simplified® Tips & TricksBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 5. Explore the Patterns in Your Data
Excel offers you much more than a way of keeping track of your data and doing calculations. It also provides tools to analyze your data and thus to understand it better and make better decisions. In this chapter, you learn about a range of tools that can give you rich insights into your data.
One of the most useful tools, the PivotTable, is also one of the least understood. Similar to cross-tabulation in statistics, a PivotTable shows how data is distributed across categories. For example, you can analyze data and display how different products sell by region and by quarter. Alternatively, you can analyze income distribution or consumer preferences by gender and age bracket. Excel makes it easy for you to answer useful questions about your data.
This chapter also introduces Excel’s statistical functions. These statistics were once available only through large, expensive statistical software packages. You will learn to use descriptive statistics to characterize your data and to explore associations between data series by using the correlation function. For the statistically adept, Excel also includes more advanced functions.
Finally, you learn to do two related analytical tasks: what-if analysis and goal seeking. With what-if analysis, you vary an input to find how it affects a result. With goal seeking, you start with a goal and try to achieve it by varying a single factor.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.