This course covers the integrated components of MS Office 2016. Among the numerous topics covered are: How to use Word , Excel, PowerPoint, SharePoint, Outlook, OneNote, and Access. Students will learn basic computer skills, how to use domain and public email, Skype and chat, Windows 7/8/10, how to create folders and files, renaming folders and files. In Excel, students will learn formulas and functions, pivot tables, lookup functions, macros, structured references, and array formulas. In Word, students will learn to create presentations, use different layouts, work on transitions and animations, macros developer tools, perform mail merge. In PowerPoint, students will learn to design a presentation, use different layouts, work on transitions and animations, create slide shows, and work with audio and videos. At the end of the training, students will have the opportunity to get certified as a Microsoft Office Specialist.
Course Outline
- Microsoft Word 2016
- Microsoft Excel 2016
- Microsoft Powerpoint 2016
- Microsoft Access 2016
- Microsoft Outlook 2016
This Series course covers the basic functions and features of Word 2016. This course will help students prepare for the Microsoft Office Specialist for Word 2016 (Exam 77-418).
- Getting started
- Navigation and selection technique
- Editing text
- Formatting text
- Tables
- Page layout
- Proofing and printing documents
- Graphics
- Styles and outlines
- Sections and columns
- Formatting tables
- Printing labels and envelopes
- Templates and building blocks
- Graphics
- Managing document revisions
- Logical and statistical functions
- Financial and date functions
- Lookups and data tables
- Advanced data management
- Exporting and importing
- Analytical tools
- Macros and custom functions
This Series course teaches the basic functions and features of Excel 2016. This course will help students prepare for the Microsoft Office Specialist for Excel 2016 (Exam 77-420).
- Getting started
- Entering and editing data
- Modifying a worksheet
- Functions
- Formatting
- Printing
- Charts
- Managing large workbooks
- Using multiple worksheets and workbooks
- Advanced formatting
- Outlining and subtotals
- Cell and range names
- Tables
- Web and sharing features
- Advanced charting
- Documenting and auditing
- Templates and settings
- Using multiple worksheets and workbooks
- Advanced formatting
- Outlining and subtotals
- Cell and range names
- Tables
- Web and sharing features
- Advanced charting
- Documenting and auditing
- Templates and settings
This Series course covers the basic functions and features of PowerPoint 2016. This course will help students prepare for the Microsoft Office Specialist for PowerPoint 2016 (Exam 77-422).
- Getting started
- New presentations
- Formatting slides
- Using drawing objects
- Working with graphics
- Using tables and charts
- Modifying presentations
- Proofing and delivering presentations
- Customizing PowerPoint
- Using graphics and multimedia
- Customizing SmartArt graphics and tables
- Action buttons, custom slide shows, and equations
- Distributing presentations
- Integrating Microsoft Office files
This Series course covers the basic functions and features of Access 2016. This course will help students prepare for the Microsoft Office Specialist for Access 2016 (Exam 77-424).
- Getting started
- Databases and tables
- Fields and records
- Data entry rules
- Basic queries
- Using forms
- Working with reports
- Relational databases
- Related tables
- Complex queries
- Advanced form design
- Reports and printing
- Charts
- PivotTables and Pivot Charts
- Querying with SQL
- Advanced queries
- Macros
- Advanced macros
- Importing, exporting, and linking
- Database management
This Series course covers the basic functions and features of Outlook 2016. This course will help students prepare for the Microsoft Office Specialist for Outlook 2016 (Exam 77-423).
- Getting started
- E-mail management
- Contacts management
- Tasks
- Appointments and events
- Meeting requests and responses
- Customizing Outlook
- Customizing messages
- Organizing items
- Working with folders
- Organizing Mail
- Collaboration
- Mailbox management
- The Notes and Journal folders
- Calendars and contacts
- Mail merges and templates
Get Started Today