Features in Excel 2016 allow you to validate your data, check for errors in formulas, and apply a series of instructions with a single command to all worksheets in your workbook. This video training course provides step-by-step instructions for employees to automate workbook functionality in Microsoft Excel 2016. This video teaches viewers how to use data validation tools to protect the quality of data in the workbook. Viewers learn how to create, run, and edit macros. Use this video to educate employees about implementing more automation into their Excel 2016 workbooks to ensure greater levels of accuracy.
All employees who use Excel
Apply Data Validation
Search for Invalid Data and Formulas with Errors
Work with Macros
Edit a Macro
Occupational Skills: Computer Skills