Introduction to Computer Security (Windows)

This workshop will cover the ways to prevent various threats to your home and office computer. Topics include viruses, spyware/adware, and the proper use of software and hardware firewalls. By the end of the workshop, you should have a good knowledge of the various computer security issues and how to protect yourself.

Access 2007 Part 1 (Windows)

Prerequisite: What's New in Office 2007 Videos

This workshop will introduce the student to the concept of a database and how to use it. Much time will be devoted to database theory and proper database design. Topics discussed will include tables, fields, records, relationships and relationship types, primary keys, foreign keys, simple database normalization, and database planning and diagramming. Students will then be introduced to the new Access 2007 interface and will begin building a database in Access 2007. Also covered in the workshop will be an introduction to data types and how to build tables. Although Access 2007 is the software program used in this course, the concepts learned carry over to any database software package.

Access 2007 Part 2 (Windows)

Prerequisite: What's New in Office 2007 Videos, Access 2007 Part 1 or equivalent experience

This workshop will build upon the concepts learned in Part 1. Students will continue to build tables in Access 2007 and will be introduced to some advanced options within the table design, including the assigning of Primary Keys, Indices, and forming data input masks. Students will also learn how to build table relationships learned from Part 1 into their database design. Students will then learn query design, including SELECT, UPDATE, APPEND, and DELETE queries; along with advanced query criteria. Students will then be introduced to form creation.

Access 2007 Part 3 (Windows)

Prerequisite: What's New in Office 2007 Videos, Access 2007 Parts 1 and 2 or equivalent experience

This workshop will build upon concepts learned in Parts 1 & 2. Students will continue learning about form creation, both through the use of wizards and via manual design. Students will learn to develop multiple forms that work together to create a search through the forms. Students will understand how to navigate records and add/delete records through the use of forms. Form properties will also be discussed. Students will then be introduced to reports, and will create and format reports via wizards and manual creation.

Access 2007 Part 4 (Windows)

Prerequisite: What's New in Office 2007 Videos, Access 2007 Parts 1-3 or equivalent experience

This workshop will conclude discussion of forms and reports. Students will also develop an entire database, from beginning to end, utilizing lessons learned in the previous sections.

Excel 2007 - Formatting and Basic Calculations (Windows)

Prerequisite: What's New in Office 2007 Videos

This workshop will introduce you to Excel 2007 and the concept of using an electronic spreadsheet. Topics will include some of the new features of Excel 2007, such as the Ribbon and how to use it, and the Microsoft Office Button. Other topics will include Excel terminology, exploring the Excel window, navigating the window, selecting and working with data, performing basic calculations and formulas, and formatting.

Excel 2007 - Tables, Charts, and Graphics (Windows)

Prerequisite: What's New in Office 2007 Videos, Excel 2007: Formatting and Basic Calculations Workshop or equivalent experience

This workshop will introduce you to Excel 2007 and the concept of using and electronic spreadsheet. We will discuss some of the new features of Excel 2007, such as the Ribbon and how to use it, and the Microsoft Office Button. Topics will include inserting basic table and charts and manipulating them within the new environment. Other topics will include using graphics such as picturees, ClipArt, shapes, and new features such as Smart Art.

Excel 2007 - Formulas and Functions (Windows)

Prerequisite: What's New in Office 2007 Videos, Excel 2007: Formatting and Basic Calculations Workshop or equivalent experience

This workshop will introduce you to Excel 2007 and the concept of using an electronic spreadsheet. We will discuss some of the new features of Excel 2007, such as the Ribbon and how to use it, and the Microsoft Office Button. Topics will include commonly used formulas and functions such as conditional formatting, lookups, counting and text. We will also spend time in this workshopo exploring any basic formulas or functions you are interested in.

PowerPoint 2007 - Creating a Basic Presentation (Windows)

Prerequisite: What's New in Office 2007 Videos

You've just been asked to create a slide presentation using PowerPoint 2007, and you're not sure where to begin! This workshop takes you through the basics to get your show up and running, from creating your slides, choosing one of the built-in themes to give your slides a professional, polished look, and final steps to help you proof your work, print handouts, and package the presentation onto a CD.

PowerPoint 2007 -  Custom Layouts and Graphics (Windows)

Prerequisite: What's New in Office 2007 Videos,PowerPoint 2007: Creating a Basic Presentation or equivalent experience

It's time to take a closer look at your PowerPoint 2007 layout and graphics choices. Custom layouts will be discussed, including how to create your own custom layouts that you can save as templates to use in other presentations. We'll take a look at the new SmartArt graphics, used to create org charts and much more, and finish up by looking at ways to do more with your color, shape, and text choices.

PowerPoint 2007 -  Adding Animations and Transitions (Windows)

Prerequisite: What's New in Office 2007 Videos,PowerPoint 2007: Creating a Basic Presentation, Custom Layouts and Graphics, or equivalent experience

Give your PowerPoint 2007 presentation the power of movement and sound, as this workshop explores adding animation to your slides, transition effects that occur slide-to-slide, and adding sound effects.

Word 2007 -  Customizing Word and Formatting Documents (Windows)

Prerequisite: What's New in Office 2007 Videos

This training will introduce the new look and feel of Word 2007. Participants of this course will become familiar with Word’s new layout, including the new Ribbon and Tabs structure. Those who take this class will also be exposed to topics that will introduce the concepts of creating basic documents. Topics covered in this course include using Word Help, printing and formatting documents, customizing Word to meet users’ day to day needs, tables, visual effects and graphics, and other topics. After completing this course participants should feel comfortable with upgrading to Word 2007 for basic document creation. Customization of Word should also allow participants to use the new version more intuitively and more efficiently.

Word 2007 -  Automation of Tasks and Mail Merges (Windows)

Prerequisite: What's New in Office 2007 Videos, Word 2007: Customizing Word and Formatting Documents or equivalent experience

This training is a slightly more advanced continuation of the Customizing Word and Formatting Documents workshop . In this class there will be more extensive coverage of Word’s more involved topics. Class participants will learn to customize documents, create lists, automate everyday tasks, modify and insert graphics, perform mail merges, and more. After completing this class, participants should have a greater understanding of new Word features and should be more confident with Word 2007. Those who complete this course will be more proficient with Word 2007 and will be able to create more advanced, appealing documents.

Desktop Publishing with Word 2007 (Windows)

Prerequisite: What's New in Office 2007 Videos, Word 2007: Customizing Word and Formatting Documents or equivalent experience

This workshop will provide you with the core skills necessary to create documents with complex formatting, such as newsletters, brochures, leaflets, and small catalogs. The use of columns, WordArt, textboxes, drawing tools, and various types of graphics and clipart will be thoroughly explained and demonstrated. This workshop is specifically designed to allow users to unlock the full potential of Word 2007.

Introduction to Windows Vista (Windows)

Please note: For faculty/staff attending this workshop, it is recommended that you have Windows Vista already installed on your campus computer

This is an introduction to the basics of Microsoft Windows Vista Operating System. Topics include navigating the Windows environment (including the desktop and start menu), manipulating windows, starting applications, browsing for files and folders, and a survey of the free utilities included with Windows. This will be a hands on course in which class participants will follow steps to complete basic Windows operations. No previous Windows experience is required for this course.

Back to Top