Course Offerings

This course is designed to equip you with essential skills for data-driven roles and activities. You will use Excel's powerful tools, including Pivot Tables and advanced data visualization techniques, to analyze and interpret complex datasets effectively.

Through hands-on learning, you'll gain proficiency in organizing, cleaning, and manipulating data, as well as creating insightful reports and visualizations. By the end of the course, you'll be ready to manage real-world data challenges and drive informed decision-making.

Course Objectives

Identify key Excel tools for data analysis, including Pivot Tables and charts.
.

Apply advanced Excel tools to organize and analyze large sets of data.


Analyze data trends and patterns by creating reports and visualizations that help with decision-making.


Check the accuracy of data by using data cleaning techniques to ensure reliable results.


Create clear and professional dashboards to present data in an easy-to-understand way.


Combine data from different sources to create reports that provide useful insights for business strategies

Outline of Instruction

Preparing the Data for an Excel Pivot Table

Summarizing and Presenting Data with a Pivot Table

Using Calculations in Pivot Tables

Sorting and Filtering the Pivot Table

Making the Pivot Table More Visual with Charts

Summarizing Data by Date and Time

Creating a Pivot Table from Multiple Spreadsheets

Improving a Pivot Table with Power Pivot

Pulling It All Together: Creating a Dashboard from Pivot Tables

Contact Hours

39

CEUs

1

Industry Standard, State or National Certification

Certification

None

Website

None

Certification Learning Outcomes/Requirements

CE or CU Articulation

No

Prerequisites

Prior to enrolling in this course, students should have basic proficiency in Microsoft Excel, including knowledge of creating and formatting spreadsheets, using basic functions such as SUM and AVERAGE, and organizing data. Familiarity with data management concepts and general computer skills is also required.

Learning Supplies Needed

None

Clinical Site/Special Facilities

None

Requirements for Successful Completion

80% attendance
Actively participate in class, including discussions and independent and group activities.,Complete assigned labs and projects.

Accreditation/Special Approval Requirements

N/A

Intended Audience

Individuals seeking to obtain entry-level data roles or those who want to enhance skills to improve employability.

Specific Industry or Business Support Needs

Data Analysts, Business Analysts, Financial Analysts, Accountants, Project Managers, General Managers, Operations Managers

Wake County Need for Industry Positions

Data analysis and business analysis skills are highly sought after in Wake County, with a high demand reflected in job postings.

Industry or Job Titles Related to Training Outcomes for Employment

Data Analysts

Business Analysts

Financial Analysts

Accountants

Project Managers

General Managers

Operations Managers

Related Courses

Course Contact Information

Andrea Dethmers
9195325736
[email protected]