Certificate in Microsoft Office 2016 Essential

Global Edulink, gives you the opportunity to gain skills and knowledge regarding the key components (software) of Microsoft Office 2016 and it will allow you to take your skills to a higher level.Also, by doing this course, you will have an advantage if you plan to take the Microsoft Office Specialist (MOS) official exam as well. As a result of this, you will become more confident and efficient in the work place.

Key components (software) you will learn from Microsoft Office Package

• Microsoft Office Excel 2016
• Microsoft Office Power-Point 2016
• Microsoft Office Word 2016
• Microsoft Outlook 2016
• Microsoft Office Access 2016

Course Curriculum

MIicrosoft word 2016

• Creating Styles, Themes, Number and Bullets
• Introduction to Microsoft Word
• Text Editing & Formatting
• Formatting Paragraph and Pages
• Columns & Tables
• First Step to MS Word
• Macros and Proofing
• Sharing and Reviewing Documents
• Modify Word Document
• Exercise Files: Microsoft Word 2016

Microsoft word 2016

• Creating Formulas and Functions
• Getting Started with Microsoft Excel
• Data Entering
• Formatting
• Worksheet Views, Multiple Worksheets and Workbooks
• Data Management, Data Analysis Tools
• PivotTables & Macros
• IF, VLOOKUP, and Power Functions, Security & Sharing
• Exercise Files: Microsoft Excel 2016

Microsoft PowerPoint 2016

• Adding Pictures & Contents to Slides
• Working with Presentations & Slides
• Preparing & Delivering the Presentation
• Reusing and Sharing Presentations
• Adding Shapes, Diagrams, Charts, Video, Audio, and Animation to Slides
• Exercise Files: Microsoft PowerPoint 2016
• Getting Started with Microsoft PowerPoint

Microsoft Outlook 2016

• Creating and Sending Mail, Creating and Working with People
• Adding and Connecting Accounts, Reading & Organizing Mails
• Working with Delegates & Calendars
• Creating Tasks and Notes, Working with Outlook Data
• Getting Started with Outlook

Microsoft Access 2016

• Introduction to MS Access
• Creating Forms & Reports
• Queries
• Working with Macros, Integrating Access with Office Suite
• Database Management
• Exercise Files- Microsoft Access 2016
• Creating Tables & Setting up Properties

Benefits

• High-quality e-learning study materials and mock exams.
• 24/7 Access to the Learning Portal.
• Recognised Accredited Qualification.
• Excellent customer service and administrative support.
• The benefit of applying for NUS extra Discount Card.
• Tutorials/materials from the industry leading experts.

Eligibility / Requirements

• Learners should be ages 16 or over to undertake the qualification.
• Basic understanding of English language, literacy, numeracy and ICT are required to attend this course.
• This course is available to all students, of all academic backgrounds. However, basic knowledge of Microsoft Office would be an advantage.