Email:

edcenter@computersup.com

Address:

Computer Support

860 South 5th Ave

Clarion, PA 16214

Page best viewed with Internet Explorer 4.0 or higher and 1024x768 or higher screen resolution.

 

Intermediate Microsoft Excel

Day or Evening Class

 

Overview

Students will learn extensive charting and graphing techniques. Topics covered included creating and modifying charts, drawing objects, using AutoShapes, working with the Data Map and import/export data

 

Prerequisite

Students should have successfully completed the Introduction to Microsoft Excel class or possess equivalent knowledge.

 

Outline

            1. Creating Charts

      1. Types of charts

      2. Legends

      3. Move and resize

            2. Editing Charts

      1. Changing chart type

      2. Changing data source

      3. Printing a chart sheet

      4. Gridlines

      5. Format and changing axis

            3. Drawing an Object

      1. Drawing objects

      2. Adding text

      3. Additional effects and objects

            4. AutoShapes

 

            5. Data Map

      A. Using and organizing data map

            6. Import and Export Data

      1. Import data

            7. Data Series

      1. Using the Series Command

            8. Using Data Tables

      1. Using Data Tables

      2. Placing formulas in Data Tables

            8. Customizing Excel Preferences

      1. View Options

      2. Excel Preferences

            9. Logical and Financial Functions

                  A. If, Not, And, Or, Pmt