Course Offerings

Microsoft Excel has become an integral part of business around the world. It is used in organizations, academia, and personal settings to analyze, visualize, and store data. Learn how to use data analysis, auditing, Sparklines, and forecasting in Excel. You will also learn how to graphically display relationships between formulas and cells, find records quickly, represent information visually, show trends, and use data mapping to help resolve problems.

Course Objectives

Know how to make workbook edits with multiple users


Understand how to analyze data

Use Excel features to structure and visualize data

Use PivotTables and PivotCharts

Outline of instruction

Working with Multiple Worksheets and Workbooks

Sharing and Protecting Workbooks

Automating Workbook Functionality

Using Lookup Functions, Dynamic Arrays, and Formula Auditing

Forecasting Data

Creating Sparklines and Mapping Data

CEUs

0.8

Industry Standard, State or National Certification

Certification

None

Website

None

Certification Learning Outcomes/Requirements

CE or CU Articulation

No

Prerequisites

Prior to course enrollment, participants should have Microsoft Excel 2016 Level 2 or equivalent experience.

Text and Supplies Needed

N/A

Clinical Site/Special Facilities

N/A

Requirements for Successful Completion

90% attendance
Demonstrate an understanding of at least 70% of course material taught.

Accreditation/Special Approval Requirements

N/A

Intended Audience

Prior to course enrollment, participants should have an interest in using Microsoft Excel to analyze and present data.

Specific Industry or Business Support Needs

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to training Outcomes for Employment

Related Courses

SEF-3001ML2

Course Contact Information

Susan Shostak
919-334-1536
[email protected]