Course
Microsoft Excel 2019 Level 3
Name
SEF-3001OM2
Available Classes
Intended Audience
Prior to course enrollment, participants should have an interest in using Microsoft Excel to analyze and present data.
Description
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
- Using Lookup Functions and Formula Auditing
- Sharing and Protecting Workbooks
- Automating Workbook Functionality
- Creating Sparklines and Mapping Data
- Forecasting Data
Contact Hours
8
CEU's
0.8
Industry Standard, State, or National Certification
No
CE to CU Articulation
No
Prerequisites
Prior to course enrollment, participants should have Microsoft Excel 2016 Level 2
Text and Supplies Needed
N/A
Clinical Site/Special Facilities
N/A
Requirements for Successful Completion of this Course
- Attendance 90% or above
- Participation
- 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
Industry or Job Titles Related to training Outcomes for Employment
Related Courses
- Microsoft Excel 2016 Level 2 - SEF-3001ML2
Course Contact Information
Community & Career Education Staff
cce@waketech.edu
919-532-5700