Home \ Workshops \ Computer Classes \ Excel 2003 Intermediate

Excel 2003 Intermediate

Excel 2003 Intermediate

Course Objectives

Through this training course you will be taught a variety of skills that will allow you to develop a greater understanding of many of the intermediate features found in Microsoft Excel. Below is a summary of skills that will be explored.

Time

2-4 Hours

Instructional Method

Instructor lead, hands-on course

Prerequisites

  • Excel 2003 Basic
  • This course assumes that you have a basic understanding of Microsoft Excel and are comfortable with the following functions:
    • 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

Who Should Attend?

This program is for anyone that is currently using Excel and wishes to improve their understanding of Excel and is looking for formal instruction to improve their techniques and understanding.

Course Content Overview

  • Organizing Data
  • Sorting and Filtering Data
  • Analyzing Data
  • Formulas
  • Advanced Data Analyzing
  • Formulae with Multiple Worksheets
  • Formatting and Presenting Your Data

Workbook Layout

Section One: Organizing Data

  • Importing Data
  • Formatting Rows or Columns
  • Formatting Cells
  • Numbers
  • Alignment
  • Fonts
  • Borders

Section Two: Sorting and Filtering Data

  • Sorting Data
  • Filtering Data

Section Three: Analyzing Data I

  • Averages
  • Charts

Section Four: Formulas

  • Standard Deviation

Section Five: Analyzing Data II

  • Charting With Multiple Worksheets

Section Six: Formulae with Multiple Worksheets

Section Seven: Formatting and Presenting Your Data

  • Breaking up the window
  • Integrating with other Office applications
  • Exporting data
  • Printing
  • Page Setup
  • Headers and Footers
  • Other Printing Options

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