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