Enforcing Internal Control within Excel Spreadsheets 2017 covers topics such as:
- Use Excel’s IFERROR function to make a cell appear blank instead of returning a #N/A or other error
- VLOOKUP function in Excel
- Spreadsheet design techniques
- Excel’s Table feature
- Use Excel Data Validation list to restrict data entry to a list of permissible choices
Enforcing Internal Control within Excel Spreadsheets 2017 brings together:
- Payroll Professionals
- HR/ Controllers
- CFOs
- Accounting and Finance Personnel
- Managers
- Auditors
- Admin