Excel 97, MOUS, CD-ROM Training, Certification Edition

Order #: 0523A -- Package Price: $ 229

How many can we ship you today?
Call Toll Free (866) 940-3669 Fax Toll Free (888) 356-9963
Email WiseNow Media or for Free Brochure click here

This title is also available in a -- Newer Version -- Alternate Format

 

Meet Reed Jacobson , Your Instructor for This Course:

Reed Jacobson is an independent consultant specializing in creative training, consulting, and custom development services. He worked as a programmer for Hewlett-Packard for ten years before becoming a consultant, specializing in Microsoft Excel, Visual Basic, and other Microsoft office products. He is also an internationally best-selling author and has spoken at numerous conferences around the world.

 

 Excel 97 MOUS Edition w/Exam Book Beginning CD

  • Introduction and Explanation
  • Ways to Use Spreadsheets
  • Entering Text and Numbers
  • Adding Numbers in Cells
  • Subtraction
  • Combining Words
  • List vs. Grid
  • Office Assistant
  • Tool Touch, Contents, Index and Find
  • Cell and Range
  • Moving a Cell or Range
  • Insert and Delete
  • Add, Delete and Naming Worksheets
  • Viewing Multiple Worksheets
  • Selecting Multiple Sheets and Making Changes to All
  • Rearrange Worksheets
  • Save, Open and Create Workbooks
  • Renaming Workbooks
  • Default File Location and Changing Default
  • Formatting Currency
  • Formatting Dates and Sizing Cells
  • Formatting Numbers and Labels
  • Copying Format to Another Cell
  • Using Auto Format and Borders
  • Underline and Creating Gaps Between Cells
  • Centering over Multiple Cells
  • Merge Cell Feature and
  • Vertical Text
  • Sales Tax
  • Loan Payment
  • Adding Comments to Worksheet
  • Spell Checking
  • Color Coding Formula
  • Changing a Formula for Different Cells
  • Undo and Redo Feature
  • Calculate a Formula In Reverse
  • Print Preview and Command
  • Headers and Footers
  • Selecting Author of Workbook
  • Printing Part of Worksheet - Page-Break Preview
  • Repeating Rows and Columns for Printing and Viewing - Freeze Panes
  • Creating w/Chart Wizard
  • Changing Existing Chart
  • Printing Charts

    •  Excel 97 MOUS Edition w/Exam Book Intermediate CD

  • Keyboard Shortcuts
  • Efficient Mouse Use
  • Customize a Toolbar
  • Hide Rows and Columns
  • Custom Views
  • Options
  • Make a Cell Pointer That Adjusts Columns or Rows Only
  • Work With Formulas as a Block
  • Keeping Formula Block the Same
  • "Running Total" Formula
  • Calculate a Growth Rate
  • Using Labels
  • Name vs. Label
  • Redefine Names
  • Create a List
  • Making Specific Random Numbers
  • Round Numbers to the Nearest 5
  • Discount Percent
  • Lookup Product Name
  • Lookup State
  • Make Her Appear Only When it Changes
  • Assign One Field to Another
  • Show Only Specific Rows
  • Subtotal
  • Get Unique List
  • Date Format
  • Number of a Month
  • First Day of a Month

    •  Excel 97 MOUS Edition w/Exam Book Advanced CD

  • Custom Charts
  • Mixing Big and Little Numbers
  • Cause and Effect Charts
  • Protecting Worksheet
  • Limit Values That Can Go Into the Spreadsheet
  • Point Out Unusual Values
  • Link to a Cell Outside Your Workbook
  • Importing Multiple Cells
  • Fix a Broken Link
  • Edit Multiple Copies of a Workbook
  • Save Changes When Working with Multiple Copies of a Workbook
  • Conflict Manager
  • Prepare Data
  • Create a Pivot Table
  • Determine Which Areas Have Totals
  • Group Dates
  • Make a Pivot Table
  • Retrieve Part of a Database
  • Switch Retrieved Portion
  • Make Somebody Jump to Another Worksheet
  • Jump to a Word Document
  • Jump to a Web Page
  • Web Toolbar
  • Turn a Worksheet into a Web Page
  • Nature of the Controls
  • Two-Column Box List
  • Create a Macro
  • Edit a Macro
  • Enhance a Macro
  • "With" in a Macro
  • Toggle Macro
  • Simplify Running the Macro
  • Run a Macro From a Toolbar
  • Run a Macro From a Worksheet

    •  Excel 97 MOUS Edition w/Exam Book MOUS CD

  • Introduction
  • Format Parts of a Chart
  • Format with Style
  • Variations on a Save
  • Retrieve an Outline
  • Show Data on a Map ð Create Graphical Objects
  • Customize Number Formats
  • Create Complex Formulas
  • Create an Outline
  • Distribute a Workbook
  • Audit Worksheet Formulas

    •  Excel 97 MOUS Edition w/Exam Book MOUS Book

  • Create Workbooks
  • Modify Workbooks
  • Print Workbooks
  • Format Worksheets and Tables
  • Create and Apply Ranges
  • Use Functions
  • Use Database Function
  • Use Charts
  • Format Worksheets
  • Print Workbooks
  • Audit a Worksheet
  • Use Database Function
  • Use Macros
  • Import and Export Data
  • Use Templates
  • Use Multiple Workbooks
  • Use Workgroups Functions

    • Still looking for training?
    Call us (866) 940-3669 or search the web using
    Northern Light Search
    line line
    Search for:
      Tips

    Home Page
    		 Wise Now Logo
    WiseNow Media,
    410 Main Street
    Longmont, CO 80501
    Email us at info@WiseNow.com
    Toll Free Phone (866) 940-3669
    Toll Free Fax: (888) 356-9963
    Copyright 2000, WiseNow Media, All Rights Reserved.