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.
This course has been approved for the FCCQ Visées program funding.
Develop the skills of your teams with this training, and benefit from a grant of up to $8,000!
The Visées program is an initiative of the Fédération des Chambres de Commerce du Québec (FCCQ) and the Chambre de Commerce du Montréal Métropolitain (CCMM), funded by Upskill Canada (powered by Palette Skills) and the Government of Canada.
When applying to Visées for tuition reimbursement, please use reference code: MCGILL-016.
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 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.