Microsoft Excel 2016 Level 2.1: Working with Functions

Description

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.

This course explains how working with logical functions and comparison operators lead to logical values, which establish whether criteria have been met. Viewers are shown how to use and apply different functions such as IF, AND, Text, and others, and are taught how to combine functions.

Watch this training course to learn how to do more with functions in Microsoft Excel 2016.