Microsoft Office

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


Learners will gain a fundamental understanding of this database application's environment and basic database principles. They will be able to demonstrate the correct use of key features and the ability to create and maintain tables, relationships, forms, reports, and queries.

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