|
Excel 1
(Duration 1 day, 9/19/2006)
|
Outlook 2003 - Level 1
(Duration 1 day 9/21/2006)
|
|
This course is designed for persons preparing who desire to gain the skills necessary to create, edit, format, and print basic Microsoft® Office Excel 2003 worksheets. At Course Completion you will create and edit basic Microsoft® Office Excel worksheets and workbooks.
|
This course will provide students with the skills needed to start sending and responding to email in Microsoft® Office Outlook 2003, as well as maintaining the Calendar, scheduling meetings, and working with tasks and notes. At Course Completion you will compose and send email, schedule appointments and meetings, manage contact information and tasks, and use notes.
|
Lesson 1: Getting Started with Excel
|
Lesson 1: Getting Started with Outlook
|
|
An Overview of Excel
Navigate in Excel
Select Data
Enter Data
Save a Workbook
Obtain Help
|
Log On to Outlook
The Outlook Environment
Compose and Send a Simple Message
Open a Message
Reply to a Message
Print a Message
Delete a Message
|
|
Lesson 2: Modifying a Worksheet
|
Lesson 2: Composing Messages
|
|
Move and Copy Data Between Cells
Fill Cells with Series of Data
Edit Cell Data
Insert and Delete Cells, Columns, and Rows
Find, Replace, and Go To Cell Data
Spell Check a Worksheet
|
Address a Message
Format a Message
Check Spelling and Grammar
Attach a File
Forward a Message
|
|
Lesson 3: Performing Calculations
|
Lesson 3: Managing Mail
|
|
Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Create an Absolute Reference
|
Open and Save an Attachment
Flag a Message
Create a Folder
Move Messages to a Folder
Copy Messages to Folders
Delete a Folder
|
|
Lesson 4: Formatting a Worksheet
|
Lesson 4: Scheduling Appointments
|
|
Change Font Size and Type
Add Borders and Color to Cells
Change Column Width and Row Height
Merge Cells
Apply Number Formats
Create a Custom Number Format
Align Cell Contents
Find and Replace Formats
Apply an AutoFormat
Apply Styles
|
The Outlook Calendar
Schedule an Appointment
Assign a Category to an Appointment
Update Calendar Entries
|
|
Lesson 5: Developing a Workbook
|
Lesson 5: Scheduling Meetings
|
|
Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Copy a Workbook
|
Schedule a Meeting
Reply to a Meeting Request
Propose a New Meeting Time
Track Meeting Responses
Update a Meeting Request
Cancel a Meeting Request
Print the Calendar
|
|
Lesson 6: Printing Workbook Contents
|
Lesson 6: Managing Contacts
|
|
Set a Print Title
Create a Header and a Footer
Set Page Margins
Change Page Orientation
Insert and Remove Page Breaks
Print a Range
|
Add a Contact
Sort Contacts
Find a Contact
Generate a Map
Edit a Contact
Delete a Contact
Print Contacts
|
|
Lesson 7: Customizing Layout
|
Lesson 7: Managing Tasks
|
|
Split a Worksheet
Arrange Worksheets
Freeze and Unfreeze Rows and Columns
Hide and Unhide Worksheets
|
Create a Task
Edit a Task
Update a Task
|
|
|
Lesson 8: Using Notes
|
|
|
Create a Note
Edit a Note
Copy a Note
|
We work with New Horizons, bringing relevant and affordable computer training to you and your staff. Our customers, colleagues and friends can get training at a discount if they purchase it through us.
