Workshop Descriptions

Understanding Adobe Acrobat

Learn how to create the commonly used pdf document format and how to use the basic tools of Adobe Acrobat Professional to make the files user friendly.  Topics range from learning about the different versions of Acrobat to creating hyperlinks and bookmarks for document navigation.

Malware

Learn what it is, where it comes from, why it exists, and how to protect yourself.  This workshops includes valuable information on adware, spyware, viruses, spam, and popups.

Introduction to Office 2007

Office 2007 is a significant environmental change from earlier versions, but most users seem to find it much more user friendly and intuitive.  Find out what to expect from Office 2007 before it’s time to upgrade.  This workshop allows you to use Office 2007, see the differences, and ask questions about upgrading.

Printer Workshop

Get to know laser printer! Paper Jams 101, Toner Cartridge information and replacement, Network printers, and more. Our resident printer expert, Roger Keyes, will provide demonstrations, hands-on practice, and answers to your questions so you know how to address common printer issues and most importantly, when to call for Help.

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 2007)
• 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

Professional 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
• Using Styles
• Additional Formatting Options

Creating and Managing Large Documents

When moving beyond the short letter, essay, article, etc., it may be necessary to start using Word’s large document tools. The tools make it easier to handle large amounts of text and large numbers of pages.

Topics:

• Creating Columns
• Inserting Breaks
• Headers and Footers
• Word Count
• Table of Contents
• Index
• Footnotes
• Document Map and Thumbnails
• Document Properties and Security
• Large Document Printing Options
• Templates

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

Introduction to Databases and Tables

The first in the series for building a relational database, this workshop provides the foundation for beginning to create a database and start storing data. Tables are the basis of each database, and we begin here by learning how to plan and design tables.

Topics:

• Planning Your Database and Tables
• Designing Tables
• Field Properties
• Data Entry

Creating Relationships

Access is designed for relational databases so that separate tables of information can share data.

Topics:

• Understanding Relationships
• Primary Keys
• Creating Relationships
• Working with Subdatasheets

Queries

Now that your data is stored, you might want to find a way to view it according to certain criteria, or view certain data. Queries allow you to pull specified records for viewing or editing. In this workshop you will learn how to design the queries and understand what they are used for.

Topics:

• Types of Queries
• Designing a New Query
• Running Queries
• Using Criteria
• Creating Parameter Queries

Forms and Reports

Forms give you a way to create a more user friendly interface for data entry and data viewing. Reports provide a printout of complete or summarized data. Learn how to create and format both.

Topics:

• Creating a New Form
• Using a Form
• Using the Form Wizard
• Creating a New Report
• Editing a Report

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 2007)
• 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. If you include multimedia in your presentation, the Pack and Go Wizard is the best way to transport it to new locations for showing.

• Animation
• Adding video and sound files
• Automating your presentation
• Pack and Go

Creating Professional Publications

Create professional publications quickly and easily. Control text and graphics on a page. Whether you need to make poster, flyers, brochures, postcards, newsletters, or other publications, Publisher makes it clear and simple. A one-session workshop will get you well on your way to designing attractive documents.

• Starting a new publication
• Setting up and managing the document
• Adding text and graphics
• Integrating text and graphics
• Using Master Pages

Using E-Mail

Lotus Notes is the faculty and staff email client used on the UNLV campus, and is the official mode of e-communication. The Using E-Mail workshop will provide the basic skills necessary to effectively use Lotus Notes Email.

Topics:

• The Lotus Notes Environment
• E-Mail Basics: Read, Reply, Create, Send, Address Book
• Email Tools and Options: Delivery options, Attachments, preview, out of office
• Managing Email: Drafts, deleting, folders
• Accessing Lotus Notes on the Web
• Using Proofpoint to Control Spam

Using the Calendar and To Do List

Keep yourself organized with Calendar entries, schedules, reminders, to do lists, and more in the Lotus Notes Calendar and To Do List.

Topics:

• The Calendar Environment
• Creating an Appointment
• Scheduling a Meeting
• Responding to an Invitation
• Managing the Calendar: Edits, Views, Preferences, Options, and Printing
• Calendar Delegation
• Using the To Do List

Reducing Your Mail File Size / Copying Your Mail File

Your mail file should be 1,000 MB or less. Small inboxes run better and do not cause problems for UNLV servers, and large mail files can become corrupt and consume costly space on our servers. We suggest you make a desktop copy of your Lotus Notes mail files, and then delete them from your account.  We'll show you how!

Topics:

• Checking your mail file size
• Copying your mail file to your computer
• Viewing the local copy of your mail file
• Tips on how to reduce the size of your mail file