Participants will learn to proficiently use the advanced features of Microsoft Word for document content management and advanced formatting - critical skills for those in roles such as editors, project managers, business information workers, and educators. Participants will create and manage professional multi-page documents for a variety of specialized purposes and situations. They will customize their Word 2016 environments to meet project needs and enhance productivity. Examples of expert-level documents include a business plan, a research paper, a specialized brochure, and a mass mailing.
Objectives:
- Control Pagination
- Work with styles
-
Perform advanced editing and formatting
Manage document reviews and changes
Use version control
Work with templates
Prepare a document for internationalization and accessibility
Create custom style sets, themes, and templates
Work with Macros
Create and modify building blocks and content controls
Create mail merge and labels
Create and manage references
Create and manage indexes
Manage forms and fields
Participants will gain a fundamental understanding of the Microsoft Word environment and the ability to complete tasks independently. They will demonstrate the correct application of the principle features of Word 2016 by creating and editing documents for a variety of purposes and situations. Document examples include professional-looking reports, multi-column newsletters, resumes, and business correspondence.
Objectives:
- Create and manage documents
- Format text, paragraphs, and sections
- Create tables and lists
- Create and manage references
- Insert and format graphic elements
Participants will learn to create, edit, and enhance slideshow presentations to create professional-looking sales presentations, employee training, instructional materials, and kiosk slideshows. Learners will gain a fundamental understanding of the PowerPoint 2016 environment and the correct use of key features of this application.
Objectives
- Create Presentations from scratch or templates
- Insert and format slides, handouts, and notes
- Change Presentation views and configurations
- Insert and work with text, pictures, audio and video
- Work with tables, charts, and SmartArt
- Use transitions and animations
- Prepare for a presentation, including the slide size, narration, and timing
- Manage multiple presentations
Learners will be able to use Outlook to enhance professional correspondence, create calendars, and schedule appointments. Participants will create and edit professional-looking email messages, maintain calendars across time zones, and schedule tasks for a variety of purposes and situations including sending emails for marketing campaigns, planning staff meetings, and assigning action items from those meetings.
Objectives:
- Connect one or more email accounts
- Preview, read, reply to, and forward messages
- Process, create, format, and check messages
- Use advanced message options
- Organize messages
- Use signatures and stationery
- Automate replies and organization
- Clean up and archive messages
- Create, organize, and manage calendars, appointments, meetings, and events
- Create and manage notes and tasks
- Create and manage contacts and contact groups
- Customize the Outlook environment settings
- Print and save Information
- Perform search operations in Outlook
Participants will gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program's full features - critical skills for those in roles such as accountants, financial analysts, and commercial bankers.
Participants will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel 2016 environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.
Objectives:
- Save a workbook as a template, with colors, fonts, cell styles and themes
- Reference data using structured references or data in another workbook
- Protect a workbook from further editing
- Prepare a workbook for internationalization
- Apply custom data formats and validation
- Apply advanced conditional formatting and filtering
- Use form controls
- Work with macros
Participants will gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program's full features - critical skills for those in roles such as accountants, financial analysts, and commercial bankers.
Participants will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel 2016 environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.
Objectives:
- Create worksheets and workbook
- Navigate in worksheets and workbooks
- Format worksheets and workbooks
- Change views and configurations
- Print and distribute worksheets and workbooks
- Manage data cells and ranges
- Create tables, charts, and objects
- Perform operations with formulas and functions
Objectives:
- Create and modify databases
- Manage relationships and keys
- Navigate through a database
- Protect and maintain databases
- Print and export data
- Create and manage tables
- Manage records in tables
- Create and modify fields
- Create a query
- Modify a query
- Create calculated fields and grouping within queries