University of Vermont

Human Resource Services  –  Trusted Partner…Smart Solutions.

Banner Navigation
    Loading
Software Classes

Software Proficiency

Access - Basics

Facilitator: Brett Neal
Target Audience: Beginning Microsoft Access Users
Time Allotted: 3 hours
PeopleSoft Course Number: CPT029

Overall Objectives: This class is designed for those who wish to learn the basic operations of the Access database program.

Learning Outcomes:

  • Identify the elements of the Access program
  • Create a new database
  • Modify table data
  • Create a query
  • Create a form

Pre and Post-Class Actions Required


Access - Intermediate

Facilitator: Brett Neal
Target Audience: Users who are interested in building on basic Access knowledge
Time Allotted: 3 hours
PeopleSoft Course Number: CPT040

Overall Objectives: Gain experience using the next level of Access tools.

Learning Outcomes:

  • Constrain data entry using field properties
  • Create query joins
  • Set the select query properties
  • Organize information with tab pages
  • Create and view reports

Pre and Post-Class Actions Required


EMS – Basics

Facilitator: Lina Balcom, Heather Cochran
Target Audience: Beginning EMS users
Time Allotted: 1.5 hours
PeopleSoft Course Number: CPT038

Overall Objectives:Users will explore the features of Virtual EMS, the campus space reservation portal. The course will address basic level functions.

Learning Outcomes:

  • Learn the process for requesting use of space on campus for meetings and events
  • Learn how to order Catering for meetings and events
  • Learn how to get your events published to the Campus Calendar
  • Learn how to request a Catering Waiver for a meeting or event

Pre and Post-Class Actions Required


EMS – Advanced

Facilitator: Lina Balcom, Heather Cochran
Target Audience: Users with basic EMS knowledge
Time Allotted: 1.5 hours
PeopleSoft Course Number: CPT037

Overall Objectives:This session is for those who are frequent EMS users. Advanced features of the software will be explored and tips and tricks to help with more complicated events will be given.

Learning Outcomes:

  • Learn how to reserve space for reoccurring events
  • Learn how to add services to an event once space has been requested
  • Learn how to view Historical events
  • Learn how to view Room Detail information
  • Learn how to set user preferences

Pre and Post-Class Actions Required


Excel 2013 – Basics Level 1

Facilitator: Brett Neal
Target Audience:This class is designed for the beginning or basic user.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT001

Overall Objectives: At the end of this course, participants will be able to create basic spreadsheets using Excel 2013.

Learning Outcomes:

  • Know the terms associated with Excel including Ribbons, Tabs, Groups and Back Stage View
  • Create worksheets and apply basic formatting to achieve data organization goals
  • Describe specific components of Excel Worksheet software
  • Edit data and worksheets to fit specific needs
  • Practice Excel skills utilizing real-world examples

Pre and Post-Class Actions Required


Excel 2013 – Basics Level 2

Facilitator: Brett Neal
Target Audience: This class is designed for beginner or basic users who have completed Basic Excel Level 1 or are proficient with the topics covered in that class.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT023

Overall Objectives: To instruct basic users how to create and manage multiple worksheet workbooks.

Learning Outcomes:

  • Create, modify and format worksheets
  • Demonstrate how to use Data Forms
  • Customize Excel Themes and Table Styles
  • Create and edit a named range
  • Demonstrate how to use Headers and Footers
  • Apply Conditional Formatting

Pre and Post-Class Actions Required


Excel 2013 – Basics Level 3

Facilitator: Brett Neal
Target Audience: This class is designed for beginner or basic users who have completed Level 1 and 2 or are proficient with the topics covered in those classes.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT015

Overall Objectives: To build on the lessons learned in Excel 2013 Basics Level One and Two, by creating and managing data in worksheets and workbooks.

Learning Outcomes:

  • Create a custom template
  • Identify different types of data
  • Rotate cell data
  • Manage data using the Data tab
  • Flash Fill data
  • Transpose columns and rows
  • Share and protect worksheets and workbooks

Pre and Post-Class Actions Required


Excel 2013 – Intermediate

Facilitator: Brett Neal
Target Audience: Users who are interested in building on basic Excel knowledge.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT016

Overall Objectives: Gain experience using intermediate formatting skills in Excel.

Learning Outcomes:

  • List the types of charts and graphs available in Excel and describe their functions
  • Compare types of charting tools and choose the best for your data
  • Construct various charts and graphs using Microsoft Excel
  • Analyze and correct errors in how data is displayed in a chart or graph
  • Understand the AutoSum functionality
  • Convert text to columns
  • Summarize data on the status bar
  • Link and embed objects
  • Insert hyperlinks

Pre and Post-Class Actions Required


Excel 2013 – Formula Basics

Facilitator: Brett Neal
Target Audience: Experienced Excel users interested in learning how to create basic formulas.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT017

Overall Objectives: Understand and create basic formulas in Excel.

Learning Outcomes:

  • Filter and sort data in a worksheet
  • Use the subtotal, text to columns, and remove duplicate features
  • Understand concatenation
  • Define mathematical operators and demonstrate proper use

Pre and Post-Class Actions Required


Excel 2013 –Formulas and Functions Advanced

Facilitator: Keith Kennedy
Target Audience: This class is designed for Excel 2013 users with a solid understanding of the basics of spreadsheets who wish to perform more complex operations.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT002

Overall Objectives: Understand and solve math equations, determine which formula/function to use, enter formulas and functions into Excel, understand and use the subtotal, text to columns and concatenation features.

Learning Outcomes:

  • Interpret data and choose appropriate function or formula to achieve desired results
  • Construct basic formulas to perform calculations
  • Practice the Subtotal, Text to Columns, and Remove Duplicate features
  • Practice common functions: CONCATENATE, UPPER, COUNT, TODAY
  • Demonstrate use of mathematical operators
  • Construct formulas that calculate across several worksheets

Pre and Post-Class Actions Required


Excel 2013 – Macros Basics

Facilitator: Brett Neal
Target Audience: Experienced Excel users who wish to learn how to create simple Macros.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT005

Overall Objectives: This course will provide you with basic skills related to building and troubleshooting Macros in Excel.

Learning Outcomes:

  • Describe common uses for Macros
  • Discuss timesaving benefits of Macros
  • Construct a basic Macro utilizing your own data
  • Troubleshoot common Macro problems

Pre and Post-Class Actions Required


Excel 2013 – Pivot Tables Basics

Facilitator: Brett Neal
Target Audience: Experienced Excel users who wish to learn how to create Pivot Tables.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT004

Overall Objectives: To instruct users how to create, format and manage Pivot Tables..

Learning Outcomes:

  • List three benefits of using Pivot Tables
  • Construct basic Pivot Tables in Excel
  • Customize Pivot Table data using advanced features

Pre and Post-Class Actions Required


Excel 2013 – Pivot Tables Advanced

Facilitator: Nick Hartshorn
Target Audience: Experienced Excel users who wish to learn tools to enhance their experience with PeopleSoft and Excel.
Time Allotted: 3 hours
PeopleSoft Course Number: PSU012

Overall Objectives: Use Pivot Tables to more effectively analyze PeopleSoft data.

Learning Outcomes:

  • Create advanced Pivot Tables in Excel
  • Use advanced features to customize Pivot Table data
  • Practice skills utilizing PeopleSoft data

Pre and Post-Class Actions Required


It’s Windows 8: Do Not Panic

Facilitator: Geoff Duke
Target Audience: Anyone who is curious or worried about making the transition to Microsoft's latest operating system, Windows 8.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT035

Overall Objectives: We'll provide an overview of the features and improvements in Windows 8, as well as tips and suggestions for making the switch as easy as possible

Learning Outcomes:

  • Recognize and use the new Start screen and live tiles
  • Demonstrate switching between applications, the desktop and the Start screen
  • Find well-known tools and new functionality with the Charm bar
  • Describe some differences between Windows 7 and Windows 8
  • Dispel rumors and calm fears about Windows 8

Pre and Post-Class Actions Required


LimeSurvey – Basics

Facilitator: Brett Neal
Target Audience: This class is designed for the beginning LimeSurvey user.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT027

Overall Objectives: : Learn how to quickly create and easily administer intuitive, powerful online question-and-answer surveys.

Learning Outcomes:

  • Create online surveys
  • Utilize LimeSurvey's tiered approach to survey structure
  • View survey results in statistical and graphical analysis forms

Pre and Post-Class Actions Required


Manage Your Files Effectively

Facilitator: Geoff Duke
Target Audience: Anyone who wants to learn strategies and tips for managing collections of computer files.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT036

Overall Objectives: Learn how to create and organize collections of folders and files on your computer that enable you to access and share the information you need, effectively and securely.

Learning Outcomes:

  • Recognize the problems created by poor file management
  • Produce a consistent method of naming files and folders
  • Explore different locations for saving and accessing files
  • Add useful, descriptive details to files
  • Use the search features of your computer to quickly find the files you need
  • Understand UVM file-related services

Pre and Post-Class Actions Required


PowerPoint 2013 - Basics

Facilitator: Brett Neal
Target Audience: Basic or beginning users of PowerPoint
Time Allotted: 3 hours
PeopleSoft Course Number: CPT020

Overall Objectives: Create professional, effective presentations using Microsoft 2010 PowerPoint.

Learning Outcomes:

  • Have a basic understanding of how PowerPoint 2013 is organized
  • Understand what is meant by terminology such as ribbons, groups and tabs
  • Be familiar with the basic commands available in the File tab
  • Understand the Quick Access Toolbar

Pre and Post-Class Actions Required


Prezi – Basics

Facilitator: Brett Neal
Target Audience: Basic or beginning Prezi users
Time Allotted: 2 hours
PeopleSoft Course Number: CPT022

Overall Objectives: Transform standard PowerPoint presentations into dynamic and interactive presentations using Prezi. This hands-on workshop will demonstrate important techniques, discuss helpful tips for working with the software, and allow time for practice.

Learning Outcomes:

  • Define important components of Prezi software
  • List three tips for working with the Prezi software
  • Employ tips for efficient and effective use of Prezi
  • Practice transferring an existing PowerPoint into a Prezi presentation

Visio – Basics

Facilitator: Brett Neal
Target Audience: This class is designed for the beginning Visio user.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT026

Overall Objectives: To instruct beginning users on how to create, modify and manage Visio diagrams.

Learning Outcomes:

  • Navigate a Visio drawing
  • Select, scale and resize objects
  • Connect shapes in a diagram
  • Work with text in Visio
  • Format shapes and lines

Pre and Post-Class Actions Required


Web Strategy: Building and Executing a Plan to Improve Your Web Presence

Facilitator: Tatjana Salcedo
Target Audience: Managers and directors, marketing professionals, and individuals responsible for creating and maintaining web content or email campaigns.
Time Allotted: 2 hours
PeopleSoft Course Number: WEB036

Overall Objectives: Learn how to improve the efficacy of your web presence and digital marketing efforts through strategic planning.

Learning Outcomes:

  • How to construct a digital communications strategy for your unit
  • How to correlate your business objectives with web traffic data
  • How to assess and improve the quality of email and web content
  • How to collect and interpret web traffic data
  • How to best share website data with stakeholders and leadership

Pre and Post-Class Actions Required


Word 2013 – Basics

Facilitator: Brett Neal
Target Audience: Basic or beginning uses of Word
Time Allotted: 2 hours
PeopleSoft Course Number: CPT028

Overall Objectives: To instruct basic users on how to create, format and manage documents in Microsoft Word.

Learning Outcomes:

  • Know the terminology associated with Word including Ribbons, Tabs, Groups, and File tab
  • Create documents and apply basic formatting
  • Describe specific components of Word software
  • Apply Word templates to quickly create documents
  • Practice Word skills utilizing real-world examples

Pre and Post-Class Actions Required


Word 2013 – Intermediate

Facilitator: Brett Neal
Target Audience: Word users who have mastered basic functionality in Word.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT039

Overall Objectives: : To build on basic skills by learning Word functionality that will enhance your documents.

Learning Outcomes:

  • Generate a Table of Contents for a document
  • Understand the Mail Merge functionality
  • Create a cover page
  • Construct and modify Word tables
  • Practice working with watermarks
  • Create and modify tables
  • Practice adding columns to a document
  • Incorporate section breaks

Pre and Post-Class Actions Required


Don't see the class you need? We're open to suggestions—take a moment and share yours.