Microsoft Office 2019 Step by Step, First Edition

9

Analyze alternative data sets

In this chapter

• Examine data by using the Quick Analysis Lens

• Define an alternative data set

• Define multiple alternative data sets

• Analyze data by using data tables

• Vary your data to get a specific result by using Goal Seek

• Find optimal solutions by using Solver

• Analyze data by using descriptive statistics

When you store data in an Excel 2019 workbook, you can use that data, either by itself or as part of a calculation, to discover important information about your organization. You can summarize your data quickly by using the Quick Analysis Lens to create charts, calculate totals, or apply conditional formatting.

The data in your worksheets is great for answering “what-if” questions, such as “How much money ...