This course prepares students to take the Microsoft Office (Word, Excel, PowerPoint, Outlook, Access) Suite certification exam(s). Students only need to take one certification exam in order to become a Microsoft Office Specialist.
Access 2016
Microsoft Access is now much more than a way to create desktop databases. It’s an easy to use tool for quickly creating browser based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure and scalable than ever, and you can easily share your applications with colleagues.
This course will guide you through the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided in to three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access.
Excel 2016
Microsoft Excel is the standard spreadsheet application for both personal and business use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2016 training course because it covers basic, intermediate and advanced competency levels.
Our Microsoft Excel 2016 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel.
Outlook 2016
Microsoft Outlook is by far one of the most popular email applications used by millions of professionals and students all over the world. Microsoft Outlook 2016 provides better organization, search capabilities, communication and social networking features.
With this Microsoft Outlook 2016 training course, you will learn the four major components of outlook including contacts, email, calendars and tasks. This course will also touch on the OneNote application that provides a cross platform and cross application note taking tool. This course covers all the bases including Basic Outlook 2016, Intermediate Outlook 2016 and Advanced Outlook 2016.
Powerpoint 2016
Take your PowerPoint presentations to the next level with our Microsoft PowerPoint 2016 online training course! Whether you are a beginner or have experience and want to sharpen your skills, this online course will help you create professional quality presentations that will grab your audience’s attention and keep them interested from start to finish.
This course is separated in to three main sections covering Basic PowerPoint, Intermediate PowerPoint and Advanced PowerPoint lessons, which will provide an in depth review of the presentation software included in the Office 2016 suite of applications. Learn to navigate the interface effectively, insert a range of objects and how to create engaging presentations that will wow viewers. Topics will include design, customization and presentation of information using Microsoft PowerPoint 2016.
Word 2016
Microsoft Word 2016 is a very popular word processing program that can be used for both personal and business purposes. While already feature rich and critical for productivity, Microsoft continues to improve and enhance their software with each new release like the latest Microsoft Word 2016.
In this course, you will learn to navigate the interface, create documents that stand out and how to extend the use of Microsoft word beyond its traditional uses. This course will cover simple document creation, complex long documents and all aspects of the word processor. This online training course will cover three main areas including Basic Word, Intermediate Word and Advanced Word.
This course includes:
- Visual Demonstrations & Multimedia Presentations
- Quizzes & Exam Simulators
- Social Learning & Networking
- Flash Cards & Educational Games
- Enhanced Navigation and Controls
Course Outline:
Microsoft Office Access 2016 Curriculum:
Access Beginner
- 1.1 Introduction Part 1
- 1.2 Introduction Part 2
- 1.3 Elements Part 1
- 1.4 Elements Part 2
- 1.5 Reviewing Data
- 1.6 Queries Part 1
- 1.7 Queries Part 2
- 1.8 Tracking Time Part 1
- 1.9 Tracking Time Part 2
- 1.10 Tracking Time Part 3
- 1.11 Design Work With Forms
Access Intermediate
- 1.1 Relationships Part 1
- 1.2 Relationships Part 2
- 1.3 Changing Information
- 1.4 Loading Tables
- 1.5 Relating Invoices Part 1
- 1.6 Relating Invoices Part 2
- 1.7 Relating Invoices Part 3
- 1.8 Relating Invoices Part 4
- 1.9 Time Entry Form
Access Advanced
- 1.1 Queries Part 1
- 1.2 Queries Part 2
- 1.3 Queries Part 3
- 1.4 Queries Part 4
- 1.5 Reports Based On Queries
- 1.6 Adding Additional Information
- 1.7 Update Query Part 1
- 1.8 Update Query Part 1
- 1.9 Creating A Report From Scratch Part 1
- 1.10 Creating A Report From Scratch Part 2
- 1.11 Creating A Report From Scratch Part 3
Microsoft Office Excel 2016 Curriculum:
Excel Beginner
- 1.1 Tabs And Ribbons Part 1
- 1.2 Tabs And Ribbons Part 2
- 1.3 Cells Part 1
- 1.4 Cells Part 2
- 1.5 Cells Part 3
- 1.6 Cells Part 4
- 1.7 Calculations Part 1
- 1.8 Calculations Part 2
- 1.9 Calculations Part 3
- 1.10 Printing Part 1
- 1.11 Printing Part 2
Excel Intermediate
- 1.1 Menus And Keyboard Shortcuts Part 1
- 1.2 Menus And Keyboard Shortcuts Part 2
- 1.3 Menus And Keyboard Shortcuts Part 3
- 1.4 Tabs Part 1
- 1.5 Tabs Part 2
- 1.6 Formulas And Calculations Part 1
- 1.7 Formulas And Calculations Part 2
- 1.8 Formulas And Calculations Part 3
- 1.9 Formulas And Calculations Part 4
- 1.10 Importing Data Part 1
- 1.11 Importing Data Part 2
- 1.12 Invoices
Excel Advanced
- 1.1 Advanced Invoice Part 1
- 1.2 Advanced Invoice Part 2
- 1.3 Advanced Invoice Part 3
- 1.4 Advanced Invoice Part 4
- 1.5 Number Crunching
- 1.6 Creating A Pivot Table From Scratch
- 1.7 Smaller Excel Components Part 1
- 1.8 Smaller Excel Components Part 2
- 1.9 Smaller Excel Components Part 3
Microsoft Office Outlook 2016 Curriculum:
Outlook Beginner
- 1.1 Introduction Part 1
- 1.2 Introduction Part 2
- 1.3 Options For Displaying Email Messages
- 1.4 Create And Send An Email
- 1.5 Receive An Email
- 1.6 Calendar Part 1
- 1.7 Calendar Part 2
- 1.8 Contacts Part 1
- 1.9 Contacts Part 2
- 1.10 Tasks
Outlook Intermediate
- 1.1 Folder Structure Part 1
- 1.2 Folder Structure Part 2
- 1.3 Multiple Email Accounts Part 1
- 1.4 Multiple Email Accounts Part 2
- 1.5 Create A New Email Part 1
- 1.6 Create A New Email Part 2
- 1.7 Signatures
- 1.8 Calendars Part 1
- 1.9 Calendars Part 2
- 1.10 Contacts
- 1.11 Outlook Settings Part 1
- 1.12 Outlook Settings Part 2
Outlook Advanced
- 1.1 One Note Introduction Part 1
- 1.2 One Note Introduction Part 2
- 1.3 One Note And PowerPoint
- 1.4 One Note And Word
- 1.5 One Note And Outlook
- 1.6 Sharing Information
- 1.7 One Note And Mobile Devices
- 1.8 Additional Elements Part 1
- 1.9 Additional Elements Part 2
Microsoft Office PowerPoint 2016 Curriculum:
PowerPoint Beginner
- 1.1 What Is PowerPoint Part 1
- 1.2 What Is PowerPoint Part 2
- 1.3 New Presentation
- 1.4 Viewing Presentation
- 1.5 Inserting Transitions
- 1.6 More Visual Designs Part 1
- 1.7 More Visual Designs Part 2
- 1.8 More Visual Designs Part 3
- 1.9 More Visual Designs Part 4
- 1.10 Notes
PowerPoint Intermediate
- 1.1 Visual Designs With Logos And Animation Part 1
- 1.2 Visual Designs With Logos And Animation Part 2
- 1.3 Visual Designs With Logos And Animation Part 3
- 1.4 Visual Designs With Logos And Animation Part 4
- 1.5 Visual Designs With Logos And Animation Part 5
- 1.6 Exit Animation Part 1
- 1.7 Exit Animation Part 2
- 1.8 Exit Animation Part 3
- 1.9 Navigation Buttons
- 1.10 Layout Options Part 1
- 1.11 Layout Options Part 2
PowerPoint Advanced
- 1.1 Master Pages Part 1
- 1.2 Master Pages Part 2
- 1.3 Software Simulation Part 1
- 1.4 Software Simulation Part 2
- 1.5 Setting Pictures To Music
- 1.6 Advanced Animation Techniques
- 1.7 Triggers
- 1.8 Motion Path Animation
- 1.9 Video In Powerpoint
- 1.10 PowerPoint Review Part 1
- 1.11 PowerPoint Review Part 2
- 1.12 Additional Options
Microsoft Office Word 2016 Curriculum:
Word Beginner
- 1.1 Course Introduction
- 1.2 Introduction To Word Interface Part 1
- 1.3 Introduction To Word Interface Part 2
- 1.4 Introduction To Word Interface Part 3
- 1.5 View
- 1.6 Typing Part 1
- 1.7 Typing Part 2
- 1.8 Typing Part 3
- 1.9 Typing Part 4
- 1.10 Resume Part 1
- 1.11 Resume Part 2
- 1.12 Bullet List
Word Intermediate
- 1.1 Menus And Keyboard Shortcuts Part 1
- 1.2 Menus And Keyboard Shortcuts Part 2
- 1.3 Tabs Part 1
- 1.4 Tables Part 1
- 1.5 Tables Part 2
- 1.6 Tables Part 3
- 1.7 Styles Part 1
- 1.8 Styles Part 2
- 1.9 Styles Part 3
- 1.10 Page Formatting Part 1
- 1.11 Page Formatting Part 2
- 1.12 Page Formatting Part 3
Word Advanced
- 1.1 Creating An Outline
- 1.2 Inserting Images Part 1
- 1.3 Inserting Images Part 2
- 1.4 Tracking Changes
- 1.5 Mail Merge Part 1
- 1.6 Mail Merge Part 2
- 1.7 Large Documents Part 1
- 1.8 Large Documents Part 2
- 1.9 Other Word Functions Part 1
- 1.10 Other Word Functions Part 2
- 1.11 Document Comparison
All necessary materials are included.
Certification(s):
This course prepares students to take the Microsoft Office (Word, Excel, PowerPoint, Outlook, Access) Suite certification exam(s). Students only need to take one certification exam in order to become a Microsoft Office Specialist.