Microsoft Excel 2019/365 Online Course Bundle- Associate & Expert Qualifications

£250.00

Require a Company or School Invoice? You can request an invoice here.

    Description

    The Microsoft Excel 2019 & 365 Associate & Expert Online Course. Microsoft Excel is a widely used spreadsheet program developed by Microsoft. It is part of the Microsoft Office suite of applications. Excel is popular across various industries and professions due to its versatility and powerful capabilities in handling data-related tasks.

    MOS exams, or Microsoft Office Specialist exams, are certification tests that validate a user’s proficiency in Microsoft Office applications. These certifications are recognized globally and demonstrate that an individual has the skills to use Microsoft Office programs effectively in a professional setting. The MOS certification program includes exams for different Office applications and skill levels. 

    Two courses at a reduced rate. We have combined our Microsoft Excel Associate & Microsoft Excel Expert courses into a course bundle saving you ££££’s. So, whether your current skill set is almost zero or whether your knowledge is considered to be at an advanced level, this course has you covered. The course will prepare you fully for both MOS examinations MO-200 & MO-201.


    Qualification: MOS- Excel Expert & Associate Certificate’s (Optional Exam’s Required)
    Duration: 1-year course access & support included (200 hours Approx. overall)
    Start Date: Anytime – We enrol 365 days a year 

    Course Syllabus

    Associate Syllabus

    Unit 1: Managing worksheets and workbooks

    The following topics are covered: Introduction; The Excel Application; Managing Worksheets & Workbooks; Navigating Worksheets & Workbooks; Formatting Worksheets & Workbooks; Customisation Option & Views; Configuring Content For Collaboration; Lesson Review & Quiz; and Assignment 1 – Worksheet & Workbook Exercises.

    Unit 2: Managing data cells and ranges

    The following topics are covered: Introduction; Manipulating Data in Worksheets; Formatting Cells & Ranges; Summarising Data Visually; Applying Formulas; Lesson Review & Quiz; and Assignment 2 – Data Cell & Range Exercises.

    Unit 3: Managing tables and data

    The following topics are covered: Introduction; Creating & Formatting Tables; Modifying Tables; Filtering & Sorting Table Data; Introducing Pivot Tables & Charts; Lesson Review & Quiz; and Assignment 3 – Table Exercises.

    Unit 4: Perform operations using functions

    The following topics are covered: Introduction; Creating & Formatting Tables; Modifying Tables; Filtering & Sorting Table Data; Introducing Pivot Tables & Charts; Lesson Review & Quiz; and Assignment 3 – Table Exercises.

    Unit 5: Managing charts and objects

    The following topics are covered: Introduction; Creating & Modifying Charts; Formatting Charts; Working With Objects; Lesson Review & Quiz; Assignment 5 – Charts & Object Exercises; and The MOS Examination Explained.

     

    Expert Syllabus

    Unit 1: Manage workbook options and settings

    The following topics are covered: Introduction; Managing Workbooks; Preparing Workbooks for Collaboration; Using and Configuring Language Options; Lesson Review & Quiz; and Assignment 1 – Workbook Options & Settings Exercises.

    Unit 2: Managing & formatting data

    The following topics are covered: Introduction; Fill Cells Based on Existing Data; Formatting & Validating Data; Advanced Conditional Formatting & Filtering; Lesson Review & Quiz; and Assignment 2 – Custom Data Formatting Exercises.

    Unit 3: Creating advanced formulas and Macros

    The following topics are covered: Introduction; Performing Logical Operations in Formulas; Lookup Data Using Functions; Using Advanced Date & Time Functions; Performing Data Analysis; Troubleshooting Formulas; Creating & Modifying Macros; Lesson Review & Quiz; and Assignment 3 – Advanced Formula Exercises.

    Unit 4: Managing advanced charts and tables

    The following topics are covered: Introduction; Creating & Modifying Advanced Charts; Creating & Modifying Pivot Tables; Managing Pivot Tables; Create & Modifying Pivot Charts; Lesson Review & Quiz; Assignment 4 – Advanced Table & Chart Exercises; and The MOS Examination.

     

     

    Entry Requirements

    There are no entry requirements as the course is set out for beginners although students will require their own version of Microsoft Excel 365 or 2019 to complete the course.

    Please Note: This course covers the PC versions of Microsoft Excel 2019 and Microsoft Excel 365. It will be possible to view the course materials using an Apple Mac although the information within the course will be specific to the PC version of Microsoft Office and will differ slightly from the Mac versions.

    Assessment

    You will be assessed on assignments which are detailed in the course materials. These assignments will require you to create work on, and create and edit spreadsheet files. Your work can be sent back to your course tutor by email for assessment. 

    Optional Exam Vouchers

    All students have the option to purchase MOS Exam Vouchers for £96.00 which will cover the cost of the exam at participating exam centres. A voucher would be required for each MOS exam you sit. An additional proctoring fee will need to be paid to the exam centre for each exam.

    Please Note: It is the students responsibility to source suitable exam centres. We advise researching exam centres prior to purchasing an exam voucher to make sure a suitable participating exam centre is available.

    Examinations must be sat at a registered Certiport Testing Centre. You should choose the Program, Version and Exam before adding your location for a list of suitable exam centres.

    Exam vouchers (Valid for 12 Months) can be purchased for £90.00. We usually advise buying a voucher when you are ready to sit your test, although you can add this to your order when you purchase your course.

    Please Note: Exam Centres will usually charge an additional proctoring fee (Approximately £15.00) for sitting exams.

    GMetrix Exam Prep Software

    The course also comes with GMetrix exam preparation software. The GMetrix Skills Management System provides everything you need to prepare for the Microsoft Office Specialist (MOS) Certification.

    Overview of Test features:

    • Practice tests map to the Microsoft Office Specialist (MOS) exam objectives.
    • All tests are in-application or performance-based simulations to provide the best assessment of real-world experience.
    • All tests have both a testing and a training mode providing step-by-step help on each question.
    • Progress at own pace, save test to resume later, return to skipped questions.
    • Detailed, printable score report highlighting areas requiring further review.

    Please Note: You will need a version of Microsoft Office to be able to use the GMetrix software package.

    Course outcome

    On successful completion of this course students will receive our Microsoft Excel 2019 and 365 Expert Certificate of Completion. Students can also apply for the Microsoft Office Specialist (MOS) Excel Associate MO-200 & MO-201 exams.

    14 Day Money Back Guarantee

    Once course access has been provided you have 14 days to ensure this course meets your needs and requirements. If you are not happy for any reason at all, simply email our accounts department with your request to cancel on [email protected]. We will offer a full refund. No questions asked !

    Please note: Any request to cancel outside the 14 days cancellation period will be declined. We will not refund you under any circumstances outside of the legal 14 day cooling off period. If you have opted to finance your course with Payl8r finance you are legally obliged to pay the balance of your fees once the 14 day period expires.

    Our full T’s & C’s can be viewed here.