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