Excel 2003 Intermediate Courseware Materials

Microsoft Excel 2003 Intermediate Training Materials for IT Trainers

Intermediate Level Computer Training Materials

Courseware Training Manual

1. VIEWING WORKSHEETS

CUSTOMIZING VIEW OPTIONS

  • Customizing the Excel window display
  • Customizing the Comments View options
  • Customizing the Objects View options
  • Customizing the Worksheet View options

DISPLAYING AND CUSTOMIZING TOOLBARS

  • Choosing a Toolbar
  • Displaying Toolbars
  • Customizing Toolbar Options
  • Adding Commands to a Toolbar

HIDING WORKBOOKS AND WORKSHEETS

  • Hiding a Workbook
  • Hiding Worksheets
  • Displaying hidden Workbooks
  • Displaying hidden Worksheets

FREEZING PANES

  • Freezing a horizontal pane
  • Freezing a vertical pane
  • Freezing horizontal and vertical panes
  • Unfreezing panes

GROUPING AND UNGROUPING WORKSHEETS

  • Grouping Worksheets
  • To select all Worksheets
  • To select several Worksheets
  • Ungrouping Worksheets

2. MORE FORMATTING TECHNIQUES

USING STYLES

  • Creating a new style
  • Applying a style
  • Changing the formatting of a style
  • Removing a style from cells
  • Deleting a style

CONDITIONAL FORMATTING

  • Using conditional formatting
  • Changing conditional formatting
  • Deleting conditional formatting
  • Finding cells with conditional formatting

USING THE FORMAT PAINTER

  • Copying and applying cell formatting with the Format Painter
  • Copying and applying column width or row height with the Format Painter
  • Copying and applying cell formatting with the Format Painter
  • Copying and applying the Format Painter in multiple locations

USING GUIDELINES

  • Changing the color of the Gridlines
  • Turning off the onscreen Gridlines
  • Printing Gridlines

HIDING AND DISPLAYING CELLS

  • Hiding Columns
  • Hiding Rows
  • Using the mouse to hide Columns
  • Using the mouse to hide Rows
  • Displaying hidden Columns
  • Displaying hidden Rows
  • Using the mouse to display hidden Columns
  • Using the mouse to display hidden Rows

3. MORE FORMULAS AND FUNCTIONS

USING THE SERIES COMMAND

  • Using the Series Command
  • Applying a list series
  • Applying a numeric series
  • Applying a basic numeric series
  • Creating a custom list series

USING THE INSERT FUNCTION WIZARD

  • Displaying the Insert Function wizard
  • Choosing a function from the Insert Function wizard
  • Entering Function Arguments in the Insert Function wizard

USING THE EXCEL FUNCTION CATEGORIES

  • Using the Most Recently Used function category
  • Using the Financial function category
  • Using the Date & Time function category
  • Using the Math & Trig function category
  • Using the Statistical function category
  • Using the Lookup & Reference function category
  • Using the Database function category
  • Using the Text function category
  • Using the Logical function category
  • Using the Information function category

CORRECTING FORMULAS

  • Finding and correcting errors in Formulas
  • Finding error values
  • Correcting error values

USING THE FORMULA ERROR CHECKER

  • Using the Formula error checker
  • Rechecking ignored errors
  • Customizing the Formula error checker

USING THE FORMULA AUDITING TOOLBAR

  • Displaying the Formula Auditing toolbar
  • Using the Formula Auditing toolbar
  • Tracing Precedents
  • Removing Precedent Arrows
  • Tracing Dependents
  • Removing Dependent Arrows
  • Adding a new comment
  • Evaluating Formulas one step at a time

USING THE WATCH WINDOW

  • Using the Watch Window
  • Adding a Watch to a cell
  • Adding a Watch to all the cells with Formulas
  • Displaying a cell in the Watch Window
  • Deleting a Watch
  • Hiding the Watch Window

4. DATABASE AND LIST MANAGEMENT

USING DATABASES

  • Using the Excel database features
  • Using database terminology

CREATING AND EDITING A DATABASE

  • Creating an Excel database
  • Working with an Excel database

SORTING A DATABASE

  • Sorting data within a database
  • Adding other sorting criteria

USING AUTOFILTERS

  • Filtering data
  • Filtering data with AutoFilter
  • Specifying a conditional filter with AutoFilter
  • Using the Top 10 AutoFilter
  • Removing all AutoFilters

USING ADVANCED FILTERS

  • Using Advance Filters
  • Removing all Advanced Filters

WORKING WITH FILTERED DATA

  • Manipulating Filtered Data
  • Totaling fields within a filtered database list
  • Creating Subtotals
  • Remove Subtotals

USING DATA FORMS

  • Using a Data Form
  • Adding a new record
  • Moving between records
  • Finding records
  • Editing a record
  • Deleting a record
  • Closing a Data Form

5. CHARTS

USING THE CHART WIZARD

  • Using the Chart Wizard
  • Selecting the Chart Type
  • Specifying the Data Source
  • Customizing the Chart
  • Defining the Chart Location

USING THE CHART TOOLBAR

  • Displaying the Chart toolbar
  • Using the Chart toolbar
  • Selecting a Chart
  • Selecting Chart objects

WORKING WITH CHARTS

  • Changing the Chart Type
  • Adding data to a Chart
  • Removing data from a Chart
  • Moving a Chart
  • Resizing a Chart
  • Deleting a Chart

FORMATTING THE CHART

  • Formatting the Chart Area
  • Formatting the Chart Title
  • Formatting the Plot Area
  • Formatting the Axis
  • Formatting the Axis Title
  • Formatting the Legend
  • Formatting the Gridlines
  • Formatting the Data Series

6. DRAWING AND PICTURE OBJECTS

USING THE DRAWING TOOLBAR

  • Displaying the Drawing toolbar
  • Using the Drawing toolbar

WORKING WITH AUTOSHAPES

  • Inserting an AutoShape object
  • Drawing common objects
  • Formatting AutoShape objects
  • Selecting an object
  • Changing the look of AutoShape lines
  • Changing the look of AutoShape arrows
  • Adding a shadow
  • Applying the 3-D option
  • Moving an object
  • Copying objects
  • Resizing an object

CREATING TEXT BOXES

  • Creating a text box
  • Editing text in a text box
  • Resizing a text box
  • Deleting a text box

ADDING PICTURES

  • Inserting Clip Art
  • Inserting a picture
  • Using the Picture toolbar
  • Moving a clip art or picture
  • Copying a clip art or picture
  • Resizing an object

LAYERING OBJECTS

  • Layering objects

GROUPING AND UNGROUPING OBJECTS

  • Grouping objects
  • Ungrouping objects

7. EXCEL 2003 AND OTHER APPLICATIONS

  • CONVERTING FILES FROM OTHER APPLICATIONS
  • Converting spreadsheets from other applications

COPYING DATA FROM ANOTHER APPLICATION

  • Using the Office Clipboard
  • Using Paste Special
  • Using Paste Special with content from Excel
  • Using Paste Special with content from other application
  • Changing data to graphic objects

EMBEDDING AND LINKING OBJECTS

  • Embedding data
  • Embedding an existing document
  • Linking data
  • Creating a link to an existing file
  • Linking data from Microsoft Word

USING HYPERLINKS

  • Using Hyperlinks
  • Creating a Hyperlink

MANAGING LINKS

  • Updating Links
  • Editing Links
  • Checking the status of a Link
  • Breaking Links

 

Excel 2003 Intermediate Courseware Materials
5 (100%) 1 vote