Skip to Main Content

University of Wyoming Division of Information Technology

Computer Workshop Descriptions

UW employees are eligible to request access to the Lynda.com online self-paced training courses.

Information Technology offers instructor-led computer software training – classes are open to all UW faculty, staff, and students. All instructor-led workshops are held in the Information Technology Center, with one person per computer.

Registration: If you are interested in attending one of the training courses listed, you can reserve a seat by finding the course in the schedule(http://www.uwyo.edu/infotech/services/training/schedule.asp) and clicking the "Register" button. This will take you to the PeopleSoft HRMS site where you can register online for the class and pay with either a departmental P-card or a personal credit card (if paying with a P-card in your name, choose the "Self-Pay" option. If the P-card is under a supervisor's name, choose the "Department Pay" option. Also make sure pop-ups are enabled on this page.) You can also register for a course by sending an IDR or personal check to the IT Front Desk, Information Technology Center. Please include the participant’s name as well as the name and number of the training course.

If you have any questions, please contact Information Technology at computer.training@uwyo.edu. Workshop reservations will not be accepted by e-mail or over the phone. If you are located around the state and would like to remotely attend a workshop, please contact us at computer.training@uwyo.edu about the requirements for a remote connection

Instructor-Led Workshop Subjects
Microsoft Office 2013 Other Microsoft   Adobe Creative Suite 6
Access 2013
Excel 2013
Outlook 2013
Word 2013
WyoLync
Using Office 365
Microsoft Project 2013
Windows 7 Tips and Tricks
OneDrive: Level 1
OneDrive: Level 2
Microsoft Office 2016 New Features
SharePoint
Adobe Acrobat Pro: Building Forms
Adobe Acrobat Pro: Foundations
Adobe Alternatives
InDesign CS6: Level 1
InDesign CS6: Level 2
Photoshop CS6: Level 1
Photoshop CS6: Level 2
     
FREE Workshops
UW Survey Tool
Web Content Mgt System - Open Work Session
Computer Security Seminar
Cloud Storage Overview
Data Backup Basics
Getting started with MyWyoCast
Web Content Mgt System - Level 1
Web Content Mgt System - Level 2
Switching To Mac
Mac 101
Mac Tips & Tricks
iPhone, iPad & iPod Touch oh my!


Previously held FREE Group Presentations/Demonstrations have been recorded are available to view online. Please go to the WyoCast (http://wyocast.uwyo.edu) home page. Once there, select the Training folder – click on the appropriate course title on the right side of the screen to view the recording.


Workshop Descriptions

AM - Morning sessions are usually from 8:30 - 11:30 a.m.
PM - Afternoon sessions are usually from 1:30 - 4:30 p.m.
(check specific times by clicking on the Workshop#)

Access 2013
Course Names & Descriptions ID# Dates Time Workshop# Cost
Access 2013: Introduction
The aim of this introductory level class is to make databases understandable, and allow the participants to create a database from scratch. Topics to be covered include: database concepts, planning and designing databases, relating tables, changing the design of a table, basic queries, and basic forms and reports.
ACC13INTR  3/25 4/1
AM
 
201603251
 
$40
Access 2013 Intermediate
The Access 2013 Intermediate course will provide in-depth information on queries, forms, and reports. Topics to be covered include: basic queries, complex and advanced queries; creating forms and advanced form design; and working with reports and printing.
ACC13INTER  4/15 4/22
AM
 
201604151
 
$40
Access 2013 Advanced
The advanced class will explore features of Access to help the user customize and better manage their Access database. Topics include: importing, exporting, and linking data; optimizing and protecting databases; and creating basic and advanced macros. 
ACC13ADV  Currently not scheduled. Request it.     $40
Access Open Lab
This open lab provides an opportunity to further explore Access database functionality on your own while having the instructor and various resources available for assistance.  (Note that this session does not include an instruction/presentation component.)
ACC10LAB  2/17 
3/28 
4/28 
5/25 
AM
PM
PM
PM
 
201602171
201603281
201604281
201605251
 
Free
top of page
Excel 2013
Course Names & Descriptions ID# Dates Time Workshop# Cost
Excel 2013: Intermediate
This course teaches students how to manage large sets of data efficiently. Topics covered include working with multiple worksheets and workbooks, advanced formatting, consolidating and outlining data, creating subtotals, protecting worksheets, and using logical, conditional, and lookup functions. (formerly titled 'Managing Worksheets and Workbooks').
EXC13WKST  Currently not scheduled. Request it.     $40
Excel 2013 Tips and Tricks
This 90-minute course will cover a variety of topics to help participants use Excel 2013 more efficiently. Tips to be covered include conditional formatting, keyboard shortcuts, logical formulas, absolute references, charts, formatting options, and preparing for printing.
EXC13TIPS  5/11 
PM
 
201605112
 
$15
Excel 2013 Macros/VBA
This advanced level class will delve into using Visual Basic for Applications (VBA) to create, run, and edit macros.
Topics include developing macros, creating macros to format worksheets, designing an interactive worksheet, using macros to work with multiple worksheets, and creating user-defined functions.
EXC13VBA  Currently not scheduled. Request it.     $40
Excel Spreadsheets Open Lab
This open lab provides time to further explore Excel spreadsheet functionality on your own while having the instructor and various resources available for assistance. (Note that this session does not include an instruction/presentation component.)

EXC13LAB  3/28 
4/28 
5/25 
PM
PM
PM
 
201603282
201604282
201605252
 
Free
Excel Spreadsheets: Foundations
This introductory level class teaches the basic functions and features of Microsoft’s Excel spreadsheet application. Topics to be covered include workbook navigation and formatting, working with columns and rows, entering/editing data, copying/moving data, number styles, page setup and printing options, and basic formulas.  (prerequisites: none; duration: 6 hours split between two sessions)
EXCLFND  Currently not scheduled. Request it.     $40
Excel Spreadsheets: Formulas & Functions
This foundational level workshop explores the use of formulas to perform calculations in Excel spreadsheets.  Topics include general formula building, types of cell addresses, and common functions.  This is a great place to start learning about performing dynamic, effective calculations in your spreadsheets!  (prerequisites: none; duration: 90 minutes plus a 30 minute optional lab immediately following)
EXCLFN  4/6 
AM
 
201604061
 
$15
Excel Spreadsheets: Conditional Formulas
This workshop covers the use of very powerful conditional functions in Excel spreadsheets, including IF, SUMIF, AVERAGEIF, COUNTIF, and logical operators (OR, AND, NOT).  These functions greatly increase the flexibility of your formulas by allowing for variable outcomes.  (***prerequisites: at least a foundational working knowledge of Excel spreadsheets; the Excel Spreadsheets: Foundations workshop meets these requirements; duration: 90 minute session, with an optional 30 minute lab immediately following)

EXCLCOND  Currently not scheduled. Request it.     $15
Excel Spreadsheets: Lookup Formulas
This workshop covers the use of very powerful lookup functions in Excel spreadsheets, including VLOOKUP, HLOOKUP, LOOKUP, INDEX, and MATCH.  These functions allow you to search for specific data in a spreadsheet, return related data, and assist in effective data analysis.  (***prerequisites: at least a foundational working knowledge of Excel spreadsheets; the Excel Spreadsheets: Foundations workshop meets these requirements; duration: 90 minute session, with an optional 30 minute lab immediately following)

EXCLLOOK  Currently not scheduled. Request it.     $15
Excel Spreadsheets: Pivot Tables & Data Modeling

This intermediate/advanced level course provides in-depth information on creating, managing, and effectively using Pivot Tables for enhanced data analysis and reporting in Excel spreadsheets.  Data modeling, a new feature in Excel, allows related data from different sources to be pulled together into a single point of analysis.  Filters, slicers, Pivot Charts and the PowerPivot add-in will also be examined.  (***prerequisites: at least an intermediate level knowledge of Excel spreadsheets; duration: 3 hours) 

EXCLPVT  5/2 
PM
 
201605022
 
$25
Excel Spreadsheets: Conditional Formatting
This workshop explores the use of conditional formatting features in MS Excel spreadsheets.  Conditional formatting can be used to adjust the appearance of spreadsheet segments based on a set of criteria, and can be used to identify specific values, rank values, search for duplicates, and more.  (***prerequisites: at least a foundational working knowledge of Excel spreadsheets)
EXCLCNFM  Currently not scheduled. Request it.     $15
Excel Online Surveys
This brief workshop examines how to build surveys using the University’s Office 365 Excel Online application.  We will also examine how to access and analyze survey response data stored in the OneDrive cloud.  This is a great tool for deploying basic surveys and questionnaires!

 

EXCLSUR  2/22 
PM
 
201602222
 
Free
top of page
Outlook 2013
Course Names & Descriptions ID# Dates Time Workshop# Cost
Outlook 2013 Tips and Tricks
This 90-minute course will cover a variety of topics to help participants use Outlook more efficiently. Topics include customizing Outlook, organizing messages, working with contacts, working with folders, searching and filtering, and working with Rules.
OUTL13TIPS  4/25 
AM
 
201604251
 
$15
top of page
SharePoint
Course Names & Descriptions ID# Dates Time Workshop# Cost
SharePoint Site Owner
The SharePoint Site Owner training session will review the Governance document, show permissions and how to assign permissions to SharePoint assets, as well as how to create SharePoint libraries, lists, sub-sites, content types, etc.  Users will also be able to customize their site assets.
SP2010SO  Currently not scheduled. Request it.     $25
SharePoint Site Collection Admin
The SharePoint Site Collection Admin training session will review the Governance document, show how - and when - to create Active Directory groups, restore deleted assets, manage site collection objects, manage quota, run site analytics, in addition to other topics.
SP2010SC  Currently not scheduled. Request it.     Free
SharePoint Overview
This one-hour session will be a high level overview of SharePoint 2010. Come and see how SharePoint can help you and your department save time by using SharePoint to meet your needs. Examples will be shown of document libraries, group calendars, internal websites, content storage, and internal communication -- just to name a few.
SP2010OV  Currently not scheduled. Request it.     Free
SharePoint - End User
Attendees will build SharePoint components which can then be ready for departmental or team use. Topics to be covered include group calendars, document libraries, meeting workspaces, creating internal collaboration sites - wikis, blogs, discussion pages; using SharePoint search, and basic SharePoint governance.
SP2010EU  Currently not scheduled. Request it.     $15
top of page
Word 2013
Course Names & Descriptions ID# Dates Time Workshop# Cost
Word 2013 Tips and Tricks
This 3-hr course will cover a variety of topics to help participants use MS Word 2013 more efficiently. Tips and features to be covered include: creating and working with tables, graphics, using styles, creating and formatting sections and page breaks, headers and footers, and tracking changes.
WORD13TIPS  3/4 
AM
 
201603041
 
$25
MS Word: Automated References & Citations
This workshop examines various features in Microsoft Word that simplify reference management.  Topics covered include: citation management, footnotes and endnotes, figures and captions, cross referencing, automated works cited/bibliography, and table of contents.
WORDREF  4/8 
AM
 
201604081
 
Free
MS Word: Collaborative Editing & Review
This workshop examines the various document review tools available in Microsoft Word.  Specific topics covered include comments, tracking changes, automated document comparison, and collaboration in the OneDrive cloud.
WORDRVW  Currently not scheduled. Request it.     Free
MS Word: Mail Merge
This workshop covers Microsoft Word’s mail merge tools, and how they can be used to create multiple standard letters, email messages, and labels using information stored in a database or spreadsheet.  We will also examine best practices for setting up a mail merge data source.
WORDMRG  Currently not scheduled. Request it.     $15
top of page
Microsoft Other
Course Names & Descriptions ID# Dates Time Workshop# Cost
WyoLync
This workshop is a hands-on exploration of the main features of WyoLync (Microsoft Lync/Skype for Business), an integrated communication application which allows users to instant message, share applications or desktops from their computers, and create video or audio web conferences.
MSLYNC2013  4/25 
PM
 
201604252
 
Free
Using Office 365
This free 90-minute session explores Microsoft’s powerful Office 365 cloud environment.  Office 365 ties together online email, calendars, tasks, OneDrive storage, and Office applications so that you have access to create and collaborate from nearly anywhere.
OFFICE365  5/5 
PM
 
201605052
 
Free
Microsoft Project 2013
Participants will learn how to create and manage projects using Microsoft Project 2013. Topics include: Project basics, creating and working with tasks, scheduling tasks, working with resources, working with calendars, adjusting resources, assigning costs, and finalizing the task plan.
PROJ13INTR  Currently not scheduled. Request it.     $40
Windows 7 Tips and Tricks
This course explores useful features of the Windows 7 operating system, including customization of the user interface, file management, as well as many special features.  Please bring your questions to class.

WIN7TT  Currently not scheduled. Request it.     Free
OneDrive: Level 1
This workshop explores the use of the OneDrive for the University of Wyoming cloud storage service.  Topics include: understanding cloud storage, when to use OneDrive compared to other services such as DropBox, accessing OneDrive, uploading and downloading files, managing content, and basic content sharing.  (prerequisites: none; duration: 90 minutes)

ONELVL1  3/3 
AM
 
201603031
 
Free
OneDrive: Level 2
This workshop expands on basic OneDrive skills, exploring advanced sharing and collaboration, file synchronization, and managing file versions.  (***prerequisites: an understanding of basic OneDrive functionality; the OneDrive: Level 1 course, or use of OneDrive for file storage, meets these requirements; duration: 90 minutes)

ONELVL2  3/10 
AM
 
201603101
 
Free
Microsoft Office 2016 New Features
This workshop provides a brief overview of new features found in Microsoft’s Office 2016 suite of applications.  Features and functionality will be compared to previous versions.
OFF2016  3/23 
PM
 
201603232
 
Free
top of page
Adobe CS 6
Course Names & Descriptions ID# Dates Time Workshop# Cost
Photoshop CS6: Level 1
Students will learn to use several of the tools and features of Photoshop CS6 to work with images.   Topics include: exploring the Photoshop environment, working with image selections, working with layers, adjusting images, retouching images, and managing and preparing finished images.
PSCS6_1  Currently not scheduled. Request it.     $40
InDesign CS6: Level 1
In this course students will work with some of the tools and features to create eye-catching printed documents such as newsletters and flyers using InDesign CS6. Topics to be covered include: exploring the InDesign environment, creating documents, working with text and graphic frames, master pages, working with colors, gradients and strokes, and finalizing documents.
IDCS6_1  Currently not scheduled. Request it.     $40
InDesign CS6: Level 2
This course will cover the advanced features of InDesign CS6 to create and design documents.
Topics to be covered include: document setup, working with swatches, vector paths, working with text layout, graphics, text editing, and working with long documents - creating books, tables of contents, and indexes.
IDCS6_2  Currently not scheduled. Request it.     $40
Photoshop CS6: Level 2
This course explores some of the advanced image creation and editing techniques, and offers you hands-on activities that demonstrate how Photoshop techniques can be used in combination to create exciting visual effects.  Topics include: fills and overlays, masks, vector paths, creative image effects, layer comps, automating tasks, and resizing images.
PSCS6_2  Currently not scheduled. Request it.     $40
Adobe Acrobat Pro: Foundations
This workshop covers basic functionality of the Adobe Acrobat Pro application.  Topics covered include converting documents between PDF and other formats, combining PDF documents, rearranging and editing content, working with scanned documents, document security and protection, comments and annotations, and using digital signatures. (prerequisites: none; duration: 3 hours)

ACROFND  Currently not scheduled. Request it.     $25
Adobe Acrobat Pro: Building Forms
This intermediate level workshop covers the process of building electronic forms using the Adobe Acrobat Pro application.  Specific topics include: form layout, form fields, digital signatures, triggering special actions, and best practices for managing forms.  (***prerequisites: at least a foundational working knowledge of Adobe Acrobat Pro; the Acrobat Pro: Foundations workshop meets these requirements; duration: 2 hours)

ACROFRM  5/16 
PM
 
201605162
 
$20
Adobe Alternatives
This workshop examines applications that are lower cost alternatives to Adobe Photoshop, InDesign, Illustrator, and Acrobat.  Brief demonstrations and feature comparisons will be presented.
ADOBEALT  5/19 
PM
 
201605192
 
Free
top of page
Advanced Research Computing
Course Names & Descriptions ID# Dates Time Workshop# Cost
Red Hat Enterprise Linux
This 90-minute workshop will introduce the Red Hat Enterprise Linux (RHEL) operating system.  We will sit down and explore RHEL and discuss how to get started using Linux. We will also provide information on how to install RHEL on your own computer under UWIT's Red Hat site license.

RHEL  Currently not scheduled. Request it.     Free
Introduction to ARCC

This workshop will give an overview of the Advanced Research Computing Center (ARCC), its personnel and services. An overview of current operations and planned upgrades will be made. (This workshop is presented by the UW Advanced Research Computing Center. Email arcc-info@uwyo.edu for more information.)

ARCC  Currently not scheduled. Request it.     Free
Introduction to Linux (terminal)

This workshop will teach basic Linux command line skills. If you are new to Linux or Linux commands, this session will prepare you to use Mount Moran or any Linux system. (This workshop is presented by the UW Advanced Research Computing Center. Email arcc-info@uwyo.edu for more information.)

LINUXTERM  2/18 
PM
 
201602182
 
Free
Slurm Job Scheduling
Leveraging the ARCC high performance computing systems requires understanding of how to submit compute jobs effectively and efficiently for various workflows. Individual workloads (group, user, and application) can vary widely. There are key steps to creating a successful job submission patterns to the cluster to minimize wait time, maximize performance, and increase throughput. The presentation will cover basic compute node architecture and how to submit jobs to leverage different workloads including: distributed memory jobs, shared memory jobs, hybrid jobs, many jobs, GPU jobs, and interactive computing jobs. (This workshop is presented by the UW Advanced Research Computing Center. Email arcc-info@uwyo.edu for more information.)

ARCCJOB  2/25 
PM
 
201602252
 
Free
Storage Systems and Data Transfer
This introductory course will briefly describe ARCC’s storage environment and provide a brief tutorial on how to transfer data to, from, and between our systems.  Topics will include: Bighorn, petaLibrary, Access, Data Protection, Globus, Best Practices and External Sources. (This workshop is presented by the UW Advanced Research Computing Center. Email arcc-info@uwyo.edu for more information.)

ARCCSTOR  3/3 
PM
 
201603033
 
Free
Data Management Planning
A data management plan is an often overlooked, yet vital, part of any grant application. Additionally, many funding agencies have detailed requirements that may be difficult to understand. This presentation will cover best practices, tools, and resources available at UW to construct a competitive data management plan. (This workshop is presented by the UW Advanced Research Computing Center. Email arcc-info@uwyo.edu for more information.)

ARCCPLAN  3/10 
PM
 
201603103
 
Free
top of page
Other Training Opportunities
Course Names & Descriptions ID# Dates Time Workshop# Cost
UW Survey Tool
Learn how to use UW's free online survey tool to conduct your next survey or class evaluation. This two hour seminar will present an overview to the survey tool and will be located in our training lab so you can begin creating surveys in class.
UWSURVEY  Currently not scheduled. Request it.     Free
Web Content Mgt System - Open Work Session
If you’ve attended the Level 1 and/or the Level 2 training on the Cascade Server CMS and you’d like some additional help – come in to the lab to work on your site. Technical staff and trainers will be available to answer questions. You can find more information about this course on the CMS Help web site.
CMS_WORK  2/16 
3/10 
4/13 
5/19 
AM
PM
PM
AM
 
201602161
201603102
201604132
201605191
 
Free
Computer Security Seminar

IT’s Computer Security Seminar is a free 90-minute session designed to help reduce your chances of downtime, data loss, and privacy issues at work and at home.  Topics include: malware, spyware, and rogue security software, password tips and management, phishing and email safety, and methods of protection. (The seminar will be followed by an optional 30-minute question and answer segment.)

CSICOMPSEC  4/13 
AM
 
201604131
 
Free
Cloud Storage Overview
This workshop examines and compares various online cloud storage options, including OneDrive, Dropbox, Google Drive, and Box, and discusses cloud storage best practices.
CLOUD  5/5 
AM
 
201605051
 
Free
Data Backup Basics
This workshop examines best practices for safeguarding important data through careful back-up plans and procedures.  Options through university services, various back-up software, and other topics will be covered.
BACKUP  5/12 
PM
 
201605122
 
Free
Getting started with MyWyoCast
This workshop examines how to obtain access to MyWyoCast, install the desktop recorder, create content channels, create presentations from the desktop, upload previously created videos, and share presentations with an audience.
WYOCAST  Currently not scheduled. Request it.     Free
Web Content Mgt System - Level 1
Learn how to set up your departmental website using the university's Web Content Management System. This two-hour session will give a basic orientation to the CMS -- you will get hands-on experience creating and editing web pages, creating folders, uploading files and photos, creating hyperlinks, and publishing a site. More information about this training can be found on the CMS Help web pages.
CMS_1  3/3 
4/6 
5/12 
PM
PM
AM
 
201603032
201604062
201605121
 
Free
Web Content Mgt System - Level 2
Learn about the additional features of UW's Web Content Management System. Topics to be covered include using video, callouts, homepage media slideshow, faculty and staff directory, and building web forms. More information about this training can be found on the CMS Help web pages.
CMS_2  2/23 
3/24 
4/20 
5/26 
AM
PM
PM
AM
 
201602231
201603242
201604202
201605261
 
Free
Switching To Mac
If you're thinking of switching to Mac or if you've just picked one up and feel a bit lost, sign up for Switching To Mac.  We'll go over the analogs to Windows, features unique to Mac and talk about the workflow, application and use case changes new Mac users often see. Everything you need to hit the ground running with your new Mac!  (This is a demonstration course. Systems will not be provided, but feel free to bring your own.)
SWITCHMAC  3/4 
PM
 
201603042
 
Free
Mac 101
In this course we'll demystify some of the features unique to the Apple environment, talk about iCloud and syncing data and then go over the most used features of the OS X. We'll also touch on third party Apps like Microsoft Office, third party browsers and backup solutions. (This is a demonstration course. Systems will not be provided, but feel free to bring your own.)
MAC101  3/25 
PM
 
201603252
 
Free
Mac Tips & Tricks
This course will focus on getting the most out of your Apple devices. Designed for people already comfortable with their Macs, we'll kick it up a notch with some of OS X's awesome hidden features, the new Automator and a selection of great third party Apps designed to increase productivity, cool-factor and fun! (This is a demonstration course. Systems will not be provided, but feel free to bring your own.)

 

MACTIPS  4/8 
PM
 
201604082
 
Free
iPhone, iPad & iPod Touch oh my!
Whether you're new to iOS or a long time user we've got some great things to show you. We'll cover setting up your iOS device for home and business use, a handful of great Apps and how to get the most out of your Apple devices. Please bring an iPhone, iPad or iPod Touch running iOS 8.

IPHONE  4/22 
PM
 
201604222
 
Free
top of page

Share This Page: