Microsoft Office 2019 Inside Out, First Edition

Chapter 16Validating and analyzing worksheet data

Taking advantage of data validation

Performing a what-if analysis

Using goal seek, solver, and forecast sheet

Excel provides you with powerful capabilities for manipulating, analyzing, and visualizing worksheet data. However, even the most elegant charts and data analysis won’t mean much if you have incorrectly entered data in a worksheet.

In this chapter, we look at Excel’s data validation features. You can create data validation rules that greatly cut down the possibility of data being entered into a worksheet incorrectly.

We also discuss Excel’s tools for analyzing worksheet data. We look at the data table feature and the Scenario Manager, which both provide you with the ability to do a what-if ...