Module 2 – Intro to Excel 2016 Data Analysis

Module 2

2.1 Excel Standards for Organizing and Cleaning Your Data
2.2 Organize and Clean Data Using Data Tools Section on the Ribbon; Practice Exercise 3 Organize and Clean Data in the EMPLOYEES Table
2.3 Practice Exercise 4 – Organize and Clean Data in the CUSTOMERS Table
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