Quantitative Data Analysis with Microsoft Excel: An Introduction
CPEs: 14
|CEUs: 1.4
Overview/Introductory
Classroom, Virtual
Who Should Attend
Students whose job responsibilities require them to routinely analyze and report data gathered through various data collection activities as well as students who wish to improve their analytical skills to make themselves even more valuable within their agencies.
Note: This class was previously called Data Analysis with Microsoft Excel: An Introduction.
Course Description
This course focuses on performing key work-related quantitative data analysis tasks using the powerful tools available in Microsoft Excel. Students taking this class should have a strong working knowledge of Microsoft Excel.
Suggested Prerequisite: We recommend that students take first the following courses or be familiar with the concepts and principles covered in these courses:
- Microsoft Excel: Level One
- Management and Program Analysis: Data Collection and Analysis
Advanced Preparation: None
NASBA CPE Field of Study: Personal Development
Course Objectives
- Why Excel is most commonly used for statistical analysis
- The components of the suite of tools within Excel that perform regression and calculate statistical data
- How to setup your data for analysis
- The methodology of performing quantitative data analysis within the context of a business and management project
- How to prepare reports or structure presentations using the output of Excel in data analysis
- Tools, tips, and suggestions for completing your data analysis tasks more effectively and efficiently
- Practical considerations and the limits of Excel in performing statistical analysis