Part 4

Digging Data Analysis

IN THIS PART …

Use basic what-if analysis tools to predict the changes you have to make to achieve desired goals and avoid unwanted results.

Look at different possible scenarios for projected worksheet data.

Meet the most versatile summary tool — the pivot table — and its graphical counterpart, the pivot chart.

Visit www.dummies.com/extras/excel2019 for great Dummies content online.