This introductory level class will provide basic skills in Access 2007. Topics include creating and modifying tables, finding and filtering data, creating relationships, using simple queries, and creating basic forms and reports.

This intermediate level course will provide in-depth information on queries. The participant either should have taken the intro class, or have experience using Access. Topics include creating simple queries, modifying results, creating calculated fields, creating Function and Parameter queries, filtering, creating Action queries, and using Advanced query wizards.

This intermediate level course will provide in-depth information on creating forms and reports. Topics include creating basic forms and reports, creating option groups, adding headers and footers, creating summaries, using subforms and subreports, changing control properties, and creating command buttons.

This advanced class will help the user customize and better manage their Access database. Topics include setting field properties, using the Table Analyzer wizard, working with indexes, importing and data, compacting and backing up databases, exporting data to Excel and Word, using charts, and replicating databases.

This introductory level class teaches the basic functions and features in Excel 2007. Topic include basic workbook skills, working with ranges, creating formulas, copying and moving data, working with columns and rows, using page setup, and printing.

This beginner level class will provide further introductory instruction in Excel 2007. Topics include formatting numbers, text, and cells, using automatic formatting styles, creating conditional and custom formats, using templates, using worksheet protection, and using paste special.

This intermediate level class will focus on the graphics capabilities within Excel 2007. Topics include drawing objects, using effects on objects, using autoshapes and diagrams, and creating, editing, formatting, and modifying charts.

This intermediate level class will focus on features useful when working with data lists in Excel. Topics include managing data, working with databases, working with the data form, using AutoFilter, and working with advanced filters.

This intermediate level course teaches students how to use multiple worksheets and workbooks efficiently. Topics include importing and exporting data, using auditing tools, consolidating worksheets, working with multiple worksheets, managing worksheets, using and sharing workbooks, and managing files.

This course builds on the skills and concepts taught in all previous Excel 2007 classes. Topics include working with Comments, working with Outlines, working with Data Series, creating and using PivotTables, managing worksheets, and customizing Excel preferences.

Students will learn the basics of creating and running macros. Topics include using macros, recording and editing macros, using custom toolbars and buttons, working with the Personal Macro workbook, debugging macros, and creating a macro button.

This class will build on concepts learned in the Intro to Macros class and delve into using Visual Basic for Applications to create, run, and edit macros. Throughout the  course participants will develop macros to: format worksheets, create an interactive worksheet, work with multiple worksheets, and perform calculations. 

This intermediate/advanced level course will provide in-depth information on creating, managing and effectively using Pivot Tables in Excel. The participant either should have taken the intro class, or have experience using Excel. Topics include creating simple pivot tables, modifying results, creating interactive pivot tables which automatically extract, organize, and summarize data. Use pivot tables for financial reporting, budgeting, and data analysis.

This 90-minute course will cover a variety of topics to help participants use Outlook more efficiently. Topics include organizing messages, using Categories, using the Query Builder to find Outlook items, working with Rules, working with folders, and managing meetings.

This introductory class will look into the basics of Outlook.

This class will look into the additional features in Outlook. Topics include scheduling with the Calendar, managing Meetings, managing Contacts, working with Tasks, using the Journal, and working with Notes.

This intermediate level class will focus on using Outlook more efficiently. Topics include using Outlook message windows and features, creating HTML messages, using the address book, using the Rules Wizard, working with files and applications, working with folders, customizing the Information Viewer and the Outlook bar, and setting Outlook options.

This course covers the basic functions and features of PowerPoint 2007. Topics include exploring PowerPoint, presentation skills, using the outline tab, editing and proofing text, using slide sorter and slide show view, and printing presentations.

This course will explore customizing your presentation in PowerPoint 2007. Topics include formatting presentation text, using graphics images and drawing objects, creating and editing charts, creating a photo album, and customizing your presentation.

This course builds on the concepts presented in the previous PowerPoint courses. Topics include using SmartArt, applying special effects, creating a custom slide show, sharing the presentation, editing presentation and handout masters, and exporting handouts and slides.

This course presents the basic functions and features of Word 2007. Topics include exploring word, document skills, document views, text editing, character and paragraph formatting, document formatting, using the research task pane, and printing.

This class will provide further introductory instruction in Word 2007. Topics include basic text editing, checking spelling and grammar, using AutoCorrect, using Find and Replace, and customizing Word preferences.

This course will focus on formatting issues in Word 2007. Topics include using character and paragraph formatting, working with newsletter-style columns, section breaks, setting tabs, indenting paragraphs, working with lists, headers and footers, and Quick Parts.

This course covers tables and creating forms in Word 2007. Topics include working with tables, editing a table, sorting table data, using formulas in tables, creating forms, and protecting documents.

This course builds on skills and concepts from previous classes. Topics include inserting dates and symbols, applying borders and shading, working with drawing objects, inserting graphics, SmartArt, and using charts.

This class focuses on creating and editing a mail merge in Word 2007. Topics include creating a mail merge, sorting and filtering a recipient list, creating an email merge, creating a mail merge for labels and directories.

This course will cover creating and working with reference documents. Topics include working with comments and revisions, creating a table of contents and index, creating captions, creating citations and bibliographies, creating bookmarks, working with headers and footers, and creating master documents.

This course will touch on a little bit of everything you need to know to work with Word 2007. Topics include document formatting, using templates and wizards, using mail merge, setting tabs, bulleted lists, headers and footers, graphic objects, working with tables, and using forms.

Students will learn how to create and manage projects using Microsoft Project 2007. Topics include project basics, working with tasks, making adjustments to tasks, outlining tasks, working with views, working with resources, working with calendars, adjusting resources, assigning costs, and working with the Critical Path.

In this course, students learn how to create and modify publications with Microsoft Publisher 2007. Topics include creating basic publications, creating multi-page publications, layout design techniques, and finalizing documents.

This Microsoft product was created to take the place of FrontPage and was formatted to reduce complexity and ease data integration by using powerful design tools and task panes to quickly incorporate XML data. Build dynamic, interactive webpages that harness the power of the Web to deliver superior quality. Built-in support for today's modern Web standards makes it easy to optimize your sites for accessibility and cross-browser compatibility.

Using Adobe LiveCycle Designer (included with Acrobat Professional) you can create interactive PDF forms that can be distributed, filled out, and submitted electronically; the feedback received can be collated quickly and efficiently.

In this course, students will use Adobe Acrobat 9 to make their information more portable, accessible, and useful to meet the needs of their target audience. Topics include working with PDF documents, using the Acrobat interface, creating PDF documents from files, organizing PDF documents, adding bookmarks and hyperlinks, creating articles, using text tools, and working with comments.

In this course students will work with some of the tools and features to create eye-catching printed documents using InDesign CS4. Topics include formatting text and working with text frames, creating and transforming objects, working with colors, gradients and strokes, using frames for special effects, and creating, editing, and formatting tables.

This course will cover using the advanced features of InDesign CS4 to create and design documents. Topics include modifying page layout and using masters, creating and manipulating layers, working with text layout, style options, creating books with tables of contents and indexes, working with PDF documents, and working with print options.

In this course students will learn to use the several tools and features of Photoshop CS4 to work with images. Topics include exploring the Photoshop environment, working with image areas, working with layers, working with selections, enhancing images, and modifying photographs.

This course will cover the skills to enhance your ability to work with images. Topics include masking and clipping layers, masking with vector paths, enhancing photographs, creating special effects, and automating tasks.

Want to learn even more about managing your departmental website using UW’s  Web Content Mgt System? This class is a more advanced look into the software and includes topics such as creating newsletters, custom content pages, and customizing the side navigation links.

Want to learn more about managing your departmental website using UW’s new Web Content Management System? This class will give you hands on experience adding links, content, and changing the existing content. A step-by-step ‘how to’ on the main features of the Web Content Management System to get you started working on your departmental site.

TrueCrypt is a software system which helps you protect sensitive data by maintaining an encrypted data storage area on your computer. No data stored in an encrypted area can be read without using the correct password and encryption keys. If you store sensitive data, you should consider using data encryption. You can bring in and encrypt a storage device on your laptop, or test it on a lab machine before encrypting your computer.