Basic Microsoft Word, Excel and Outlook 2007
1 hour classes per week for 7 weeks - 8:00am or 1:30pm time slots.
Every Thursday starting 2012.
Classes held at Palm Beach Share n Care, Tenth Ave, Palm Beach.
9 seats each class. Only $125.00
~~Course Outline~~
Getting Started with Word
- Navigating Word Interface
- Understanding “The Ribbon”
- Customising The Quick Access Toolbar
- Using Word’s Document tools
Creating and Saving Documents
- Creating a New Document
- Importing Documents
- Saving Documents
- Sending Documents
Editing & Formatting Text
- Understanding Fonts
- Selecting Text using Mouse & Keyboard Functions
- Text Cut, Copy, Paste
- Undoing & Redoing actions
- Basic Formatting
- Editing the Case of Text
- Text Effects to Add Impact
Formatting Paragraphs
- Aligning & Justifying Paragraphs
- Changing Line Spacing
- Using Indents & Tabs
- Creating bulleted or Numbered Lists
- Page Breaks
- Shading & Borders
Formatting Pages
- Changing Margins
- Changing Orientation
- Choosing Paper Size & Source
- Headers & Footers
- Applying a Page Background
Getting Started with Excel
- Common Uses for Excel
- Exploring Common uses for excel
- Finding Commands Required
- Using File Tab
- Maintaining File Compatibility
Worksheet Basics
- Creating a Worksheet
- Copying & Pasting
- Entering Data with Auto Fill
- Targeting Large Data Groups
- Changing Worksheet Structures
Excel Formula Basics
- Understanding Functions & Formulas
- Entering Data in Worksheets
- Adding Numbers manually
- Using “Sum” & “AutoSum”
- Preventing Errors with Absolute References
- Working with Times & Dates
- Using “IF”, “SUMIF” &”AVERAGEIF
- Naming & Using Cell Ranges
Essential Formatting
- Formatting Numbers & Dates
- Applying Fonts and Borders
- Adjusting Columns and Rows
- Conditional Formatting
- Custom Conditions Formatting
Outlook Basics
- Starting Outlook
- Setting up Email Account
- Reading & Organising Mail
- Working with Contacts
- Creating New Mail
- Sending, Replying & Forwarding
