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. 

It is best to complete this course in one sitting, if you do need to stop the training midway, please enable cookies for our website and allow popups (turn off your popup blocker) so that you don't lose progress for the course.

 

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