Microsoft Excel 2016 Level 2.1: Working with Functions

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.

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 ISO Weeknum 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.

• Windows 8.1: Using Internet Explorer 11
• Windows 8.1: Other Windows 8.1 Features
• Windows 8.1: Using Windows 8.1 Security Features