A central concern when using Excel is whether the data being used is sufficiently clean and well-organized to be useful for further analysis. In the Excel Data Management course, we cover the importing of data from other sources, cleaning it, validating data at the point of data entry, protecting it from unauthorized changes, and organizing it properly. The outcome is much more reliable data, which improves the quality of any subsequent analyses conducted on the data.
Learning Objectives
Upon successful completion of this course, participants will be able to:
Explain the characteristics of the ribbon system.
Describe the different types of files that can be imported into Excel, and their characteristics.
Identify the different types of commands that can be used to clean up data and extract data from a data set.
Specify the function keys that can be used to clean up data within a worksheet.
Identify the characteristics of a worksheet outline and how it can be used.
Major Topics
The Worksheet Ribbon
Importing and Cleaning Data
Validating Data
Worksheet Outlines
Lining Worksheets
Protecting Data
