YCWPD 086 - Microsoft Office Specialist : Excel Associate Certification Prep

Description

This practical course aims to prepare participants to obtain the Microsoft Office Specialist: Excel Associate Certification. Emphasis is placed on developing fundamental Excel skills necessary to create and edit professional spreadsheets for a variety of purposes and situations, and to gain practical experience in creating, editing, and managing workbooks. Skills measured by the MO-200: Microsoft Excel (Office 2019) exam include: managing worksheets and workbooks; data cells and ranges; tables and table data; performing operations by using formulas and functions, and managing charts.

Topics Covered

Topics covered include:

Introduction to Excel
Constructing Data Cells
Using Formulas
Formatting the worksheet
Viewing and printing workbooks
Working with charts
Organizing data
Using Data Tools
Practice Exam questions and exercises

Learning Outcomes

Upon completion of this course, you should be able to:

Explain what Excel is and what it can do, navigate a worksheet, identify elements on the Excel screen, and use keyboard shortcuts.
Edit cells, copy, cut, and paste data, use special paste, insert, and delete cells, move, and delete worksheets, use AutoFit, insert, and delete rows and columns, and rename worksheets.
Use formulas and explain what formulas are and how they are used, create, and edit simple formulas, use math operators, reference other worksheets, use common functions, if function, text functions, use absolute and relative cells, and display formulas.
Format number and decimal places, merge and wrap text, change fonts and font size, apply background colours and patterns, use the format painter, use cell styles, and apply and remove conditional formatting.
Create and arrange worksheet windows, split, and freeze panes, change printing margins, orientation, and scale, use different workbook views, and print selected worksheets.
Create and change charts, create chart sheets, create chart designs, add new data to charts, preview charts for printing, and use the Quick Analysis tool.
Create, modify, and delete named ranges, use the Go To feature, convert a range of cells into a table, sort data, filter data, and apply and remove formatting on a table.
Customize the Quick Access toolbar, create, modify, and delete hyperlinks, import, and export data, change workbook document properties, and use the document inspector tool.

Notes

Hardware Requirements
For optimal learning experience, we recommend using a PC.
The Certification exam will be delivered through Certiport using Windows environment.

Software Requirements
PC: Windows 10 or later.
Microsoft Excel 2019 or Microsoft Excel 365 (not included in the course fee).
Software must be installed before the start of the course.

Certification Exam Information
Certification exams are delivered in-person at the School of Continuing Studies at scheduled times.

Prerequisite(s) and Corequisite(s)

Basic knowledge of Windows or Mac OS operating system.

Who Should Attend?

Individuals wishing to prepare for the Microsoft Office Specialist: Excel Associate Certification MO-200: Microsoft Excel (Office 2019) exam.
Anyone who wants to master fundamental Excel skills and demonstrate readiness to use Excel professionally in the workplace.

Contact Hours: 24 contact hours

Course Fees:

Course only - CAD $695

Course and certification exam - CAD $795 (includes Certiport certification exam voucher valued at $125). Proctoring fees may apply and are not included in the above fees.