bry6_10


TECHNOLOGY WORKSHOP
 
Exhibit 6
The underlying formula in B16 provides the results of the calculations.
Exhibit 7
Type in the words “Interest Rate” (with quotation marks) to label the cell where the rates will be displayed.
Exhibit 8
The underlying formula in B16 remains, but the cell is identified as Interest Rate.
Exhibit 9
The function must be told where to find the variable data.
Exhibit 10
With a few mouse clicks, the spreadsheet displays the results of the calculations.

SPONSORED REPORT

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.

VIDEO

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.