View All Courses

Microsoft Excel 2016 Level 2.1: Working with Functions

19 Lessons
65-92 Minutes
27 Quiz Questions

Course Overview


Understanding the language of Excel enables users to increase the complexity of their data analysis. This course teaches how to use Microsoft Excel 2016 functions at a more advanced level. As a foundation for using Excel functions, viewers are shown how to name and edit ranges, which allows users to navigate the workbook much faster. They learn how to use named ranges to create formulas. Using named ranges instead of cell ranges in formulas makes it easier to identify the data contained within the formula. Watch this training course to learn how to do more with functions in Microsoft Excel 2016.

Microsoft Excel 2016 Level 2.1: Working with Functions thumbnails on a slider
Microsoft Excel 2016 Level 2.1: Working with Functions thumbnails on a slider
Microsoft Excel 2016 Level 2.1: Working with Functions thumbnails on a slider
Microsoft Excel 2016 Level 2.1: Working with Functions thumbnails on a slider

    Key Audience


    Everyone interested in learning more about Microsoft Excel 2016 functions

    Course Topics


    Work with Functions
    Work with Ranges
    Name and Edit Ranges
    Use Defined Names in a Formula
    Locate and Use Specialized Functions
    Work with Logical Functions
    IF Function
    AND, OR and NOT Function
    Combine Functions
    Functions Similar to the IF Function
    Work with Date and Time Functions
    TODAY, NOW and DATE Functions
    NETWORKDAY, WEEKDAY, WORKDAY and ISOWeeknum Functions
    Work with Text Functions
    LEFT, RIGHT and MID Functions
    FIND Function
    Text to Columns Feature
    CONCATENATE Function
    UPPER, LOWER and PROPER Functions

    Workplaces


    Not Specified

    Course Detail


    Course ID
    sonie16wf_vod

    Time

    65-92 Min
    Questions
    27

    Languages

    en

    video format

    HD

    captions

    Yes

    Resources

    Yes

    Lessons

    19

    Remediation

    Yes

    Bookmarking

    Yes

    Feedback

    Yes

    Microlearning

    no