After completing this class, you should be able to:

• Use relative and absolute references
• Apply sorting and filtering tools
• Use conditional formulas and other functions
• Apply defined names and formula auditing tools
• Apply hyperlinks
• Apply conditional formatting and cell styles

Adobe Captivate goes beyond just screen capture. Adobe Captivate software records all on-screen actions and instantly creates professional-quality Flash simulations complete with text captions, mouse movements, and scored interactions, without programming. This course is designed to cover the basic features. Adobe Captivate is ideal for faculty, staff, and anyone who might need to create a web-based tutorial for clients, employees or students.

Prerequisite skills: Basic familiarity with a computer mouse, keyboard, and the Windows 7/XP operating system.

After completing this class, you should be able to:

• Identify parts of the Excel user interface
• Navigate a worksheet and a workbook
• Enter and edit data
• Build simple formulas
• Format cells
• Format worksheets
• Save and print worksheets

Microsoft Teams is a collaboration tool that incorporates general communication options with various apps to enhance productivity for groups of people called Teams.  In this live, instructor-led workshop, after we cover the following topics, you will have the opportunity to practice using Teams:

• Microsoft Teams Environment
• Navigation and General Settings
• Using the Chat feature
• Making Audio and Video Calls
• Creating Meetings via Calendar and Outlook
• File Sharing and Collaboration
• Setting up Teams and Channels

Microsoft 365 in the online version of the Microsoft Office suite of applications. This overview covers the basics of logging into Office 365 and navigating through the different online apps such as Outlook, OneDrive, Word, and OneNote.

Microsoft Office OneNote is a digital notebook that provides a flexible way to gather notes and information, powerful search capabilities so users can find what they are looking for quickly, and easy-to-use shared notebooks that help teams work together more effectively.

At the end of this course, students will be able to:

• Understand the OneNote screen Layout
• Create notebooks and sections
• Move & delete pages, sections, or notebooks
• Transfer notes, drawings and pictures on a page
• Use the Side Note
• Use OneNote with other Office programs

After completing this class, you should know how to:

• Customize the Calendar and Navigation Pane
• Adjust personal calendar settings
• Managing Your Own Calendar
  • View your calendar
  • Create appointments and events
  • Schedule a recurring entry
  • Edit calendar entries
• Meetings
  • Create a meeting
  • Respond to a meeting invitation
  • Make changes to a meeting
• Sharing calendars
  • Share your calendar
  • View others' calendars
  • View public calendars
• Use the Schedule View and Calendar Groups

Prerequisite skills: Basic familiarity with a computer mouse, keyboard, and the Windows 7/XP operating system.

This hands-on class provides you with the tools that you need to navigate the Outlook 2007 screen, work effectively with e-mail, and manage your contact information.

After completing this class, you should be able to:

• Identify and customize the parts of the Outlook screen and Navigation Pane
• Create, send, open, reply to, forward and close e-mail messages
• Sort and group e-mails
• Spell-check e-mails
• Open, save and preview attachments
• Create a folder
• Move e-mails into folders
• Delete unwanted e-mails
• Turn on the Out of Office Assistant
• Use the Global Address Book and Contacts
• Build a distribution list

Microsoft Teams is a collaboration tool that incorporates general communication options with various apps to enhance productivity for groups of people called Teams.  In this live, instructor-led workshop, after we cover the following topics, you will have the opportunity to practice using Teams:

• Microsoft Teams Environment
• Navigation and General Settings
• Using the Chat feature
• Making Audio and Video Calls
• Creating Meetings via Calendar and Outlook
• File Sharing and Collaboration
• Setting up Teams and Channels

By the end of this course, you should be able to:

• Create a chart from data in an Excel spreadsheet
• Choose from the various chart types
• Apply built-in chart layouts and styles
• Save a chart as a template
• Print a chart