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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:

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:


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:

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:

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:

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:

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:

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:

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:

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:

Pre and Post-Class Actions Required


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