Microsoft Office : Beginner Training 2016

Microsoft Office 2016 Beginner Training

Do you need to get to grips with Microsoft Office?

Microsoft Office is a suite of programs which are widely used in the world of work. If you work in an office environment you will almost certainly need to be able to use Microsoftoffice so its great to have a qualification on your CV proving you can use it. This course will give you a full introduction to Microsoft Office, so if you don’t have any experience then you’ll become an expert.

Our online courses offer you the opportunity to study 24/7 wherever you are in the world. These intensive on line courses are open to anyone with an interest in the topic and give you access to world-class learning led by IAP.

What skills will I gain?

• Learn master key Microsoft Office programs
• Learn to produce standard documents using word
• Gain knowledge of advance options of MS word
• Become a master of MS excel worksheets
• Gain knowledge of advance accounting calculations
• Gain creative Power Point presentation skills
• Gain a full understanding of database management
• Become an expert in MS outlook e mail management syste

COURSE CURRICULUM

Module 01 : Microsoft Word 2016

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

Module 02 : Microsoft Excel 2016

• Getting Started with Microsoft Excel
• Data Entering
• Creating Formulas and Functions
• Formatting
• Worksheet Views, Multiple Worksheets and Workbooks
• IF, VLOOKUP, and Power Functions, Security & Sharing
• Data Management, Data Analysis Tools
• PivotTables & Macros
• Exercise Files: Microsoft Excel 2016
• Microsoft PowerPoint 2016
• Getting Started with Microsoft PowerPoint
• Working with Presentations & Slides
• Adding Pictures & Contents to Slides
• Adding Shapes, Diagrams, Charts, Video, Audio, and Animation to Slides
• Preparing & Delivering the Presentation
• Reusing and Sharing Presentations
• Exercise Files: Microsoft PowerPoint 2016

Module 03 : Microsoft Outlook 2016

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

Module 04 : Microsoft Access 2016

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

Method of Assessment

• At the end of the course learners will take an online multiple choice question assessment test. This online multiple choice question test is marked automatically so you will receive an instant grade and know whether you have passed the course.
• Those who successfully pass this course will be awarded a free e-certificate, and only need to pay £19 for your printed certificate.

Certification

If you pass the exam successfully then you will be awarded a Microsoft Office 2016 Basic Level Training Certificate.

• Job hunters & School leavers
• College or University student, graduates & Teachers
• Personal assistant & Receptionist
• Assistant for company director
• Office Administrators & Office managers
• Office clerk, Marketing assistant & Administration Assistant
• Secretary or Executive
• Account assistance, Bookkeeper & Accountant
• IT professionals & Businessman

• This course requires no formal prerequisites and this certification is open to everyone

Certificate of completion

Digital certificate - Included