Intro to Excel 2016 Data Analysis

Module 1 – Intro to Excel 2016 Data Analysis

Module 1 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:
  • List the categories of Excel data analysis
  • List the various data analysis tools used to clean up, sort, and categorize imported data
  • Imitate the instructor’s action necessary for importing a Comma Separated Value data file
  • Imitate the instructor’s action necessary for importing a table from Microsoft Access
  • Imitate the instructor’s action necessary for importing another Excel table

Lessons

Lesson 1 Preview Lesson 2 Preview Lesson 3 Preview

Module 2 – Intro to Excel 2016 Data Analysis

Module 2 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:
  • List the Excel Standards for Storing Data
  •  Describe how the data tools section of the Ribbon is used for contributing to data analysis
  • Describe the steps used for cleaning data for recently imported ranges or tables

Lessons

Lesson 4 Preview Lesson 5 Preview

Module 3 – Intro to Excel 2016 Data Analysis

Module 3 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:
  • Describe the various ways Excel users can sort data

Lessons

Lesson 6 Preview

Module 4 – Intro to Excel 2016 Data Analysis

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

Lessons

Lesson 7 Preview Lesson 8 Preview Lesson 9 Preview Lesson 10 Preview Lesson 11 Preview Lesson 12 Preview Lesson 13 Preview