Excel 97 - Day 3

 Organizational Tools

Who Should Attend This Course

Users who have completed our Excel 97 Level 1 2 and 3

 Course Length: one day

 

Course Topics
  1. Using Styles and Custom Formats

Using, applying, creating, modifying, and merging styles; creating a style by example; creating a custom format

 
  • Using Templates
    		•

    Working with, saving, using, and editing templates; inserting new worksheets; creating default templates

     
  • Consolidating Worksheets
    		•

    Consolidate worksheets by category and by position

     
  • Working with Comments
    		•

    Creating, viewing, editing, showing, hiding, deleting, and printing comments; viewing all comments; using the Reviewing toolbar

     
  • Using Auditing Tools
    		•

    Displaying the Auditing toolbar; displaying and removing dependents and precedents; removing tracer arrows; tracing errors

     
  • Working with Views
    		•

    Using views, creating normal and custom views, displaying and deleting views

     
  • Using the Report Manager
    		•

    Use the Report Manager and worksheets in a report, printing and creating a report, using a scenario and a view in a report, reordering report sections

     
  • Sharing Workbooks

    • Using shared workbooks; saving a shared workbook, viewing users and changes, displaying comment boxes, changing the update frequency, highlighting changes, managing and resolving conflicting changes, setting change history options, creating the History worksheet, reviewing tracked changes, merging shared workbook files

     

    Advanced Charting

     Course Topics
    1. Modifying Charts

    Creating, applying, and deleting user-defined charts; changing the data source; editing text/axis titles; adding unlinked text; removing/adding axes labels; using and disabling the time-scale axis; using the chart Range Finder; moving a legend; adding data labels and tables

     
  • Working with Chart Data Series
    		•

    Adding and deleting a data series, adding data series/multiple worksheets, editing data series names, changing data series types, adding a trend line, charting non-adjacent ranges

     
  • Formatting Charts
    		•

    Changing patterns, colors, the plotting order, and the axis scaling; creating borders and picture graphs; formatting axes and data markers; adjusting 3-D chart views; scaling a picture graph

     
  • Working with Advanced Graphics
    		•

    Inserting a graphics image; drawing a filled rectangle; changing the graph layering, fill color, and pattern color; adding a pattern; grouping and ungrouping objects

     
  • Working with the Data Map
    		•

    Using the Data Map; organize the map worksheet; creating a basic map; changing the map format type; inserting data into a map; editing a map title and legend

     
  • Modifying Maps

    • Creating a pie map; deleting chart formats; removing and adding map features; adding text to a map; magnifying, moving, and reducing the map; changing pie chart colors; using push-pins and map labels; refreshing the map; printing the Data Map

     

    Return to Table of Contents