Excel 2003 Beginner

Course Objectives

Through this training course you will be taught a variety of skills that will allow you to create basic Microsoft Excel documents and to add some formatting to make them more appealing. Below is a summary of skills that will be explored.

Time

2-4 Hours

Instructional Method

Instructor lead, hands-on course

Prerequisites

• Word 2003 Basic
• This course assumes that you have a basic understanding of Microsoft Word and are comfortable with the following functions:
  • Familiarity with the keyboard
  • Move the mouse
  • Clicking and selecting
  • Creating a New Document
  • Highlighting and Aligning Text
  • Bold, Italics and Underline Features
  • Manipulating Fonts
  • Undo and Redo Options
  • Copy and Paste Functions
  • Borders and Shading, Bullets and Numbering
  • Saving a Document and Document Copy

Who Should Attend?

Anyone that is going to be using Excel, new to Excel or wishes to improve their basic understanding of Excel and are looking for formal instruction to improve their techniques and understanding.

Course Content Overview

• Microsoft Excel Layout
• Understanding the Toolbars
• Creating a Workbook
• Entering and Moving Data
• Naming and Saving Worksheets
• Bold, Italics, and Underline Features
• Cell Alignment
• Using Shading and Border Options
• Understanding the Format Painter
• Selecting a range
• Moving and sorting data
• Copying and Pasting
• Undo button to remove mistakes
• Working with Columns and Rows
• Recalling and Saving Workbooks
• Naming worksheets
• Print setup, print preview and printing
• Headers and footers
• Understanding Formulas
• Inserting Charts and Graphs

Workbook Layout

Lesson 1: Understanding Microsoft Excel

• Exploring the Layout
  • The Title Bar
  • The Menu Bar
  • The Standard Toolbar
  • The Formatting Toolbar
  • Choosing Your Toolbars
• Identifying the Components of a Workbook
  • Knowing the Names
  • The Formula Bar

Lesson 2: Entering Data into the Worksheet

• Working with Data
  • Entering Data
  • Moving Through Each Cell
  • Page down and Page up
  • The ‘Enter’ and ‘Cancel’ Buttons
  • Saving Your Workbook
  • Closing a file

Lesson 3: Opening and Coping Workbooks

• Opening and Coping Workbooks
  • Opening an New Workbook
  • Opening an Existing Workbook
  • Recalling Recently Used Workbooks
  • Saving a Workbook Copy

Lesson 4: Working with Your Spreadsheet

• Formatting your Cells
  • Selecting a range of cells
  • Bold, Italics, and Underline Features
  • Playing with Fonts
  • Aligning Your Text
• Formatting your Cells
  • Shading Your Cells
  • Adding Borders
  • Using Format Painter

Lesson 5: Microsoft Excel Features

• Moving Data
  • Copy and Paste Functions
  • Undo and Redo Options
  • Sorting Data within a Column

Lesson 6: Manipulating Your Spreadsheet

• Customizing Your Worksheet
  • Naming Your Spreadsheet
  • Adding or Deleting a Worksheet
  • Adding and Deleting Columns to a Spreadsheet
• Modifying Rows and Columns
  • Adding and Deleting Rows to a Spreadsheet
  • Adjusting Column Widths
  • Adding a Cell
  • Removing a cell

Lesson 7: Printing Your Spreadsheet

• Preprinting Settings and Preferences
  • Setting Your Page Layout Preferences
  • Page tab
  • Margin tab
  • Header/Footer tab
  • Sheet tab
• Printing Options
• Spell check
• Using Print Preview
• Printing a Spreadsheet or Workbook

Lesson 8: Understanding Formulas

• Inserting Formulas
  • The Sum Function
  • The AutoSum Icon

Lesson 9: Charts and Graphs

• Creating a Chart

To schedule this class:
Email Yona or call 815-437-9089