Microsoft Excel 2016 Level 3.4 Automating Workbook Functionality

  • E-Learning

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 course provides step by step instructions for employees to automate workbook functionality in Microsoft Excel 2016.  

Viewers will learn how to use data validation tools to protect the quality of data in the workbook. Learn how to create, run, and edit macros. Use this course to educate employees about implementing more automation into their Excel 2016 workbooks to ensure greater levels of accuracy. . 

 

Topics Covered

  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors 
  • Work with Macros
  • Edit a Macro
     

Duration:

0.28 hours

Code/regulation:

Best Practices

Frequency:

As Needed

Who Should Attend:

All Employees Who Use Excel