Microsoft Office Specialist - MOS Excel

Please check out the ETB website to check out the next start date/enrolment of evening classes.
https://www.cmetb.ie/evening-provision/
OR
Please contact eveningcourses@cmetb.ie or call 049 4353904.

FET Campus, Dublin Road, Cavan.

All Level 5 and Level 6 evening courses are free of charge under the Skills to Advance or Skills to Compete initiative.

Description:
This course is designed for Microsoft Excel users who wish to extend their knowledge and skills beyond building simple workbooks.

Excel 2019 training course focuses on how to work more efficiently with calculations, how to further enhance the appearance of the data in the spreadsheet and introduces some data analysis features of Excel. It will demonstrate how to control more complex formulas and functions and how to use formula auditing. It will also cover the use of various tools to analyse data such as sorting, filtering and a basic introduction to Pivot tables. You will learn how to organise and present your data using tables, charts and conditional formatting.

Learners will be able to:
• Create Worksheets and Workbooks
• Navigate in Worksheets and Workbooks
• Format Worksheets and Workbooks
• Customize Options and Views for Worksheets and Workbooks
• Configure Worksheets and Workbooks for Distribution
• Insert and format data in Cells and Ranges
• Summarize and Organize Data
• Create and Manage Tables
• Manage Table Styles and Options
• Filter and Sort a Table
• Summarize Data by using Functions
• Perform Conditional Operations by using Functions
• Format and Modify Text by using Functions
• Create and format Charts
• Insert and Format Objects

Certification:
Microsoft Office Specialist (MOS) Excel, an internationally recognised standard for demonstrating desktop skills.

Evening Provision Team:
Email: eveningcourses@cmetb.ie
Call 087 4054311 or 049 4353904