Excel Data Management
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. (Note: This course is based on Microsoft Excel 365)
Format
PDF Course
Level
Overview
Duration
1.5 Hours
Course Information
Author: Steven Bragg
Course Number: SP1016
Learning Objectives
- 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.
Level: Overview
Instructional Method: QAS Self-Study
NASBA Category: Computer Software & Applications
Prerequisites: Basic knowledge of Excel.
Advance Preparation: None
Latest Review Date: April 2025
Program Registration Requirements: Click on the Enroll button to pay for and access the course. You will then be able to download the course as a PDF file, then take an on-line examination, and then download a certificate of completion if you pass the examination.
Program Refund Policy: For more information regarding administrative policies concerning complaints, refunds, and other matters, see our policies page.