Microsoft Excel 2019 Step by Step, First Edition

16 Create forecasts and visualizations

In this chapter

• Create forecast worksheets

• Define and manage measures

• Define and display key performance indicators

• Create 3D maps

Practice files

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

The business intelligence tools built into Excel 2019 greatly extend the app’s analytical and visualization capabilities. For example, although you have always been able to forecast future data based on current trends, you can now use an advanced technique called exponential smoothing to give greater weight to recent values instead of considering all historical data in the same light.

You can also use the Excel Data Model ...