View All Courses

Microsoft Excel 2016 Level 3.4: Automating Workbook Functionality

4 Lessons
17-22 Minutes
5 Quiz Questions

Course Overview


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.

Microsoft Excel 2016 Level 3.4: Automating Workbook Functionality thumbnails on a slider
Microsoft Excel 2016 Level 3.4: Automating Workbook Functionality thumbnails on a slider
Microsoft Excel 2016 Level 3.4: Automating Workbook Functionality thumbnails on a slider
Microsoft Excel 2016 Level 3.4: Automating Workbook Functionality thumbnails on a slider

    Key Audience


    All employees who use Excel

    Course Topics


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

    Workplaces


    Not Specified

    Course Detail


    Course ID
    sonie16aw_vod

    Time

    17-22 MIN
    Questions
    "5"

    Languages

    en

    video format

    HD

    captions

    Yes

    Resources

    Yes

    Lessons

    4

    Remediation

    Yes

    Bookmarking

    Yes

    Feedback

    Yes

    Microlearning