Microsoft Excel 2003 - Level 1

This course is designed for new Excel users who require the skills necessary to set up a spreadsheet and use basic business spreadsheet functions. Students will become familiar with Excels command menus, filing workbooks, and basic editing tools.

Course Outline

This course is designed for new Excel users who require the skills necessary to set up a spreadsheet and use basic business spreadsheet functions. Students will become familiar with Excels command menus, filing workbooks, and basic editing tools. The course will also show students how to create simple formulas, use built in functions as well as an introduction to relative and absolute references. Participants will learn to manipulate windows for better viewing as well as work with cut/copy/paste features to move data, format their worksheet and prepare headers and footers for printing.

Course Content

Getting Started

• Starting Microsoft Excel 2003
• The Excel 2003 Window
• Excel Toolbars
• Excel Menus
• The Help Menu
• The Help Task Pane
• The Office Assistant

Managing Workbooks

• Creating a Blank Workbook
• Opening an Existing Workbook
• Saving Workbooks

Excel Data

• Types of Data
• Entering Data
• Moving around in Excel
• Changing Column Size
• Selecting Cells
• Entering Data in a Range
• Range
• AutoFill
• AutoComplete
• Replicating Data upon Entry

Editing in Excel

• Edit Mode
• Cut and Paste
• Copy and Paste
• Moving Cells by Dragging and Dropping
• Copying Cells by Dragging and Dropping
• Undo and Redo
• Inserting Cells
• Deleting Content of Cells
• Inserting Rows and Columns
• Deleting Rows and Columns
• Go To Feature
• Spell Checking

Excel Formulas

• Creating Formulas
• Relative and Absolute References
• Circular Reference
• Sum and Average Formulas
• AutoSum and Other Automatic Functions

Formatting in Excel

• Formatting Cells
• Numbers
• Fonts
• Alignment
• Borders
• Patterns/Colour

Window Manipulation

• Zoom
• Freeze and Unfreeze Panes
• Split Panes

Printing in Excel

• Page Setup
• Page Setup – Page Tab
• Page Setup – Margin Tab
• Page Setup – Sheet Tab
• Page Setup – Headers and Footers
• Print Preview
• Print

Excel Options

• Customize

Additional Details

Pre-Requisites

Basic computer concepts/skills and knowledge of Windows

Certificates offered

Certificate of completion

Cancellation Policy

10 business days cancellation or full course fee will be charged

Map & Reviews

Technology Training Centre
[ View Provider's Profile ]

Reviews

 

   

With myself being very green with this program I got very useful information that I can use daily.

Reviewed by Rick . 2011