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.

Course 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

You 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.

Course 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.

Course 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.

Course 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.

Course 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.

Course 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.

Course Objectives:

  • Create and manage documents
  • Format text, paragraphs, and sections
  • Create tables and lists
  • Create and manage references
  • Insert and format graphic elements
Sign up for updates and specials!Get news and great offers from Atlantic Speaker Bureau and Human Skills Development in your inbox.

Subscribe to our weekly newsletter below and never miss the latest product or an exclusive offer.

About Our Courses
  • Convenient: e-learning allows you to balance the demands of work, career and home life by accessing learning from anywhere anytime – from home, work and even on the road. On-Demand learning is available 24/7/365!
  • ​Immediate: You can start an on-demand course in a matter of minutes! Be done in one sitting (about four to five hours) or take as long as you like to complete and download your certificate from your account.
  • Ease of Use: Click away and get the knowledge you need.
  • Flexible: You decide when you want to take an On-Demand course. If you only have time at night, no worries make your own schedule and do the course at your own pace.
  • Cost-Effective: Studies show that online learning can save an organization 50-70% of training expenses.
  • Quality: All of our on-demand courses are built by subject matter experts and adult education course designers

Your course includes

    • Student Manual PDF Download
    • Real-Life Examples and Take-ways
    • Videos
    • Audio
    • Case Studies
    • Quizzes
    • Activities
    • Certificate of Completion
    • Un-Limited Access and Re-Takes
    • Completion Time is approximately 6 hours
    • Volume Discounts Available