Workshop Descriptions

* Note that not all courses are offered every semester

General Skills

IT Security 101 (workshop offered on request)

We will discuss common ways that most computer systems are compromised and teach you how to avoid becoming the victim. Learn vital computing skills to keep your systems and data safe including:

  • Types of files that could possibly be malicious
  • Safe browsing and social networking practices
  • What is phishing and how do I know if I'm being phished?
  • Protecting sensitive data while traveling

iPad / iPhone Tips and Tricks

We will demonstrate some tips and tricks on how to get the most out of your iPad / iPhone!

Introduction to Windows 10 & Office 2016

We will give an a brief overview of what's new and different in both Windows 10 and Office 2016, including useful tips and tricks.  There will also be time slotted for Q&A, so if you are not sure about upgrading, we will do our best to answer any of your concerns.

Campus Computer Purchasing Tips and Tricks (workshop offered on request)

We will show you the ins and outs of our approved computer vendor websites, and information about how OIT supports the computer that you purchased.  We'll review which computers are supported and which configurations will give you the biggest bang for your buck!

Microsoft Word

Essential Skills

The basics class is designed for those who may have typed in Word before but want to learn more about the environment, use the tools more efficiently, and make the task of creating a document easier.

Topics:

  • Environment Tour (what's new in 2013 | 2016)
  • Views
  • Typing and Navigating a Document
  • Editing, Moving, Copying, and Pasting
  • Spelling, Grammar, and Thesaurus
  • Tabs and Indents
  • Bullets and Numbering
  • Page Setup and Print Options
  • Basic Templates

Formatting

Making your document organized, clear, and visually attractive is necessary and even fun. This workshop addresses essential skills in formatting text, pages, bullets and more.

Topics:

  • Font Formatting
  • Paragraph Formatting
  • Choices for Bullets and Numbering
  • Borders and Shading
  • Tabs
  • Page Numbers, Orientation, and Paper Size

Advanced Formatting and Editing

Add more tools to your formatting and editing repertoire! This workshop will show you how to create and edit formatting styles, dispel the mysteries of section breaks and much more.

Topics:

  • Formatting with Styles
  • Page and Section Breaks
  • Headers and Footers
  • Columns
  • Reference Tools
  • Markup Tools (Tracking Changes)

Graphics and Tables

Working with tables and graphics in Word shouldn't be frustrating, but it can be at times. This workshop will give you some insight in how to successfully manipulate various objects in the Microsoft Word environment.

Topics:

  • Managing and Formatting Tables
  • Text Boxes
  • Clip Art
  • Pictures
  • Drop Caps
  • Watermarks
  • SmartArt

Mail Merge

If you have names, addresses, or other information stored in a file, you can merge that data in Word to create envelopes, labels, and form letters. In the Mail Merge workshop, learn how to use data and Word tools to automate your mailings.

Topics:

  • Single Envelopes And Labels
  • Data Source
  • The Mail Merge Process
  • Creating Mail Merged Envelopes and Labels
  • Creating Mail Merged Form Letters

Microsoft Excel

Essential Skills

Learn all the basic skills necessary to start creating lists and tables of data in an Excel spreadsheet, as well as how to format it to be visually clear and attractive. Learn about:

  • Environment Tour (what's new in 2013 | 2016)
  • Setting Up Your Data
  • Modifying Data And Worksheets
  • Formatting Your Data
  • Conditional Formatting
  • Printing

Formulas and Functions

This workshop will illustrate how to create formulas and functions in Excel so that your calculations are automated. Learn about:

  • Creating Formulas
  • Creating Functions
  • Editing
  • Absolute Referencing
  • Auditing

Using Multiple Worksheets and Workbooks

There are times when you might need to organize your data into multiple worksheets or even multiple workbooks. This workshop will illustrate the tools, tips, and skills you need to manage your data and calculations that span multiple sheets and files. Learn about:

  • Creating Formulas and Functions Across Spreadsheets
  • Moving Sheets to New Files
  • Creating Links
  • Protecting Sheets
  • Sharing

Charts and Graphs

Learn how to create charts and graphs of your data. The workshop includes tips on formatting to achieve the perfect visual results. Learn about:

  • Creating Charts and Graphs
  • Editing your graphs
  • Tips and Tricks

Data Tools

Excel has tools that enable database like record keeping right in your spreadsheet. Use the tools to view and summarize your records the way you want. Learn about:

  • Sorting
  • Autofilter
  • Advanced Filter
  • Importing Data
  • Saving as a .csv
  • Group and Outline

Microsoft PowerPoint

Creating Professional Presentations

PowerPoint is more than just putting text on the screen. There are guidelines and tools to help make your presentation visually attractive, professional, informative, and interesting. Streamline your work and end up with fabulous presentations!

  • Planning the Presentation
  • Creating the Presentation and Content
  • Formatting
  • Adding Graphics
  • Controlling the presentation

Multimedia in PowerPoint

If you've conquered the text and clip art, now it’s time for the next step. Learn how to add and control animation, include video and sound, and automate the presentation playback.

  • Slide Transitions
  • Slide Animations
  • Adding video and sound files

Google Apps

Introduction to Google Drive

Learn your way around the Google Drive interface and how to create and share basic documents, spreadsheets, and presentations.

UNLVMail and Calendar

Learn all of essential skills needed to get started with using G-mail! We will also show you how to create and share calendar events, add notifications, and use many other features.

UNLVMail Advanced

Are you comfortable with UNLVMail, but you want to take the next step and learns some cool new tricks?  This is the workshop for you!  Learn more advanced tips and tricks, including Google Labs, Inbox management, and advanced search and filter tools that will help you be even more productive.

Google Sites (workshop offered on request)

Google Sites is an online application that makes creating a team web site as easy as editing a document.  Learn your way around the Google Sites interface and how to create and share a site.

Google Groups (workshop offered on request)

Google Groups provide a convenient way to create online groups and email distribution lists.   Learn all of the essential skills needed to create, manage, and share a Google Group.