Microsoft Office Specialist (MOS) Excel Core 2016 (Blended) Tuesday

Delivery Method  - Blended (Classroom and Online)

Blended learning is the integration of digital tools, techniques and materials with the physical classroom. In a blended course, students may view lectures, access readings, ask questions, and complete assignments online in virtual learning environments (VLE) like Moodle and through online classrooms such as Zoom, freeing up in-person class periods for discussions, activities and traditional lectures. Other terms, such as mixed, hybrid, or integrative learning, all describe the same method of teaching. Access to a Tablet or Computer with a broadband connection is required. 

Important Notice:  The approach to delivery may have to be adjusted at short notice depending on advice from the Government.

Course Name– Microsoft Office Specialist (MOS) EXCEL Core 2016

Award- MOS Excel Core 2016 Certificate.

Course Overview

The MOS certificate is a worldwide industry standard.This course is suitable for anyone seeking a credential to validate their advanced knowledge of Microsoft Excel by becoming a Microsoft Office Specialist (MOS).There is a quick overview of the basic skills in Excel on the first night and then on to comprehensive training o enable you to pass the MOS Core Excel 2016 Exam 77-420. Each night covers an element of the course content in detail and outside of the classroom training,students use our online training forums to practice their skills and get ready for their online exam.Other skills gained is the ability to use the cloud and use email.

Course Content

Students learn how to create detailed worksheets, invoices, charts, and complex formulas achieve professional results in a fraction of the time.Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices and data-entry logs.

  • Creating and managing worksheets and workbooks
  • Create, navigate, format, customize options and views, configure worksheets and workbooks for distributions.
  • Managing data cells and ranges
  • Insert data in cells and ranges, format cells and ranges, summarize and organise data.
  • Creating tables
  • Create and manage tables, manage table styles and options, filter and sort a table.
  • Performing operations with formulas and functions
  • Summarize data by using functions,perform conditional operations by using functions, format and modify text by using functions
  • Creating charts and objects
  • Create charts, format graphic elements, insert and format objects

Entry Requirements

Students must have a good working knowledge of computers, operating systems, using a mouse, keyboard, standard menus, and commands. Students must be able to open, save, and close applications and files, as well as navigate to other folders. A basic understanding of operators, formulas and basic functions (SUM, AVERAGE, MAX, MIN, COUNT, IF) is needed to push forward with the intermediate to advanced requirements of the MOS Excel training.

Changes in the MOS 2016 exams

MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.

The MOS 2016 exam format incorporates multiple projects

Tutor Biography

As an employee, learning how to use Excel efficiently opens up more opportunities for employment and career advancement since most jobs utilize this application. Teresa has an industry/educational background which enables her to ensure that the training provided is practical,work related training.Teresa teaches cloud related applications such as the MOS applications, the ECDL, cloud storage apps and multi-media applications.She has many years’ experience in providing training and mentoring to people on job placement as well as facilitating their journey to QQI major award. She provides training in business applications such as manual and computerised (Sage) payroll and bookkeeping, office administration skills with additional soft skills such as customer service and communication skills.

GRETB email