Access 2016 Essentials

Access 2016 Essentials

Access 2016 Essentials

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.

Workshop 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

 

PowerPoint 2016 Essentials

PowerPoint 2016 Essentials

PowerPoint 2016 Essentials

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.

Workshop 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

 

Excel 2016 Expert

Excel 2016 Expert

Excel 2016 Expert

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.

Workshop 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

 

Excel 2016 Essentials

Excel 2016 Essentials

Excel 2016 Essentials

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.

Workshop Objectives:

  • Create worksheets and workbooks
  • 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

 

Outlook 2016 Essentials

Outlook 2016 Essentials

Outlook 2016 Essentials

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 email for marketing campaigns, planning staff meetings, and assigning action items from those meetings.

Workshop 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 stationary
  • 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

 

Word 2016 Expert

Word 2016 Expert

Word 2016 Expert

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 to enhance productivity. Examples of expert-level documents include a business plan, a research paper, a specialized brochure, and a mass mailing.

Workshop Objectives:

  • Control Pagination
  • Work with styles
  • Perform advanced editing and formatting
  • Create and manage indexes
  • Create and manage references
  • Manage forms and fields
  • Create mail merge and labels
  • Create and modify building blocks and content controls
  • Work with Macros
  • Create custom style sets, themes, and templates
  • Prepare a document for internationalization and accessibility
  • Work with templates
  • Use version control
  • Manage document reviews and changes

 

Word 2016 Essentials

Word 2016 Essentials

Word 2016 Essentials

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.

Workshop Objectives:

  • Create and manage documents
  • Format text, paragraphs, and sections
  • Create tables and lists
  • Create and manage references
  • Insert and format graphic elements