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
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:
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