Module 4 – Intro to Excel 2016 Data Analysis

Module 4

4.1 Functions and the Formulas Tab in Excel 2016
4.2 Insert Function Tool
4.3 The AND Function; Practice Exercise 5 ​Concerning the AND function, use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument.
4.4 The OR Function; Practice Exercise 6: Concerning the OR function, use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument.
4.5 The IF Function; Practice Exercise 7: Concerning the IF function, we will use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument; Practice Exercise 8:  Create an IF formula using the IF function in a table
4.6 Nested IF Function; Practice Exercise 9: Create an IF formula using nested IF functions to create additional conditions
4.7 VLOOKUP and HLOOKUP Functions; Practice Exercise 10: Use a VLOOKUP table for applying approximate matching data
4.8 Using VLOOKUP Function for Finding an Exact Match; Practice Exercise 11: Use a VLOOKUP table for applying exact matching data
Module 4 Learning Objectives:
Given a standard IBM-compatible personal computer with Microsoft Excel 2016 installed, after reading the assigned study guide pages as well as watching the instructor-led video(s), at the end of the module the student will be able to:

  • Imitate the instructor’s actions for creating VLOOKUP AND HLOOKUP FORMULAS
  • Describe how VLOOKUP and HLOOKUP functions operate
  • Describe how the Insert Function is used to create correct syntax construction for Excel functions
  • Imitate the instructor’s action in appropriate use of the Insert Function feature for constructing formulas and functions
  • Describe what functions and formulas are used for data analysis
  • Describe how formulas are nested to create additional functionality in a formula