Microsoft Excel 2019 Step by Step, First Edition

8 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

Practice files

For this chapter, use the practice files from the Excel2019SBS\Ch08 folder. For practice file download instructions, see the introduction.

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 ...