Short Course Class Descriptions
(last updated: 10/13/09)
Microsoft Excel 2007: Basics
In this workshop, you'll learn how to use various features of Excel, including how to create and format a worksheet, how to perform calculations, and how to customize printouts.
| Specifically, you will learn how to: | become familiar with the Excel 2007 interface and spreadsheet terminology |
| enter various types of data into a worksheet | work with formulas and functions |
| create a simple chart | import text-delimited data into excel |
| format cells and ranges | create named ranges and use them in formulas |
| customize printouts | explore excel templates |
Microsoft Excel 2007: Charts
This workshop introduces the fundamental knowledge and skills required to create effective and accurate charts using Excel.
| Specifically, you will learn how to: | understand and use Excel's charting terminology |
| select appropriate chart types for a specific set of data | create basic chart types, including column, pie, line, XY Scatter, and bar charts |
| add a trendline and equation to the XY Scatter chart | apply custom formats to charts and chart elements |
| save and apply a chart template | add shapes and SmartArt graphics to charts |
Microsoft Excel 2007: Data Management
This workshop, will show how Excel can be used to extract and manipulate data. We will explore some of Excel's table-related features in this workshop, as well as using built-in and custom AutoFill services, specifying data validation criteria, sorting and filtering data, creating and removing subtotals, recording and using macros, and creating a pivot table and pivot chart.
| Specifically, you will learn how to: | work with built-in and custom lists |
| specify data validation criteria | protect a worksheet |
| work with text functions to separate text | convert data to a table and work with table features |
| sort and filter data | create, replace, and remove subtotals |
| record and use a macro | create and format a pivot table |
| link data between worksheets | create a pivot chart |
Microsoft PowerPoint 2007: Essentials
In this workshop, we will begin by selecting a design template and exploring various layouts. We will use different techniques to work with slides and to format text. Finally, we will insert images and apply basic slide transitions before preparing to deliver the presentation.
| Specifically, you will learn how to: | explore the PowerPoint 2007 interface |
| learn the different ways to begin a new presentation | insert existing slides into a presentation |
| add, rearrange, and delete slides | apply layouts, themes, and QuickStyles |
| work with text and bullets | insert clip art and pictures |
| apply simple animations and transitions | create audience and presenter handouts |
| rehearse and deliver a presentation |
Microsoft PowerPoint: Enhancing & Packaging a Presentation
This workshop will expand upon PowerPoint: The Basics, as we use different techniques to make a presentation more visually appealing. We will customize slides with different backgrounds, link documents to a slide, and work with graphics and sound. In addition, we will apply customized animation effects to slides.
| Specifically, you will learn how to: | link and embed tables and charts |
| import an outline from MS Word | Work with color schemes and customized backgrounds |
| link documents to slides | create hyperlinks and action buttons |
| insert and modify WordArt and Smart Art graphics | insert and play sound files |
| apply customized animation to text and objects | package a presentation for use on other computers |
Microsoft PowerPoint: Customizing a Presentation
This workshop will examine the Microsoft PowerPoint features that enable a user to adapt a single presentation so that it is appropriate for different audiences.
| Specifically, you will learn how to: | customize a slide show for different audiences |
| create slide masters | create customized backgrounds |
| create hyperlinks to Web sites, documents, and slides | user action buttons to navigate a presentation |
| create triggers to increase interactivity | add music to a presentation |
| configure a presentation to loop automatically |
MS Word 2007: Basics
Don't use Word very often? Then you probably have some gaps in your knowledge-base. And you probably want to begin with the basics and work your way up to adding headers and footers and all the fancy stuff.
| Specifically, you will learn how to: | compose and edit documents |
| add basic text formatting | move and copy text |
| name and save documents | use the Help feature |
| check spelling and grammar | print documents |
MS Word 2007: Essentials
This workshop provides an overview of essential features of Microsoft Office Word 2007 that can make word processing more efficient and powerful. Word 2007 provides many tools that enable the integration of text, tables, and graphics. Its conversion features allow the opening of documents made in earlier versions of Word as well as several other word processing applications, such as WordPerfect.
| Specifically, you will learn how to: | use the Ribbon and Mini toolbar |
| utilize views and styles | align text using tabs and indents |
| sort information | format bulleted and numbered lists |
| create headers and footers | create cover pages |
| add bibliographies and footnotes |
MS Word 2007: Mail Merge
In this class you will create a certificate, two mail merge letters, envelopes and address labels.
| Specifically, you will learn how to: | create merge data files in Microsoft Word 2007 and Excel 2007 |
| use Microsoft Access 2007 as a merge data source | populate a document with merge fields |
| perform a mail merge (1 from Word, 2 from Excel, and 2 from Access) | create and execute conditional merges |
| create merges for envelopes and labels |
MS Word 2007: Graphic Features
In this workshop, we will create two different documents. One will be a a simple logo for a company. The other will be a promotional flyer.
| Specifically, you will learn how to: | insert and modify Clip Art and graphics |
| use Word's drawing tools | create and modify text boxes |
| define and create columns | insert and modify WordArt and tables |
| import images into the Clip Organizer | find and download images from the Web |
MS Word 2007: Desktop Publishing (Working with Longer Documents)
Desktop publishing is not just for people who create newsletters. If you prepare multi-page reports you are doing Desktop Publishing. This workshop addresses working with longer documents that have section breaks, customized header/footer, and creating customized styles vs. formatting. A productivity enhancer!
| Specifically, you will learn how to: | |
| design a document layout | create a table of contents |
| customize headers and footers | format document sections, columns and text boxes |
| insert and modify graphics | insert drop-caps and symbols |
| create a template | create and edit styles |
MS Word 2007: AutoCorrect & Styles
If you use word every day, you'll love this class because you'll be able to apply everything you've learned to your daily workflow. In this workshop, the primary focus will be on creating specialized styles and themes so that all our documents have a similar look and feel. Then, we'll create a template from our stylized document so that our styles are saved with the template. Last, we'll combine three non-formatted documents and apply section breaks, styles, a cover page, a table of contents and page numbering. If that isn't enough, you will also learn along the way how to stop Word from interrupting workflow with its AutoCorrect and Auto-Format functions.
| Specifically, you will learn how to: | create, apply and modify styles to format a document |
| use themes and building blocks | share customized styles between documents |
| automatically generate a table of contents | use and modify the AutoCorrect function |
| control AutoFormat As You Type settings | disable Word's automatic features |
Audience: Faculty/Staff
Lab Location: KT 205B