Exhibit 16
You can choose to see the report in a side-by-side Scenario Summary format or a PivotTable format.
Exhibit 17
Excel generates the Scenario Summary report automatically.
Exhibit 18
Goal Seek calculates the variables that will achieve your goal.
Exhibit 19
Enter the data so Excel can calculate how to reach the goal.
Exhibit 20
Goal Seek automatically reports the goal-seek answer.


2019 State of Financial Reporting Survey

We surveyed nearly 600 finance and accounting professionals on their month-end close and reporting processes. See the results.


What RPA is and how it works

Robotic process automation is like an Excel macro that can work on multiple applications, says Danielle Supkis Cheek, CPA. RPA can complete routine, repetitive tasks such as data entry, freeing up employee time from lower-level chores.