| Microsoft Excel 2003: Level 1 |
|
|
|
|
|
Overview: Microsoft Excel 2003: Level 1
This course is designed for persons who desire to gain the skills necessary to create, edit, format, and print basic Excel 2003 worksheets.
Course Outline:
Lesson 1: Getting Started with Excel A: An Overview of Excel B: Navigate in Excel C: Select Data D: Enter Data E: Save a Workbook F: Obtain Help
Lesson 2: Modifying a Worksheet A: Move and Copy Data Between Cells B: Fill Cells with Series of Data C: Edit Cell Data D: Insert and Delete Cells, Columns, and Rows E: Find, Replace, and Go To Cell Data F: Spell Check a Worksheet
Lesson 3: Performing Calculations A: Create Basic Formulas B: Calculate with Functions C: Copy Formulas and Functions D: Create an Absolute Reference
Lesson 4: Formatting a Worksheet A: Change Font Size and Type B: Add Borders and Color to Cells C: Change Column Width and Row Height D: Merge Cells E: Apply Number Formats F: Create a Custom Number Format G: Align Cell Contents H: Find and Replace Formats I: Apply an AutoFormat J: Apply Styles
Lesson 5: Developing a Workbook A: Format Worksheet Tabs B: Reposition Worksheets in a Workbook C: Insert and Delete Worksheets D: Copy and Paste Worksheets E: Copy a Workbook
Lesson 6: Printing Workbook Contents A: Set a Print Title B: Create a Header and a Footer C: Set Page Margins D: Change Page Orientation E: Insert and Remove Page Breaks F: Print a Range
Lesson 7: Customizing Layout A: Split a Worksheet B: Arrange Worksheets C: Freeze and Unfreeze Rows and Columns D: Hide and Unhide Worksheets |
|
Location : Norton, MA |
Back
|