PowerPoint 2007 – More Text Based Tutorials

Below you will find links to many useful text based (with screen shots) tutorials on Microsoft PowerPoint 2007 from the University of Wisconsin-Eau Claire

PowerPoint Background Information

• The Office 2007 Environment
• PowerPoint Terminology
• Keyboard Shortcuts
• The PowerPoint Views

PowerPoint Basics

• Basic PowerPoint Tasks
• Making Your Presentation
• Working with a Slide Master
• Working with Text
• Working with Bullets and Numbering
• Printing Your Presentation
• Viewing Your Presentation Outline
• Working with Handouts

Working with Objects

• Modifying Objects
• Using Color
• Using Fill Effects
• Working with Images
• Using Animation
• Creating an Organization Chart

Customizing PowerPoint

• Customizing Slide Elements
• Using the Slide Sorter View
• Customizing a Master Slide
• Working with Design Themes
• Capturing Images, Sounds, and Movies
• Using Sounds and Video

PowerPoint Diagrams

• Working with SmartArt: An Overview
• Working with SmartArt
• SmartArt Formatting Options
• Animating SmartArt

More PowerPoint Features

• Charting Information
• Adding Links
• Making Your Presentation Portable

Viewing Online Presentations

• The Environment
• Creating a Web Presentation
• Working with Online Presentations

Inserting Clip Art

• Overview of Clip Art
• Using Clip Art
• Importing Clip Art from the Web

Using Microsoft Office Help

Excel 2007 – More Text Based Tutorials

Below you will find links to many more useful text based (with screen shots) tutorials on Microsoft Excel 2007 from the University of Wisconsin-Eau Claire

Working with Excel

• Getting Started with Excel
• The Office 2007 Environment
• Pointer Shapes
• Worksheet Terms
• Formatting Cells
• Formatting Numbers
• Working with Conditional Formatting
• Editing Cell Contents
• Calculating with Functions
• Calculating Subtotals
• Working with Rows and Columns
• Importing an External Data File

Printing with Excel

• Printing Basics
• Using Printing Options
• About the Page Setup Dialog Box
• Customizing Page Layout
• Adding Headers and Footers
• Modifying Headers and Footers
• Other Printing Options
• Using Print Preview

Special Features

• Working with Comments
• Using the Fill Command
• Using the Paste Special Feature
• Using the Find and Replace Features
• Hiding Columns, Rows, and Cells
• Separating Cell Data
• Sorting Data

Working with Tables (database functions)

• Tables Overview
• Creating Tables
• Establishing Criteria
• Filtering Your Table
• Analyzing Your Tables with Functions
• Working with Pivot Tables href=”Excel07/subtotal.htm” mce_href=”Excel07/subtotal.htm”>

Managing Your Excel Worksheet

• Organizing Worksheets
• Working with Groups of Worksheets
• Referenceing Cells with Names
• Navigating Your Large Workbook
• Performing Calculations with Formulas
• Cell References: Relative and Absolute
• Correcting Circular References
• Protecting Your Files and Worksheets

Charting with Excel

• About Charting
• Guidelines for Charting
• Getting Ready to Chart
• Creating a Basic Chart
• Formatting Your Chart
• Working with Chart Elements
• Charting Extras

Favorite Excel Functions

• Rank
• Countif and Sumif
• Concatenate
• Subtotal
• Inserting Dates and Times

Automating Excel with Macros

Inserting Clip Art

• Overview of Clip Art
• Using Clip Art
• Importing Clip Art from the Web

Using Microsoft Office Help

Word 2007 – More Text Based Tutorials

Below you will find links to even more useful text based tutorials (with screen shots) on Microsoft Word 2007 from the University of Wisconsin-Eau Claire

Word Environment

• The Office 2007 Environment
• Customizing Toolbars

Word Basics Series

• Learning Document Basics
• Editing a Document
• Working with Spell Check
• Using Grammar Check
• Paragraph Formatting Options
• Page Formatting Options
• Working with Text Options
• Saving in Alternate Formats
• Printing Options for Specific Pages
• Hyphenation Options
• Inserting Symbols and Special Characters (video: Inserting Symbols)
• Setting Tabs
• Borders and Shading Options

Bullets & Numbering

• Using Bulleted Lists
• Using Numbered Lists
• Customizing Bulleted and Numbered Lists

Using Outlining

• Outlining: Using Outline Numbering
• Outlining: Bullet and Numbering Options
• Outlining: Using the Outline View

Organizing Information with Word Tables

• Table Basics
• Creating a Table from Existing Text
• Table Options
• Navigating and Selecting within a Table
• Merging and Splitting Table Cells
• Resizing Table Elements
• Formatting Tables
• Adding Borders and Shading
• Using the Sort Feature
• Calculations within Tables

Inserting Fields and Text

• Summary of Word Fields
• Inserting Fields

Using Word Styles

• Styles: An Overview
• Style Basics
• Advanced Style Options
• Style Organizer

Working Collaboratively

• Working with the Track Changes Feature
• Protecting a Document
• Combining Word Files

Curing Auto Headaches

• AutoCorrect: Corrections and Replacements
• AutoCorrect: Automatic Formatting

Automating Your Work

• Working with Templates
• Automatic Page Cross-References
• Generating a Table of Contents
• Using Find and Replace
• Creating Macros
• Working with Macros
• Working with Bibliographic Sources
• Working with Bibliographic References

Labels and Envelopes

• Labels: An Overview
• Creating Labels
• Customizing Labels
• Working with Envelopes
• Additional Options for Creating Envelopes

Mail Merge and Form Letters

• Mail Merge: An Overview
• Mail Merge Terminology
• Working with the Recipient List
• Filter and Sort Options
• Creating Merged Letters
• Using an Excel Database for Mail Merge
• Creating Merged Mailing Labels
• Creating Merged Envelopes
• Creating an Email Merge

Customizing Word

• Changing Word Default Selections
• Adding a Dictionary
• Removing Hyperlink Formatting from URLs
• Working with File Properties

Inserting Clip Art

• Overview of Clip Art
• Using Clip Art
• Importing Clip Art from the Web
• Importing Clip Art from the Office 2003 Server

Inserting WordArt

• Using WordArt
• Editing WordArt

Working with the Equation Editor

• The Equation Editor Environment
• Creating Fractions
• Inserting Built-in Equations and Structures
• Equation Editor Options
• Creating Custom Mathematical Expressions

Miscellaneous Topics

• Working with Columns
• Creating Headers and Footers
• Working with Images
• Adding and Removing Watermarks
• Adding Line Numbers
• Using Microsoft Office Help

Outlook 2007 – Text Based Tutorials

The University of Wisconsin-Eau Claire has made all their fantastic tutorials on Office 2007 available online. Below you will find links to text based tutorials (with screen shots) on Microsoft Outlook 2007.

General Information

• The Office 2007 Environment
• The Outlook Environment
• Managing Your Account Quota
• Off Campus Access to Email: POP3 Server
• Off Campus Access to Email: Without VPN
• Emptying the Deleted Items Folder

Email Overview

• Basic Email Activities
• Locating Recipients
• Additional Email Activities (forward,reply, send to contacts)
• Working with Attachments
• Working with Signatures
• Automating Appearance with Stationery
• Automating Content with Templates

Organizing & Managing Email

• Options for Managing Email: An Overview
• Managing Your Email
• Sorting Your Email Messages
• Managing Email with Folders
• Viewing Email with Filters
• Using Junk E-mail Filters
• Using Rules to Organize Your Email
• Modifying Existing Rules

Additional Options

• Message Options
• Creating Out of Office Replies
• Email Message Formats
• Customizing Email Settings
• Customizing Column Headings
• Recalling Sent Messages

Archiving

• AutoArchiving: An Overview
• Working with AutoArchive Default Settings
• Customizing AutoArchive Settings
• Enabling and Disabling AutoArchiving
• Working with Archived Items
• Manual Archiving
• Compacting the Archive Folders

Navigation Pane

• General Navigation Pane Options

Calendar Basics

• The Calendar Environment
• Scheduling Appointments
• Scheduling Events
• Modifying Appointments & Events

Additional Calendar Features

• Using the Scheduling Assistant
• Working with Group Schedules
• Granting Others Access to Your Calendar
• Working with Shared Calendars
• Viewing a Public Calendar as Shared
• Adding a Mailbox to Your Folder List
• Creating a Public Calendar

Calendar Customization & Options

• Customizing Your Calendar
• Calendar: Working with Holidays
• Color Coding Appointments
• Printing Your Calendar

Contacts Overview

• Contacts Viewing Options
• Working with Contacts
• Assigning Contacts to Categories
• Working with Distribution Lists

Using Microsoft Office Help