University of Vermont

Human Resource Services  –  Trusted Partner…Smart Solutions.

Banner Navigation
    Loading
Software Classes

Software Skills

Advanced Formulas and Functions in Excel

Facilitator: Keith Kennedy
Target Audience: This class is designed for Excel 2010 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


Basic Excel, Level One

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: To instruct basic users on how to enter, format and manage data in MS Excel.

Learning Outcomes:

  • Know the terms associated with MS 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


Basic Excel, Level Two

Facilitator: Brett Neal
Target Audience: This class is designed for beginner or basic users who have completed Basic Excel Level 1 or who have scored higher than 17 on the self-evaluation.
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 a workbook with multiple worksheets
  • Modify data across the entire workbook
  • Know the commands on the page layout tab
  • Review, print and email workbooks
  • Practice Excel skills using real world examples

Pre and Post-Class Actions Required


Basic Excel, Level Three

Facilitator: Brett Neal
Target Audience: This class is designed for beginner or basic users who have completed Level 1 and 2 or who have scored higher than 30 on the self-evaluation.
Time Allotted: 3 hours
PeopleSoft Course Number: CPT015

Overall Objectives: To instruct basic users how to create and manage data in worksheets and workbooks.

Learning Outcomes:

  • Create a custom template
  • Add and modify headers on a worksheet
  • Add and modify footers on a worksheet
  • Sort Data
  • Complete a complex sort
  • Use a filter
  • Apply a password to a cell or a worksheet
  • Allow multiple users to access and update worksheets simultaneously

Pre and Post-Class Actions Required


Basic Formulas in Excel

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

Overall Objectives: Understand and create basic formulas in Excel.

Learning Outcomes:

  • Practice basic calculation order to build a formula
  • Define mathematical operators and demonstrate proper use
  • Compose basic formulas to perform calculations on data in Excel
  • Troubleshoot formula errors
  • Use formulas across worksheets

Pre and Post-Class Actions Required


Basic Macros in Excel

Facilitator: Brett Neal
Target Audience: Experienced Excel users who wish to learn how to create simple Macros.
Time Allotted: 3 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


Basic PowerPoint

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

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

Learning Outcomes:

  • Recognize how PowerPoint is organized
  • Create, modify and format slides
  • Review a slide presentation
  • Apply a password to a presentation
  • Allow multiple users access to a presentation
  • Demonstrate how to print, save, email and print a presentation

Pre and Post-Class Actions Required


Basic Word, Level 1

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

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

Learning Outcomes:

  • Know the terminology associated with MS Word including Ribbons, Tabs, Groups, and Back Stage View
  • 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


Beginning Access

Facilitator: Carley Tillinghast
Target Audience: Beginning Microsoft Access Users
Time Allotted: 3.5 hours
PeopleSoft Course Number: CPT029

Overall Objectives: To give an overview of basic database concepts, and instruct new users on Access navigation, table and field creation, primary keys and indexing, table relationships, queries, and reporting.

Learning Outcomes:

  • Define what a databases are and how they are used
  • Understand the layout and components of Access
  • Create new tables and fields
  • Manage database data
  • Create queries and generate or modify Access reports

Pre and Post-Class Actions Required


Creating Accessible PDFs

Facilitator: Nick Hall, Sharon Mone, Nick Ogrizovich
Target Audience: All faculty and staff who create PDF documents
Time Allotted: 2 hours
PeopleSoft Course Number: CPT034

Overall Objectives: Do you want to make your printed materials more accessible to all users? In this session we will demonstrate accessible PDFs and discuss factors that contribute to inaccessibility.

Learning Outcomes:

  • List three common mistakes and how to avoid them
  • Describe the characteristics of accessible and non-accessible PDFs
  • Examine existing PDFs and analyze possible changes

Pre and Post-Class Actions Required


Intermediate Excel

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 advanced 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
  • Customize the way data is displayed through the use of conditional formatting
  • List advanced data formatting features and describe their use (text to columns, remove duplicates, and subtotals)
  • Create and use customized templates

Pre and Post-Class Actions Required


Intermediate SharePoint

Facilitator: Greg MacKinnon
Target Audience: Users who are interested in building on basic Microsoft SharePoint knowledge.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT033

Overall Objectives: Gain experience using advanced skills in Microsoft SharePoint. Create pages to creatively present content and use libraries to manage links.

Learning Outcomes:

  • Create customized content
  • Practice building customized pages using Microsoft SharePoint
  • Create documents and interact with other Office products without leaving SharePoint

Pre and Post-Class Actions Required


Introduction to Prezi

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

Introduction to Search Engine Optimization Part 1 and 2

Facilitator: Tatjana Salcedo
Target Audience: Individuals responsible for creating and/or editing content for websites.
Time Allotted: 3 hours
PeopleSoft Course Number: WEB034, WEB035

Overall Objectives: Learn about search engine optimization (SEO) and its importance for your unit. Identify keywords and trends supporting an SEO strategy. Write content optimized for search engines and understand technical considerations for SEO.

Learning Outcomes:

  • Complete and implement a detailed SEO strategy for your unit
  • Compile a custom list of relevant keywords and current search trends in your area
  • Learn how to improve your web content for SEO
  • Acquire the ability to measure results of your SEO efforts

Pre and Post-Class Actions Required


Introduction to Visio

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


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


Learning Services eCommunity

Facilitator: Brett Neal
Target Audience: UVM staff who would like to connect with Learning Services through our social network community.
Time Allotted: 2 hours
PeopleSoft Course Number: CPT030

Overall Objectives: Understand Learning Services social network community offerings, and learn about the advantages of UVM staff members connecting with Learning Services through forums, blogs, groups, chats and videos.

Learning Outcomes:

  • Know how to log on and navigate around the community.
  • View, reply, and create new postings related to Learning Services offerings.
  • Add comments or submit questions to Learning Services.

Pre and Post-Class Actions Required


Introduction to Lime Survey

Facilitator: Brett Neal
Target Audience: This class is designed for the beginning Lime Survey 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


SharePoint for Beginners

Facilitator: Greg MacKinnon
Target Audience: This class is designed for the beginning or basic user
Time Allotted: 2 hours
PeopleSoft Course Number: CPT032

Overall Objectives: Learn how Microsoft SharePoint can enhance the productivity of teams through a web-based environment. The basics of how to use, modify and create customized SharePoint sites will be covered in this workshop.

Learning Outcomes:

  • Know the terminology associated with SharePoint
  • List three uses for SharePoint in your regular work
  • Create a SharePoint site
  • Describe specific components of SharePoint software

Pre and Post-Class Actions Required


Pivot Tables in Excel 2003

Facilitator: Brett Neal
Target Audience: Experienced Excel users who wish to learn 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 using Excel 2013
  • Create a SharePoint site
  • Customize Pivot Table data using advanced features

Pre and Post-Class Actions Required


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

Last modified April 07 2014 12:12 PM