Whatever your situation is we’ve got you covered. This course covers the whole Microsoft suite, so whether you’re a beginner, or have some experience, you’ll soon have a wealth of knowledge and skills. Having a recognised qualification on your CV is extremely useful and shows potential employers that you can use Microsoft to the highest standards.Learn Microsoft Office 2016 and boost your confidence. Discover new features in the applications and become more effective and productive in the workplace. Learn to accomplish office tasks quickly and efficiently. This course will get you up to speed on Microsoft applications, and you will be able to master the improved features and functions. Getting certified in this course will give you the opportunity to work across a range of sectors in multiple positions.
Key components (software) you will study in this course:
Learning with Study 365 has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.
This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests, and exams. All delivered through a system that you will have unlimited access. An effective support service and study materials will build your confidence to secure your qualification.
This course is designed for those who wish to develop their skills using Microsoft Office applications. This qualification is helpful for any office job, such as Admin Assistant, Administrator, or Office Manager.
This course is comprehensive and covers the modules listed below under the curriculum.
Microsoft Office Word
Working with long text documents, paragraphs, tab stops, page setup, tables, columns, styles, illustrations, templates and proofreading documents.
Microsoft Office Excel
Creating cell data, formatting cells and worksheets, managing worksheets and workbooks, Formulas and Functions (basic and more complex, including absolute cell referencing), charts, conditional formatting, sorting and filtering data, data protection.
Microsoft Office Power-Point
Managing the PowerPoint environment, using templates and themes, creating and formatting slides and sections, applying transitions and animations and timings, insert video and sounds, using pointer options, creating custom slide shows and a photo album, working with slide masters.
Microsoft Office Access
Understanding table creation and design. Finding, editing, sorting and filtering data to highlight key information. Building table relationships and enforcing referential integrity to keep data “clean”. A basic introduction to functions and using the formula creator. Using aggregate functions and totals to simplify calculations.
Microsoft Office Outlook
Working with email effectively; managing appointments, meetings, contacts, and to do lists; and finally linking and synchronisation.
At the end of the course, learners will take an online multiple choice question assessment test. The online test is marked straightaway, so you will know immediately if you have passed the course.
Successful candidates will be awarded a “Diploma in Microsoft Office 2016”.
Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.
You can use this certification to demonstrate your understanding of Microsoft Office 2016 to potential organisations and gain the desired job role. You will be eligible for a raise or incentives put forth by the organisation. Given below are job titles you can land, along with the average UK salary per annum according to https://www.payscale.com/
We do not provide software with this course, you will need to have the MS Office Package on your computer or have access to a computer which has MS Office on it.
Getting Started | |||
E Certificate Download Guide | 00:00:00 | ||
1: MICROSOFT WORD 2016 | |||
Introduction to Microsoft Word | 00:01:00 | ||
First Step to MS Word | 00:31:00 | ||
Text Editing & Formatting | 00:44:00 | ||
Formatting Paragraph and Pages | 00:48:00 | ||
Creating Styles, Themes, Number and Bullets | 00:39:00 | ||
Columns & Tables | 01:33:00 | ||
Macros and Proofing | 00:33:00 | ||
Sharing and Reviewing Documents | 00:27:00 | ||
Modify Word Document | 00:15:00 | ||
Exercise Files: Microsoft Word 2016 | |||
2: MICROSOFT EXCEL 2016 | |||
Getting Started with Microsoft Excel | 00:42:00 | ||
Data Entering | 00:24:00 | ||
Creating Formulas and Functions | 00:41:00 | ||
Formatting | 01:02:00 | ||
IF, VLOOKUP, and Power Functions, Security & Sharing | 00:51:00 | ||
Data Management, Data Analysis Tools | 01:20:00 | ||
PivotTables & Macros | 01:21:00 | ||
Exercise Files: Microsoft Excel 2016 | |||
3: MICROSOFT POWERPOINT 2016 | |||
Getting Started with Microsoft PowerPoint | 00:10:00 | ||
Working with Presentations & Slides | 00:37:00 | ||
Adding Pictures & Contents to Slides | 00:46:00 | ||
Adding Shapes, Diagrams, Charts, Video, Audio, and Animation to Slides | 00:39:00 | ||
Preparing & Delivering the Presentation | 00:26:00 | ||
Reusing and Sharing Presentations | 00:20:00 | ||
Exercise Files: Microsoft PowerPoint 2016 | |||
4: MICROSOFT OUTLOOK 2016 | |||
Getting Started with Outlook | 00:08:00 | ||
Adding and Connecting Accounts, Reading & Organizing Mails | 01:02:00 | ||
Creating and Sending Mail, Creating and Working with People | 00:44:00 | ||
Working with Delegates & Calendars | 00:40:00 | ||
Creating Tasks and Notes, Working with Outlook Data | 00:13:00 | ||
5: MICROSOFT ACCESS 2016 | |||
Introduction to MS Access | 00:35:00 | ||
Creating Tables & Setting up Properties | 01:04:00 | ||
Queries | 01:32:00 | ||
Creating Forms & Reports | 02:13:00 | ||
Working with Macros, Integrating Access with Office Suite | 00:34:00 | ||
Database Management | 00:28:00 | ||
Exercise Files- Microsoft Access 2016 | |||
Mock Exam | |||
Mock Exam: Microsoft Office 2016 | 00:30:00 | ||
Final Exam | |||
Final Exam: Microsoft Office | 00:30:00 |