Chapter 5
Advanced Techniques for Analyzing Data
IN THIS CHAPTER
Generating new tables and charts that analyze data
Sorting and filtering information in a worksheet list
Performing what-if analyses with data tables
Examining data with a PivotTable
This chapter offers a handful of tricks for analyzing the data that you so carefully and lovingly enter in a worksheet. Delve into this chapter to find out how to get insights into your data and how to manage, sort, and filter data in lists. You also discover how conditional formats can help data stand out, how the Goal Seek command can help you target values in different kinds of analyses, and how you can map out different scenarios with data by using one- and two-input data tables. Finally, this chapter explains how a PivotTable can help turn an indiscriminate list into a meaningful source of information.
Getting Quick Analyses from Excel
When you’re in a hurry to analyze data in a worksheet, take advantage of the Analyze Data command, sparklines, and forecast sheets. These tools can help you examine data closely, recognize trends, ...
Get Office 365 All-in-One For Dummies, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
