Microsoft Office Inside Out (Office 2021 and Microsoft 365)

Chapter 16

Validating 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 will cut down on 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 ...