Warning: Declaration of ET_Theme_Builder_Woocommerce_Product_Variable_Placeholder::get_available_variations() should be compatible with WC_Product_Variable::get_available_variations($return = 'array') in /home/customer/www/cheltenhamcourseware.com/public_html/wp-content/themes/Divi/includes/builder/frontend-builder/theme-builder/WoocommerceProductVariablePlaceholder.php on line 8
Microsoft Excel 2003 Intermediate courseware for IT Trainers

Excel 2003 Intermediate Courseware

Microsoft Excel 2003 Intermediate Training Materials

Intermediate Level 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