Course Offerings

Get the Excel training you need to achieve success so you can manipulate data faster and more efficiently in most workplace situations. If your organization uses lists of any kind, you need to know how to use Microsoft Excel. Earning the Microsoft Office Specialist Excel Expert certification sets your professional skill set apart from other Excel users. The course will prepare you for the Microsoft Office Specialist: Microsoft Excel Expert exam. In this online Excel course, you will first learn to create, modify, and format Excel worksheets, perform calculations, and print Excel workbooks. The course then moves on to teach you how to use advanced formulas, work with lists, work with illustrations and charts, and use advanced formatting techniques. You will also learn Excel's advanced features, such as pivot tables, audit worksheets, data tools, macros, and collaboration methods. Upon completion of this course, you will be prepared for the Microsoft Excel Expert certification exam, Exam MO-201 (for Microsoft Office 2019/2021 users), or Exam MO-211 (for Microsoft Office 365 users.) This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the certifying exam upon eligibility. Proctor fees may apply, which are not included.

Course Objectives

Modify and format data in Excel to create clear, presentable worksheets.

Perform calculations, write formulas, manage workbooks, and save time with Excel shortcuts.

Use Excel database functions and logic functions to work with information in large datasets, and leverage Excel's statistical functions to analyze data.

Visualize your data using charts to show trends, create comparisons, and demonstrate other meaningful insights.

Create PivotTables and charts to quickly summarize large amounts of data.

Learn to trace precedents and dependents to learn about the data connected to your active cell.

Convert blocks of text, analyze data using tables, and leverage validation tools to control the data entered into your worksheet. Consolidate data from various sources into one master worksheet for easy summary and review.

Work with other applications by importing and exporting data, charts, and files.

Outline of Instruction

Introduction to Excel

Intermediate Excel

Advanced Excel

Final Exam

Contact Hours

70

CEUs

No

Industry Standard, State or National Certification

Certification

None

Website

None

Certification Learning Outcomes/Requirements

CE or CU Articulation

No

Prerequisites

There are no prerequisites to take this course. However, you should be comfortable using a personal computer and be familiar with operating Microsoft Office software.

Learning Supplies Needed

Hardware Requirements:
This course must be taken on a PC. Macs and Chromebooks are not compatible.

Software Requirements:
PC: Windows 10 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office 365, 2021 or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, if you do, there will be some differences between your version and what you see in the course.
Adobe Acrobat Reader.
Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account.

Instructional Material Requirements:
The instructional materials required for this course are included in enrollment.

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance

Accreditation/Special Approval Requirements

N/A

Intended Audience

This course prepares you for the Microsoft Office Specialist Expert certification exam for Microsoft Excel.

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

Course Contact Information

Courtney Boney
919-532-5581
[email protected]