[Dickinson College] Technology Services

Technology Services

News & Events

Microsoft Office 2008 for Mac's

Microsoft Office 2011 is here. These are for reference only as the campus has moved to the newest version. This is Microsoft's own site with tutorials and courses detailing all elements of the Office 2011 programs. Click here for Office 2011 tutorials

Introduction to Office 2008 - Quick Introduction
Microsoft Office 2008 Tutorials Listed Below Microsoft Word 2008 Microsoft Excel 2008 Microsoft PowerPoint 2008 Entourage 2008 Basic Mac Activities

Microsoft Word 2008
Learning Document Basics Saving, Creating & Opening a document Setting Preferences for Saving Documents Using Print Preview & Closing a Document Paragraph & Page Formatting Options Changing Paragraph Alignment Line & Paragraph Spacing - Change Spacing & Default Video Indents, Margins & Inserting Page Breaks Working with Text Options Formatting Text, Changing Font, Size & Color Changing Character Formatting Symbols & Special Characters Inserting Symbols & Special Characters Bullets & Numbering Bullet Lists & Using the Bullet Toolbar Auto Formatting & Formatting Bullets Modifying & Customizing Bulleted Lists & Numbered Lists Working with Tables Table Basics Resizing - Adding, Adjusting Rows & Columns Table Borders & Shading Inserting Quick Tables Sorting a Table & a List Calculations within Tables Navigating Within a Table Styles Basics Accessing the Formatting Palette Creating, Applying & Modifying Styles Clearing All Formatting & Applying a New Style Using Track Changes Understanding the Reviewing Toolbar Making Edits, Inserting Comments & Viewing Options Editing, Deleting Comments, Accepting & Rejecting Changes Auto Correct & Auto Text Auto Format Options & Customizing Options Creating, Inserting & Deleting Auto Text Entries Line Spacing Merge Functions Merge Overview Working with the Data Source Using Excel Database for Mail Merge Creating Merged Letters Creating Merged Mailing Labels Creating Merged Envelopes Miscellaneous Topics Setting Tabs Changing Word Defaults Removing Hyperlinks Using Clip Art & Text Wrap Borders & Shading Creating Fractions Columns Using Equation Editor Working With Images Columns Headers & Footers Find & Replace

Microsoft Excel 2008
Excel Getting Started Opening Excel & Creating a Workbook Entering Text & Numbers Entering Numbers Formatted as Text Entering Dates & Times - Saving Your Work Organizing Worksheets Renaming Worksheet Tab Inserting & Moving Worksheets Copying & Deleting Worksheets Chart Elements Adding a Chart Title & Working with Axes Adding a Legend & Data Labels Adding a Data Table & Grid lines Formatting Your Chart Chart Styles - Colors, Patterns & Pictures Create an Exploding Pie or Doughnut Slice Borders, 3D, Shadows & Chart Fonts Using the Fill Command Filling Cells & Working with Custom Fills Working with Range Names Naming Ranges: Tips & Creating Range Names Adjusting Range References & Deleting Range Names Using Range Names in Formulas/Functions Establishing Criteria Types of Conditions Defining Single & Multiple Criteria Hiding Rows, Columns & Cells Hiding Columns & Redisplaying Columns Hiding Rows & Redisplaying Rows Hiding Cell Contents Paste Special Using the Paste Special dialog box & Paste Special Features Getting Random Numbers Importing Data Excel Database Basics Tips for Setting Up a Database Creating a Database & Using Database Forms Using the Worksheet Window Filtering Data Working with Pivot Tables Notes on Working with Pivot Tables Creating a Pivot Table & Creating a Pivot Table Report The Pivot Table Field List Illustrated & Pivot Table Tools Functions & Subtotal Functions Using the Subtotal Function Using a Filter to Analyze Subsets Modifying the Subtotal Function Function Numbers Adding Headers & Footers Using Preset Headers & Footers Creating Custom Headers & Footers Header and Footer Elements Customizing Page Layout Changing the Orientation & Changing the Paper Size Adjusting the Scale & Adjusting the Margins Centering the Worksheet on the Page Format Data - Numbers, Fractions & more Printing Basics in Excel Printing Options Split data

Microsoft PowerPoint 2008
Basic Tasks Opening PowerPoint & Starting a New Presentation Inserting New Slides & Changing a Slide Layout Applying a Slide Theme Template & Saving a Presentation Opening a Presentation & Preparing to Print Handouts Creating Handouts Adding Headers and Footers Customizing Handouts - Printing Handouts Links Linking to a File or Website Linking to Slides in the Same or Other Presentations Keyboard Shortcuts & Views Formatting Palette Formatting Text & Objects Easily Using Palette Tools & Options Adding Images, Text & Bullet Lists Working with Sounds, Video & Animation Slide Master & Outline Creating, & Customizing a Slide Master Viewing the Presentation Online SmartArt - Make your Presentation Shine!

Entourage 2008
Email Functions Calendar Functions
Entourage Email Functions
Email Basics Sending, Receiving, Deleting & Printing Emails Email Basic Activities Forwarding & Replying to Email Messages Sending Email to Contacts in Your Address Book Contacts Adding, Modifying & Deleting Contact Entries Addressbook Views Viewing Contact Information Adding or Removing Fields & Sorting by Field Working with Attachments Attachment Etiquette Sending, Opening & Saving Attachments Managing Your Emails Flagging Messages & Flagging Messages for Follow Up Changing Message Status Managing Email Folders Creating a New Folder & Transferring Messages to Folders Selecting Multiple Messages Opening & Deleting Folders Deleting Folders Empty the Deleted Items Folder Creating an Out of Office Reply Enabling and Disabling Your Out Of Office Reply General Tips & Considerations - Creating an Out of Office Reply Working with Signatures Signature Guidelines & Creating a Signature Assigning a Default Signature - Signature to a Specific Message Modifying & Deleting Your Signature Using Junk Email Filters Changing the Sensitivity of the Junk E-mail Filter Excluding Senders from the Junk E-mail Filter Using Outlook Web to Activate Safe Email Domains Using Rules to Organize your Emails Types of Rules - Creating, Enabling & Disabling Rules Deleting, Modifying & Changing Rules Groups - Setup, Add & Remove users Junk Emails - Click here for Mac's using Safari

Entourage Calendar Functions
Calendar Environment About Calendar & Selecting a Calendar View Scheduling a New Event & Scheduling a Recurring Event Creating Tasks & Creating Recurring Tasks Viewing Tasks & Changing & Deleting Events or Tasks Customize your Calendar Adjusting Automatic Reminders Adjusting Day & Time Settings Planning Events Event Planning Considerations Checking Availability & Sending Event Invitations Responding to an Event Request Changing & Deleting Events or Tasks Granting Others Access to Your Calendar Shared Calendar Opening Shared Calendars: First Access Opening Shared Calendars: Subsequent Access Removing Shared Calendars from Your Calendar List


Quick Reference Guides for Office 2008 - one page filled with helpful tips
Word 2008 Excel 2008 PowerPoint 2008 Entourage 2008

Basic Mac Activities
Basic - Navigating Understanding a Mac Computer Copy, Cut & Paste Saving Files Saving Files to CD Files - Additional Options Fonts Change Default Opening for PDF files Creating an Alias Working with CD's Keyboard Shortcuts Even more Shortcuts Keyboard & Mouse Options Printing Basics Mac Terms

Looking for classes or workshops? Click here.
Questions about these tutorials?

Some of these documents are based on and developed from information published in the LTS Online Help Collection (www.uwec.edu/help) developed by the University of Wisconsin-Eau Claire and copyrighted by the University of Wisconsin Board of Regents. Used by permission.

Technology Services

News & Events

Microsoft Office 2008 for Mac's

Microsoft Office 2008 Tutorials Listed Below

Microsoft Word 2008