Skip to Main Content
Office 2021 All-in-One For Dummies
book

Office 2021 All-in-One For Dummies

by Peter Weverka
February 2022
Beginner content levelBeginner
800 pages
19h 1m
English
For Dummies
Content preview from Office 2021 All-in-One For Dummies

Chapter 5

Advanced Techniques for Analyzing Data

IN THIS CHAPTER

Bullet Using conditional formats to call attention to data

Bullet Sorting and filtering information in a worksheet list

Bullet Performing what-if analyses with data tables

Bullet 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 the sparklines say 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.

Seeing What the Sparklines Say

Maybe the easiest way to analyze information in a worksheet is to see what the sparklines say. Figure 5-1 shows examples of sparklines. In the form of a tiny line or bar chart, sparklines tell you about the data ...

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.
Start your free trial

You might also like

Office 2021 for Macs For Dummies

Office 2021 for Macs For Dummies

Bob LeVitus, Dwight Spivey
Microsoft Office 2021 – Das Handbuch

Microsoft Office 2021 – Das Handbuch

Rainer G. Haselier, Klaus Fahnenstich
The Frictionless Organization

The Frictionless Organization

Bill Price, David Jaffe

Publisher Resources

ISBN: 9781119831419Purchase Link