Home > Departments > Information Technology > Classes

Feedback

Classes

Current Class Schedule

GLVAR is happy to offer a series of classes to members on computers, the Internet, Mac, and Microsoft Office products!  The Center offers a State-of-the-Art Training Lab with 12 student stations, over-flow seating and full multi-media abilities.  Because of the limited space, there is a nominal charge of $35.00 per course. The $35.00 charge will be refunded to your GLVAR account after confirmed attendance at the course. This makes training FREE to all GLVAR members! All attendees will receive a Certificate of Completion and gain invaluable knowledge!

Microsoft Outlook - Basics

Open and view pictures and attachments safely.
Print pictures and attachments that you receive.
Organize messages with attachments to make them easy to find (even if you've filed them away in folders in your mailbox).
Know your choices for including pictures and files with your e-mail messages so that you can send them the way you want to.
Avoid sending a blocked attachment. (And know what to tell the sender if you receive a message with one.)
Use the right type of calendar entry for each occasion.
Use reminders to remember what's in your calendar.
Use recurrence to quickly schedule items that occur more than once.
Show time in your calendar according to your needs.
Identify the basic components required for organizing a meeting and know what goes on behind the scenes.
Set up a meeting, see who's coming, make changes, and keep everyone updated.
Manage and respond to meeting requests.
More...
******* Cancellation is required within 48 hours from the start of the class to receive a refund. Sorry no exceptions. ***********

---

MS Publisher Basic 2010

With the new design of Microsoft Office PowerPoint 2007, you'll create presentations quickly and smoothly. Office PowerPoint 2007 also has new options for designing slide content that will give your presentations a fresh, polished look. How does PowerPoint deliver on these promises? Here are some examples. The new Ribbon, part of the Microsoft Office Fluent user interface, keeps the commands that you use most often visible while you're working instead of hiding under menus or toolbars that you have to hunt for. Also, commands that you may not have known about before are now very easy to discover. When it comes to designing your slides, live preview of style galleries lets you see how things such as backgrounds and shape formatting will look before you apply them. A new SmartArt graphics feature offers new diagram types and more layout options, and lets you convert text such as a bulleted list into a diagram.
******* Cancellation is required within 48 hours from the start of the class to receive a refund. Sorry no exceptions. ***********

---

MS Excel Intermediate 2010

MANIPULATING DATA, & NAMED RANGES " Paste Special " Transposing data " Importing text and delimiting by space, comma or tab " What does naming a cell range mean? " Rules for naming cells and ranges " Naming cell range(s) in a worksheet " Named ranges within formulas " Navigating through workbooks using named ranges " Creating named ranges automatically based on cell values " Deleting named cells/ranges " Creating subtotals " Removing subtotals TEMPLATES " Using templates " Creating templates " Opening and editing templates FORMATTING & DISPLAY TECHNIQUES " Formatting tables " Formatting tables using table styles " Formatting cell ranges using conditional formatting " Creating custom number formats " Freezing the top row " Freezing the first column " Freezing the top row and the first column at the same time " Hiding and un-hiding rows " Hiding and un-hiding columns " Hiding and un-hiding worksheets SORTING AND QUERYING DATA " Sorting internal Excel databases " Custom sort options " Using AutoFilter to query data " Multiple queries " Removing filters " Top 10 AutoFilter " Filtering unique records " Advanced Filter LINKING & CONSOLIDATING DATA " Linking individual cells within a worksheet " Linking charts to data within a worksheet " Linking a cell range on one worksheet to another worksheet (within the same workbook) " Linking data on one worksheet to a chart in another worksheet (within the same workbook) " Linking data from one workbook to another " Linking a chart from one workbook to another " Copying data from Excel into a Word document " Linking data from Excel into a Word document " Copying a chart from Excel into a Word document " Linking a chart from Excel into a Word document " Consolidating da
******* Cancellation is required within 48 hours from the start of the class to receive a refund. Sorry no exceptions. ***********

---