The one-variable data table can give
the cash flow picture automatically.
Set up the one-variable data table
directly below the original data to speed the
Tell the spreadsheet where to find the
needed datain a row or a column.
This what-if feature provides instant
documentation of the substitution process.
The spreadsheet program also can
handle a two-variable data table.
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.