O'Reilly logo

Office 2016 All-In-One For Dummies by Peter Weverka

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5

Advanced Techniques for Analyzing Data

In This Chapter

arrow Generating a sparkline chart

arrow Using conditional formats to call attention to data

arrow Sorting information in a worksheet list

arrow Filtering a list to find the information you need

arrow Using the Goal Seek command to produce formula results

arrow Performing what-if analyses with data tables

arrow 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 what sparklines are 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 Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required