Getting Started with Microsoft Office 2007

A. Introduction to Office 2007

• About Business Technology
• About Microsoft Office 2007
• Use the Mouse
• Use the Keyboard
• Start and Exit Microsoft Office Programs
• Identify Common Screen Elements
• Conventions Used in This Book

B. Executing Commands   

• 1. About Commands
• 2. About the Ribbon
• 3. Use the Ribbon
• 4. Use Access Keys
• 5. Use the Office Button
• 6. Use the Quick Access Toolbar
• 7. Use a Mini Toolbar
• 8. Use Shortcut Menus
• 9. Use Dialog Box Options
• 10. Use Task Panes

C. PowerPoint Window

• 11. Zoom
• 12. Scroll
• 13. Use Multiple Windows

D. Office Help

• 14. Use the Help Program
• 15. Search for Help
• 16. Use the Help Table of Contents
• 17. Recover a File

Introduction to Word 2007

A. The Word Window

• 18.Start Word
• 19.The Word Window
• 20.Change the Word Window

B. Creating, Editing, Saving and Printing Documents

• 1. Create a New Document
• 2. Work with Show/Hide Marks
• 3. Move the Insertion Point in a Document
• 21. Use Click and Type
• 22. Type in a Document
• 23. Correct Errors
• 24. Use Undo, Redo, and Repeat
• 25. Save a New Document
• 26. Close a Document
• 27. Types of Business Documents
• 28. Printing and Previewing a Document
• 29. About Press Releases

C. Correcting Errors

• 30. Correct Spelling as You Type
• 31. Correct Grammar as You Type
• 32. Check Spelling and Grammar
• 33. Use the Thesaurus
• 34. Use AutoCorrect

D. Paragraph Formatting

• 35. Align Text Horizontally
• 36. Align a Document Vertically
• 37. Line Spacing
• 38. Paragraph Spacing
• 39. About Memos

E. Letters and Envelopes

• 40. Format a Business Letter
• 41. Insert the Date and Time
• 42. Format a Modified-Block Business Letter
• 43. Format a Personal Business Letter
• 44. Create an Envelope
• 45. Create Labels

F. Formatting: Tab and Fonts

• 46. Set Tabs
• 47. Use Uppercase Mode
• 48. Change Case
• 49. About Fonts
• 50. Change the Font
• 51. Change Font Size
• 52. Apply Font Styles
• 53. Apply Underlines

Basic Editing Skills

A. Proofreading and Editing Documents

• 54.Use Proofreaders’ Marks
• 55.Insert and Edit Text
• 56.Use Overtype Mode

B. Working with the Document Window

• 57.Use Split Screen View
• 58.Open Multiple Documents at the Same Time
• 59.Arrange Documents On-Screen
• 60.Compare Documents Side by Side

C. Copying, Cutting and Pasting Data

• 61. Move Text
• 62. Use Cut and Paste
• 63. Use the Clipboard Task Pane
• 64. Use Drag-and-Drop Editing
• 65. Select Paste Formatting Options
• 66. Move a Paragraph
• 67. Use Copy and Paste
• 68. Use Drag-and-Drop Editing to Copy

D. Documents Properties & Open Dialog Box

• 69.Open a Document as Read-Only
• 70.Open a Document from Windows
• 71.Document Properties
• 72.About File Types
• 73.Preview a Closed Document
• 74.Print a Closed Document

Formatting Basics

A. Fonts

• 75.Apply Font Effects
• 76.Font Color
• 77.Highlight Text
• 78.Format Painter
• 79.Use Symbols

B. Bullets and Numbering

• 80.Indent Text
• 81.Bulleted Lists
• 82.Numbered Lists
• 83.Sort

C. Style

• 84.About Styles
• 85.Apply Styles
• 86.Create a Style
• 87.Edit a Style
• 88.Reapply Direct Formatting
• 89.Clear Formatting

D. Page Setup

• 90.Set Margins
• 91.Set Page Orientation
• 92.Format a One-Page Report
• 93.Use Themes
• 94.Use AutoFormat As You Type

Introduction to Excel 2007

A. The Excel Window

• 95.Start Excel
• 96.The Excel Window
• 97.Excel Interface
• 98.Navigate the Worksheet
• 99.Change Between Worksheets
• 100.Worksheet Views

B. Excel 2007 Basic

• 101.Create a New (Blank) Workbook
• 102.Create a Workbook from a Template or another Workbook
• 103.Enter Labels
• 104.Make Simple Corrections
• 105.Undo and Redo
• 106.Delete (Clear) Cell Contents
• 107.Save a Workbook

C. Entering Data and Correcting Errors

• 108.Open Workbooks
• 109.Change from Workbook to Workbook
• 110.Compare Workbooks
• 111.AutoComplete
• 112.Pick From List
• 113.AutoCorrect
• 114.Spell Check
• 115.Enter Numeric Labels and Values
• 116.Enter Dates
• 117.Create a Series
• 118.Change Data Alignment
• 119.Change Column Width

D. Basic Formula

• 120.Enter a Formula
• 121.Edit a Formula
• 122.Select Ranges
• 123.Range Entry Using Collapse Button

E. Font Formatting and Styles

• 124.Choose a Theme
• 125.Apply Cell Styles (Quick Styles)
• 126.Apply Font Formats
• 127.Apply Number Formats

F. Copying, Cutting and Pasting Data

• 128.Copy and Paste Data
• 129.Copy Formats

Signups closed for this Course