Highlights of the Office 2008 for Mac Training Course
- Navigate through the new easy-to-use interface, Elements Gallery and Document Parts. Plus, you’ll learn about the new Office Art 2.0 giving you the ability to quickly add professionally designed graphics.
- Create and share documents through the new, easy-to-use interface and discover new features such as Publishing Layout View that let users create layout-rich documents.
- Create presentations with pictures, shapes, animation, and advanced delivery options.
- Prepare professional charts and organize, analyze and present data to coworkers, customers, and business partners. You’ll also learn about new Excel 2008 features including Ledger Sheets that enable you to handle common financial management tasks.
- Follow basic and advanced functions of e-mail, planning/scheduling features, and managing tasks and projects. Additionally, brand-new to Mac Office 2008 is a feature called My Day. You’ll learn how to use My Day to track your priorities and stay on top of daily activities regardless of the application you’re working in.
Office 2008 for Mac Training Course Summary
This Microsoft Office course teaches you how to effectively use the Office 2008 for Mac Suite through comprehensive lessons and engaging quizzes, allowing the user to choose which lesson to learn. New users will be guided through the fundamentals of the Office 2008 for Mac interface, while experienced users will be brought up to speed on the new navigation and functionality of this 2008 edition. These courses will train you how to best meet your needs through the use of Word, Excel, Entourage, PowerPoint and the new My Day feature.
Office 2008 for Mac Training Course Bundle Contents contains training for the following:
Microsoft Excel for Mac 2008: Beginner
Getting Started
Launching Excel 2008
Touring the Excel Window
Save vs. Save As
About XML
Opening & Closing Files
Getting Help
Entering Data
Navigation Techniques
Data Entry Techniques
AutoFill
AutoComplete
Undo & Redo
Changing Worksheet Layout
Inserting Rows, Columns & Cells
Deleting Rows, Columns & Cells
Adjusting Column Widths & Row Heights
Hiding Columns & Rows
Moving & Copying Data
Creating Named Ranges
Go To, Find and Replace
Entering Formulas
Anatomy of Formula
AutoSum
Basic Functions
Copying Formulas
Formatting
Using the Formatting Palette
Number Formats
Merging & Splitting Cells
Using AutoFormat
Printing
Changing Margins & Page Orientation
Exploring Worksheet Views
Adding Headers & Footers
Adding Print Titles and a Print Area
Viewing & Setting Page Breaks
Charts
Creating an Embedded Chart
Creating a Chart Sheet
Adding & Removing Chart Data
Format & Resize Charts
Recap
Microsoft Excel for Mac 2008: Intermediate
Managing Workbooks
Creating New Workbooks from a Template
Rename & Move Workbook Tabs
Insert & Delete Worksheets
Copy & Paste Worksheets
Splitting Your Worksheet View
Freezing & Unfreezing Your View
List & Data Management
List Guidelines
Sorting
AutoFilter
Advanced Filter Using Single Criteria
Advanced Filter Using Multiple Criteria
Automatic Subtotals
Using Cell References
Using Relative Cell References
Using Absolute Cell References
Using Mixed Cell References
Auditing
About Auditing
Tracing Precedents
Tracing Dependants
Tracing Errors
Creating Web Pages from Workbooks
Publishing a Web Page
Viewing Your Published Web Page
Using Excel with Other Applications
Importing Data to Excel
Exporting Data from Excel
About XML
Customizing Excel
Customizing Excel’s Toolbar
Modifying Excel Preferences
Using Scenarios & Watching Cells
Creating & Displaying Scenarios
Editing & Removing Scenarios
Summarizing Scenarios
PivotTables & PivotCharts
About PivotTables
Creating a PivotTable
Modifying a PivotTable
Recap
Microsoft Excel for Mac 2008: Advanced
Collaborating
Inserting & Deleting Comments
Viewing & Printing Comments
Protect Workbooks, Worksheets & Cells
Enable Workbook Security
Share Workbooks
Working with Templates
Advanced Formulas & Functions
IF Functions
Nested IF Functions
Using the VLOOKUP Function
Using the HLOOKUP Function
Using the DSUM Function
Data Consolidation
About Data Consolidation
Three Dimensional Formulas
Data Consolidation by Position
Data Consolidation by Category
SmartArt
About SmartArt
Creating a List
Creating a Hierarchy
Creating a Pyramid
Editing SmartArt
Track Revisions
Tracking Changes
Accepting & Rejecting Changes
Data Validation & Conditional Formatting
Working with Data Validation Rules
Set Conditional Formatting
Use Expressions in Conditional Formatting
Recap
Entourage 2008 Level 1
Introduction
Getting Started
Launching Entourage 2008
Touring the Entourage Window
Using the Navigation Pane
Getting Help
Reading & Sending E-Mail
Creating & Sending an E-Mail Message
Using the Address Book
Saving a Message as a Draft
Adding an Attachment to an E-Mail Message
Reading Messages
Viewing Attachments
Replying To & Forwarding Messages
Reply vs. Reply to All
Forwarding a Message
Understanding Message Icons in Your Inbox
Formatting Messages
Using the Formatting Toolbar
Marking Message Importance
Using the Find Feature
Working with E-Mail Addresses
Adding & Editing a Contact
Adding a Contact from an E-Mail Message
Sending a Message from Contact View
Creating & Using Distribution Lists
Managing Mail
Emptying Your Deleted Items Folder
Move & Copy Messages to a Folder
Renaming a Folder
Printing E-Mail Messages
Using the Print Dialog Box
Customizing Entourage
Customizing Entourage’s Toolbar
Modifying Entourage Preferences
My Day
Launching My Day
Customizing My Day
Microsoft PowerPoint for Mac 2008: Beginner
Getting Started
Launching PowerPoint 2008
Touring the PowerPoint Window
Save vs. Save As
About XML
Opening & Closing Files
Getting Help
Creating a New Presentation
Creating a New Presentation from a Template
Creating a New Presentation from Scratch
Adding & Editing Text
Undo, Redo, & Repeat
Viewing Presentations
Navigating Through a Presentation
Presentation Views
Using Slide Show View
Modifying an Existing Presentation
Slide Basics
Choosing a Design Theme
Working with Text Boxes
Formatting Text
Using Bullets & Numbering
Working with Indents & Line Spacing
AutoCorrect
Preparing a Presentation for Delivery
Using Spell Check
Using the Thesaurus & Research Pane
Working with Speaker Notes
Adding a Header & Footer
Printing
Recap
Microsoft PowerPoint for Mac 2008: Intermediate
Outlines
Adding & Editing Slides in Outline View
Formatting Slide Text in Outline View
Exporting a PowerPoint Outline
Working with Pictures and Shapes
Inserting ClipArt & Pictures
Drawing AutoShapes
Grouping & Ungrouping Objects
Layering Objects
Working with Themes
Applying Themes
Creating Custom Themes
Working with Animation
Adding Entrance & Exit Animation
Adding Emphasis
Assign the Order of Animation Effects
Organizing & Enhancing Your Presentation
Duplicating & Deleting Slides
Hiding Slides
Rearranging Slides
Adding Slide Transition
Managing Presentations
Inserting Slides from Other Presentations
Using Find & Replace
Customizing PowerPoint
Customizing PowerPoint’s Toolbars
Modifying PowerPoint Preferences
Recap
Microsoft PowerPoint for Mac 2008: Advanced
Working with Tables
Adding a Table to a Slide
Navigating & Selecting in a Table
Inserting & Deleting Columns and Rows
Formatting a Table
Working with Charts
Creating a Chart
Adding & Removing Chart Data
Formatting & Resizing a Chart
WordArt & SmartArt
Inserting a WordArt Object
Editing a WordArt Object
About SmartArt
Creating a List
Creating a Hierarchy
Creating a Pyramid
Editing SmartArt
Working with Templates, Masters & Custom Layouts
Creating and Editing a Custom Template
Working with Masters
Working with Custom Layouts
Saving Presentations for the Web
Adding a Hyperlink to a Slide
Publishing a Presentation to the Web
Collaboration
Inserting Comments
Viewing Comments
Editing Comments
Advanced Presentation Delivery Options
Working with Action Buttons
Annotating a Presentation
Using Slide Timings
Slide Show Options
Recap
Microsoft Word for Mac 2008: Beginner
Getting Started
Launching Word 2008
Touring the Word Window
About XML
Opening & Closing Files
Getting Help
Creating New Documents
Starting a New Document
Editing Text
Preview & Print a Document
Editing Existing Documents
Opening a Document
Navigating a Document
Working with Multiple Page Documents
Essential Word 2008 Skills
Selecting Text
Moving & Copying Text
Undo, Redo & Repeat
AutoCorrect
Formatting Text & Paragraphs
About Basic Font Formatting
Working with Text Formatting
Working with Line & Paragraph Spacing
Using Format Painter
Adding Symbols & Special Characters
Proofing Tools
Spelling & Grammar
Using the Thesaurus & Other Research Options
Checking Character & Word Count
Working with the Custom Dictionary
Editing in Print Preview
Changing Your Page Appearance
Changing Margins & Page Orientation
Working with Page Breaks
Adding Line Numbers
Recap
Microsoft Word for Mac 2008: Intermediate
Managing Documents
Document Views
Working with Multiple Documents
Saving Your Word Document as a Web Page
Additional Editing Tools
Go To, Find & Replace
Format Painter
AutoText
Paragraph Formatting
Bullets & Numbering
Tabs & Indents
Borders & Shading
Using Styles
Introduction to Graphics
Inserting ClipArt & Pictures
Inserting Watermarks
Using the Formatting Palette with Graphics
AutoShapes
Using Captions
WordArt
Using Publishing Layout View
Document Formatting
Section Breaks
Headers & Footers
Page Backgrounds & Page Borders
Drop Caps
Columns
Tables
Creating Tables
Creating Quick Tables
Navigating & Selecting in a Table
Inserting & Deleting Columns and Rows
Sorting
Formatting Tables
Performing Calculations in a Table
Converting a Table to Text
Customing Word
Customizing Word’s Toolbars
Modifying Word Options
Recap
Microsoft Word for Mac 2008: Advanced
Document Collaboration
Working with Templates
Using Track Changes
Inserting Comments
Merge Documents
Mail Merge
The Mail Merge Process
Walking Throught the Mail Merge Process
Form Letters
Envelopes
Labels
Working with Themes
Using Themes
Creating Custom Themes
SmartArt
About SmartArt
Creating a List
Creating a Hierarchy
Creating a Pyramid
Editing SmartArt
Long or Complex Documents
Bookmarks
Footnotes & Endnotes
Tables of Content
Recap
Instructor: Deanna Reynolds
Deanna Reynolds (MCTS) is an author and technical instructor living in Suffolk, Virginia. Since 1993, Deanna has been privileged to work with students traveling many different career paths on a multitude of software programs, including the entire Microsoft Office suite, project management, desktop publishing, and database development. Throughout her career, Deanna has led hundreds of computer productivity training sessions, from beginner through advanced levels.
Most recently, Deanna’s technical training has extended beyond the classroom to include more than 10 DVD-ROM courses for KeyStone Learning Systems and two published books: Word 2007 Pocket Book (Prentice Hall) and Managing Projects with Microsoft Office Project 2007 (Microsoft Press). |
