Excel 2019 Bible

E

xcel is a superb data-analysis tool—if

you know how to extract the informa-

tion that you really need. In this part,

you’ll learn how to obtain, clean up, and

analyze data in Excel. As you’ll see, many

of the data-analysis capabilities in Excel are

both surprisingly powerful and easy to use.

IN THIS PART

Chapter 25

Importing and Cleaning Data

Chapter 26

Using Data Validation

Chapter 27

Creating and Using Worksheet Outlines

Chapter 28

Linking and Consolidating Worksheets

Chapter 29

Introducing PivotTables

Chapter 30

Analyzing Data with PivotTables

Chapter 31

Performing Spreadsheet What-If Analysis

Chapter 32

Analyzing Data Using Goal Seeking and Solver

Chapter 33

Analyzing Data with the Analysis ToolPak

Chapter 34

Protecting Your Work

Part IV

Managing and Analyzing

Data

Excel® 2019 Bible, First Edition. Michael Alexander, Dick Kusleika and John Walkenbach.
© 2019 John Wiley & Sons, Inc. Published 2019 by John Wiley & Sons, Inc.