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

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.

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

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

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