Microsoft Excel 2016 Level 2.1: Working with Functions
 Course Format

Video On Demand
 Product ID
 sonie16wf_vod
 Training Time ?
 65 to 92 minutes
 Language(s)
 English
 Video Format
 High Definition
 Required Plugins
 None
 Number of Lessons
 19
 Quiz Questions
 27
 Closed Captioning
 Question Feedback
 Wrong Answer Remediation
 Lesson Bookmarking
 Downloadable Resources
 Interactive Producer
 Mastery Training Content Network
 Original Content Producer
 Sonic Performance Support GmbH
Microsoft Excel 2016 functions enable users to gain complex information about their data. This online training course demonstrates how to get the most out of Excel’s features.
Viewers are shown how to use the ’Tell me’ search box to locate specialized functions, and learn a variety of ways to quickly calculate information. This course explains what logical functions are, and demonstrates how to use IF, TEXT, CONCATENATE, and other functions. Viewers learn how to combine functions, and are taught the points to keep in mind when combining, such as including a full set of parentheses in all combined functions. This course also teaches how to reformat text using the UPPER, LOWER, and PROPER functions.
Take this online training course to get more out of Microsoft Excel 2016.
This course is in the Video On Demand format, to read about Video On Demand features click here.
 Install on any SCORM LMS
 Fullscreen video presentation
 Print certificate and wallet card
 You have 60 days to complete the course
Anyone interested in learning more about functions in Microsoft Excel 2016
 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

Work with functions.
 Recall what you can find using the Tell me what you want to do search box tab.
 Distinguish between a relative and an absolute reference in a formula.

Work with ranges Excel 2016.
 Recall options for naming ranges in functions and formulas.

Name and edit ranges.
 Identify a shortcut for selecting cells.
 Recognize the different options for creating a name for a range of cells.

Use defined names in a formula.
 Recall how to replace cell references with range names.

Locate and use specialized functions.
 Recall proper formatting for criteria when creating a function manually.

Work with logical functions.
 Recall the values Excel returns when applying a logical test to data.
 Select examples of a logical function.

Work with IF functions.
 Recall the logical test performed by the IF function.

Work with AND, OR and NOT functions.
 Distinguish between the OR, AND, and NOT functions.

Combine multiple functions.
 Recall what is required of a function used as an argument.
 Recall what is required to create a nested or first level function.

Use functions similar to the IF function.
 Recall which statistical function counts the number of cells that meet specified criteria.
 Identify the required syntax elements when using functions like SUMIF and COUNTIF.

Work with date and time functions.
 Explain how Excel is able to display dates in a number of different formats.

Use the TODAY, NOW and DATE functions.
 Choose which function should be used to combine separate values to form a date.

Work with the NETWORKDAY, WEEKDAY, WORKDAY and ISOWEEKNUM functions.
 Recall which function returns a count of the number of workdays between two specific dates.
 Recall how to change the day of the week the WEEKDAY function begins counting.

Work with text functions
 Identify basic uses for Excel?s text functions.

Work with the LEFT, RIGHT and MID functions.
 Identify the equation(s) that will return the first 4 characters of text from a cell.

Use the FIND function.
 Recall criteria for using the FIND function.

Use the text to columns feature.
 Identify delimiters that can be used to split data into multiple columns when using the Text to Columns feature.

Join text strings using the CONCATENATE function.
 Identify which symbol can be used or to combine text from multiple cells the same way as the CONCATENATE function.

Work with the UPPER, LOWER and PROPER functions.
 Recall how many text arguments UPPER, LOWER and PROPER functions have.
© Mastery Technologies, Inc.