Course description
MOS Excel 2019 & 365 Associate & Expert Course Bundle
The MOS Excel 2019 & 365 Associate and Expert Course Bundle is designed for anyone who wants to learn the Microsoft Excel 2019 and 365 software from a beginners level all the way to the Expert level and covers everything that is included in the Microsoft Office Specialist Associate and Expert exams. These courses can be used by anyone wanting to sit the MOS exams or those who need to learn more about the Microsoft Excel software package.
Microsoft Excel is one of the most important software packages used in businesses and adding the industry-recognised Microsoft Office Specialist certification to your CV demonstrates that you have gained the necessary expertise to use Microsoft applications to a high standard, and shows you have the skills companies are looking for.
Upcoming start dates
Suitability - Who should attend?
Prerequisites
There are no particular entry requirements as the course is set out for beginners although students will require their own version of Microsoft Excel 2019 or Microsoft Excel 365 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.
Outcome / Qualification etc.
On successful completion of these courses students will receive our Microsoft Excel 2019 and 365 Associate and Expert Certificates of Completion with feedback from your tutor, and students can also apply for the Microsoft Office Specialist (MOS) Excel Associate MO-200 and Microsoft Office Specialist (MOS) Excel Expert MO-201 exams.
Training Course Content
The MOS Excel 2019 & 365 Associate Course Includes the Following Units:
- Unit 1: Managing Worksheets and Workbooks
- Unit 2: Managing Data Cells and Ranges
- Unit 3: Managing Tables and Table Data
- Unit 4: Perform Operations Using Functions
- Unit 5: Managing Charts and Objects
The MOS Excel 2019 & 365 Expert Course Includes the Following Units:
- Unit 1: Manage Workbook Options & Settings
- Unit 2: Managing & Formatting Data
- Unit 3: Creating Advanced Formulas & Macros
- Unit 4: Managing Advanced Charts & Tables
The MOS Word 2019 & 365 Associate Course Includes the Following Units:
- Unit 1: Managing Documents
- Unit 2: Inserting and Formatting Text and Paragraphs
- Unit 3: Managing Tables and Lists
- Unit 4: Creating and Managing References
- Unit 5: Inserting and Formatting Graphic Elements
- Unit 6: Managing Document Collaboration
The MOS Word 2019 & 365 Expert Course Includes the Following Units:
- Unit 1: Managing Document Options & Settings
- Unit 2: Using Advanced Editing & Formatting
- Unit 3: Creating Custom Document Elements
- Unit 4: Using Advanced Word Features
The MOS PowerPoint 2019 & 365 Associate Course Includes the Following Units:
- Unit 1: Managing Presentations
- Unit 2: Managing Slides
- Unit 3: Inserting & Formatting Text, Shapes, & Images
- Unit 4: Inserting Tables, Charts, SmartArt, 3D Models, & Media
- Unit 5: Applying Transitions & Animations
The MOS Outlook 2019 & 365 Associate Course Includes the Following Units:
- Unit 1: Managing Settings & Processes
- Unit 2: Managing Messages
- Unit 3: Mail Settings & Formatting
- Unit 4: Managing Schedules
- Unit 5: Managing Contacts & Tasks
The MOS Access 2019 & 365 Expert Course Includes the Following Units:
- Unit 1: Managing Databases
- Unit 2: Creating & Modifying Tables
- Unit 3: Creating & Modifying Queries
- Unit 4: Modifying Forms in Layout View
- Unit 5: Modifying Reports in Layout View
Course delivery details
Course Format:Online Course
1-2 Working Days (Email)
You can start this course at any time, and you would be registered for a one-year period. You also have access to a personal tutor who can be contacted by email. Your tutor is available to assist with any queries and to mark your assignments for the Awarding Body.
As the course is self-study, you can complete it as quickly as you like. Support extensions are available if students do not complete the course within the one-year period.
Request info
Distance Learning Centre - Self-study, online and distance learning courses
The Distance Learning Centre is one of the leading and longest established suppliers of distance learning courses, open learning, home study, and correspondence courses in the UK. Providing distance learning courses since 1994, the Distance Learning Centre has grown to...