skip navigation

Florida Gulf Coast University

Website Directory  

Business Applications

Training Classes

 
 

BTS Training Series

To register for training or see available classes & times, please click here.

Microsoft Office Logo 

Office 2016 is coming this summer to a computer near you! BTS is offering training to help you get up to speed with the new version of Office (see items in RED).

 

Microsoft Office 2016 - General

A New Perspective: Office 2016 Overview

Explore the basics of Word, Excel, Power Point, & Outlook, including ribbons, drop down menus and the purpose of each. Includes some of the new features of Office 2016.
Includes:

  • Purpose & Function
  • Tabs & Drop down Menus
  • Ribbons
  • Special Features 

 Excel - Basic

Building Blocks-A Foundation in Excel 2013

Build a foundation of Excel knowledge and learn to navigate Excel confidently.
Includes: 

  • Navigation & Terms
  • Entering & Editing Data
  • Multiple Worksheets
  • Ribbon
  • Finding & Replacing
  • Freezing Panes
  • Creating a Spreadsheet
  • Sorting & Filtering
  • Manipulating Cells   

All Dressed Up-Formatting & Styling Excel 2013 Workbooks

Don't let the Excel Fashion Police come knocking at your door! Learn to format your worksheet to enhance readability & presentation of data.
Includes: 

  • Formatting Text & Numbers
  • Borders & Shading
  • Printing Prep
  • Format Painter
  • Merging Cells
  • Headers & Footers
  • Styles & Themes
  • Conditional Formatting Finding
  • Sorting & Hiding 

**At least one Basic Excel course is required prior to taking an Intermediate or Advanced Excel course*** 

Recipe for Success in Excel 2016- Basic Ingredients

Start cooking up a tasty Excel dish with the basic ingredients. Includes:

  • Navigation & Terms
  • Entering & Editing Data
  • Multiple Worksheets
  • Ribbon
  • Finding & Replacing
  • Freezing Panes
  • Creating a Spreadsheet
  • Sorting & Filtering
  • Manipulating Cells   

Recipe for Success in Excel 2016-Spicing It Up!

Every good chef knows that spices make the dish! Learn how to "spice up" your spreadsheets with formatting and styling. Includes:

  • Formatting Text & Numbers
  • Borders & Shading
  • Printing Prep
  • Format Painter
  • Merging Cells
  • Headers & Footers
  • Styles & Themes
  • Conditional Formatting Finding
  • Sorting & Hiding 

**At least one Basic Excel course is required prior to taking an Intermediate or Advanced Excel course*** 

Excel - Intermediate

Formulas & Functions-Excel Does the Math!

Hate math? Doesn't everyone?! Let Excel 2013 do the calculating for you and get the results you need!
Includes: 

  • Creating, Copying & Editing Formulas
  • Basic Statistical Functions
  • Absolute & Relative Cell References
  • Conditional Logic
  • SUM, Auto SUM & Date Functions 

***Prerequisite: a Basic Excel course***

Recipe for Success in Excel 2016- Let Excel Do the Measuring!

A dish prepared without measuring ingredients can be a disaster! Let Excel do the measuring and get the results you want! Includes:

  • Creating, Copying & Editing Formulas
  • SUM, AVERAGE & MAX
  • Basic Statistical Functions
  • NETWORKDAYS, IF/THEN, Nested IF/THEN, VLOOKUP

 ***Prerequisite: a Basic Excel course***

Excel - Advanced

The Dynamic Duo of Visual Data-Charts & Graphs

Biff! Pow! Bam! Make your worksheet data visually dynamic & create greater impact by using charts & graphs.
Includes: 

  • Creating & Manipulating Charts 
  • Data Updating & Axes Formatting
  • Modifying Chart Titles
  • Adding Grid lines & Arrows
  • Moving & Formatting Elements
  • Using Illustrations
  • Changing Type & Organizing Source Data
  • Previewing & Printing

 ***Prerequisite: a Basic Excel course***

 Turn This Thing Around-Pivot Tables & Pivot Charts

Organize & analyze your data to evaluate it based on different variables by using Tables, Pivot Tables & Pivot Charts
Includes:

  • Creating & Formatting a Table
  • Creating & Modifying a Pivot Table
  • Maintaining, Sorting & Filtering Data
  • Understanding Pivot Charts
  • Understanding Pivot Tables
  • Creating a Pivot Chart 

***Prerequisite: a Basic Excel course***

 Recipe for Success in Excel 2016-Adding the Garnish!

Every dish needs some garnish to make it "pop"! Make your data visually dynamic & create greater impact by using charts & graphs. Includes:

  • Creating & Manipulating Charts 
  • Data Updating & Axes Formatting
  • Modifying Chart Titles
  • Adding Grid lines & Arrows
  • Moving & Formatting Elements
  • Using Illustrations
  • Changing Type & Organizing Source Data
  • Previewing & Printing

***Prerequisite: a Basic Excel course***

Recipe for Success in Excel 2016-The Gourmet Chef

Organize & analyze your gourmet mix of complex data ingredients based on different variables by using Tables, PivotTables & PivotCharts. Includes:

  • Creating & Formatting a Table
  • Creating & Modifying a Pivot Table
  • Maintaining, Sorting & Filtering Data
  • Understanding Pivot Charts
  • Understanding Pivot Tables
  • Creating a Pivot Chart 

***Prerequisite: a Basic Excel course***

Outlook - Basic

Making Outlook Work for You-Work Smarter, Not Harder!

Make Outlook work the way you work. Discover best practices, options, & tools to streamline and customize Outlook to function on your terms!
Includes:

  • Inbox Organization
  • Contacts & Groups
  • Message Customization
  • Folders
  • Signatures, Font Sizes, Delivery Receipts
  • Calendar & Tasks  

Working With Outlook 2016- Do It Your Way!

Make Outlook work the way you work! Discover best practices,options and tools to streamline and customize Outlook to function on your terms!Includes: 

  • Inbox Organization
  • Contacts & Groups
  • Message Customization
  • Folders
  • Signatures, Font Sizes, Delivery Receipts
  • Calendar & Tasks  

Outlook - Intermediate

I Spy-Sharing Calendars & Mailboxes

Planning and coordinating with others is easy once you know how! Learn about sharing Calendars & Mailboxes to enhance communication with colleagues…and supervisors!
Includes: 

  • Sharing Calendars
  • Viewing Shared Calendars
  • Using Calendar Groups
  • Sharing Mailboxes
  • Scheduling Meetings & Inviting Attendees 
  • Response Etiquette

Show Me Whatcha Got!-Sharing Calendars & Mailboxes in Outlook 2016

Planning and coordinating with others is easy once you know how! Learn about sharing Calendars & Mailboxes to enhance communication with colleagues…and supervisors! Includes: 

  • Sharing Calendars
  • Viewing Shared Calendars
  • Using Calendar Groups
  • Sharing Mailboxes
  • Scheduling Meetings & Inviting Attendees 
  • Response Etiquette

 Keeping It Under the Limit- (Cruise) Controlling Your Mailbox

Tired of getting messages that your mailbox has reached its limit? Learn how to archive your messages, view the size of your messages, and clean up your mailbox.
Includes: 

  • Reading Pane
  • Mailbox & Message Size
  • Clutter
  • Conversation View
  • Mailbox Cleanup
  • SPAM Filter 

Keep It Clean-Manage Your Mailbox Mess in Outlook 2016 

Reached your limit along with your mailbox?  Clean up your mailbox mess! Learn how to archive your messages, view the size of your messages, and clean up your mailbox. Includes:  

  • Reading Pane
  • Mailbox & Message Size
  • Clutter
  • Conversation View
  • Mailbox Cleanup
  • SPAM Filter  

Outlook - Advanced

Sorting and Storing and Searching…Oh My!

Organize your tasks, categorize your emails, and use Outlook features to stay better organized and make it through the forest of your busy schedule unscathed!Includes:

  • Categories
  • Searching & Arranging
  • People Pane
  • Rules
  • Mailbox Cleanup Tools
  • Flagging
  • Folder Management 

 I Didn’t Know Outlook Could Do That! Tips, Tricks & Timesavers

Tired of typing in the same message every time when you send that weekly report? Did you know you can create it once and use it again and again? Learn this trick and several others to save time and effort! Includes: 

  • Quick Parts
  • Quick Steps
  • Find
  • Favorites 

 Organizing Your Outlook 2016 Closet

Use the features of Outlook to organize your mailbox closet and find Message, Task and Folder socks that match! Includes: 

  • Categories
  • Searching & Arranging
  • People Pane
  • Rules
  • Mailbox Cleanup Tools
  • Flagging
  • Folder Management 

Quick Steps to Saving Time in Outlook 2016

Tired of turning in circles every time you want to send the same message? Learn some new dance steps and save time and energy; you've never been so light on your feet! Includes: 

  • Quick Parts
  • Quick Steps
  • Find
  • Favorites  

PowerPoint - Basic

PowerPoint Construction Zone I: Laying a Foundation

Grab your hard hat and learn to build a simple Power Point presentation using the basic tools and functions.
Includes:

  • Tips For Effective Presentations
  • Text Boxes & Backgrounds
  • Ribbon
  • Views, Display & Notes
  • Templates & Themes
  • Saving & Printing 

 PowerPoint 2016 Fashion Design I- Foundation Garments!

Howdo you begin building a great outfit? Why, from the bottom up, of course! Build your PowerPoint presentation the same way...with the proper foundation! Includes:

  • Tips For Effective Presentations
  • Text Boxes & Backgrounds
  • Ribbon
  • Views, Display & Notes
  • Templates & Themes
  • Saving & Printing 

PowerPoint - Intermediate

PowerPoint Construction Zone II: Raising the Roof!

Construction on our PowerPoint house continues as we explore creation of more complex and detailed Power Point presentations.
Includes: 

  • Transitions, Animations & Timing Effects
  • Saving & Printing
  • Inserting Photos
  • Videos & Spreadsheets

 PowerPoint 2016 Fashion Design II-Dressing For Success

Style is everything...provided it's appropriate, of course! Learn to create a stylish PowerPoint presentation with just the right panache! Includes:

  • Transitions, Animations & Timing Effects
  • Saving & Printing
  • Inserting Photos
  • Videos & Spreadsheets

PowerPoint - Advanced

PowerPoint Construction Zone III: Landscaping

Our Power Point structure is done-now it's time to create some additional curb appeal with those final decorative touches!
Includes:

  • Add-ins
  • Comments
  • Audio (narration)
  • Screen Recording

PowerPoint 2016 III-Accessorizing!

What's an outfit without the right accessories? Make your presentation runway-ready with PowerPoint's special design tools. Includes:

  • Add-ins
  • Comments
  • Audio (narration)
  • Screen Recording

Word - Basic

Course titles for Word 2016 training will remain the same as the current offerings; however, content will be revised to include new Office 2016 features. The updated classes will begin in July.

What’s the Word? The In(sert)s & (Lay)outs of Document Creation in Word

Word has LOTS of options and capabilities! Explore the Word toolbar and function of each tab as used in the creation of a Word document.
Includes: 

  • Home
  • Page Layout
  • Data View
  • Insert Formulas
  • Review Templates 

 Filling In the Blanks-Creating Forms in Word

Creating professional forms for data-gathering is easy in Word! Learn to develop forms for surveys, checklists, waivers, etc. that are easily modifiable to meet changing demand.
Includes: 

  • Document Setup
  • Content Control-adding, setting, changing properties
  • Templates
  • Instructional Text
  • Converting Text to Tables
  • Document Protection  

Word - Intermediate

Organizing Content in Word: When Bullets, Tabs & Numbering Go Astray!

Using bullets and numbering emphasizes important information, but what happens when things get out of whack? Learn to customize and corral document features to enhance readability.
Includes:

  • Creating a List
  • Indenting
  • Tabs
  • Customizing Toolbar

 
Picture This: Tables, Charts & Graphs in Word

They say a picture’s worth a thousand words, so stop talking and start showing! Using tables, charts and graphs in your documents will spice up your info and enhance reader understanding.
Includes:

  • Inserting Tables
  • Page Orientation
  • Columns
  • Illustrations & Graphics
  • Charts & Graphs  

Word - Advanced

Be Vewy, Vewy Quiet-We’re Tracking Document Changes

Tired of hunting down colleagues to discuss changes to a collaborative document? Using the Track Changes function in Word will streamline the process faster than Elmer Fudd can say,"Shhhh…we're hunting wabbits!!"
Includes: 

  • Finding Track Changes
  • Restricting Editing
  • Controlling Track Changes
  • Document Comparison
  • Reviewing, Accepting & Rejecting Changes
  • Document Recovery

How Accessible Are You? Using the Accessibility Checker in Word

What the heck is the Accessibility Checker? Learn what, why, and how to use the Checker in Word 2013 to meet ADA compliance for online documents.
Includes: 

  • Need for Accessibility
  • Accessibility Checker Use & Function
  • Document Version Errors
  • Warnings, & Tips

 Communication Traffic Control-Mail Merge Can Increase Your Speed Limit!

Tired of creating individual letters and address labels? Learn to utilize distribution lists to create letters & labels for mass mailings by snail mail or mass email messages.
Includes: 

  • Mailings Tab & Functions
  • Mail Merge Wizard
  • Mail Merge Process 

Technology Security - General

  Get Secure!     Cy Bersecure

Everyone's a target, but don't be a victim! Learn to protect yourself, your devices and sensitive data from cyber-criminals.
Includes: 

  • Identity & Personal Info Protection
  • Computer & Device Protection
  • Email Phishing
  • Social Media
  • Passwords
  • Encryption
  • FGCU Restricted Data
  • Security Tips  

Mac - General

Biting Into the Apple- Office 2016 for Mac

Office 2016 is coming soon to a Mac near you! Join us for this overview of the Office 2016 transition on campus Macs and a preview of the new features in Office 2016. Includes: 

  • Deployment Plan Strategy
  • What's New in Office 2016