Workshop Descriptions
* Note that not all courses are offered every semester
Google Workspace Apps Webinars
UNLVMail Tips and Tricks – Topics Covered
- Inbox Management / Quick Settings
- New Meet/Chat Integration
- Label Management / Filters
- Templates
- Managing Signatures
Calendar Tips and Tricks – Topics Covered
- Out of Office Events
- Reminders
- Find a Time
- Add Video Conferencing
Google Meet and Chat – Tips and Tricks – Topics Covered
- Meet Interface Review
- Calendar Video Conferencing Options
- Chat Room Basics
Google Drive – Tips and Tricks I – Topics Covered
- Drive Interface Overview
- Sharing types (Can View, Can Comment, Can Edit)
- Collaboration tips and practice
Google Drive – Tips and Tricks II – Topics Covered
- Share Drive Overview
- Share Drive Membership Review
- Sharing Files
- Using Google File Stream
Google Docs – Tips and Tricks – Topics Covered
- Font Settings
- Paragraph Indentation and Spacing
- Borders and Shading
- Heading Styles
- Section Breaks / Page Numbers
Google Sheets – Tips and Tricks – Topics Covered
- Data Entry / Autofill
- Formula and Function Practice
- Filtering and Sorting Data
Google Slides – Tips and Tricks – Topics Covered
- Slide Layouts
- Presentation Themes
- Bulleted List Slides
- Slides with Video
- Slide Transitions
Google Workspace 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 Docs
Google Docs is the cloud-based word processing application within the G Suite. Workshop topics will include:
- Environment Tour
- Formatting and Styles
- Organizing your Document
- Tips and Tricks
Google Sheets
Google Sheets is the cloud-based spreadsheet application within the G Suite. Workshop topics will include:
- Environment Tour
- Formatting your Data
- Sorting and Filtering
- Creating Formulas
- Tips and Tricks
Google Slides
Google Slides is the cloud-based presentation application within the G Suite. Workshop topics will include:
- Environment Tour
- Creating Presentation Content
- Slide Formatting
- Tips and Tricks
Google Meet and Chat
Google Meet and Chat are communication tools within the G Suite. Workshop topics will include:
- Starting and joining a video meeting with Meet
- Sending Direct Messages in Chat
- Creating rooms in Chat
- Collaborating within Meet and Chat
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.
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