Microsoft Excel 97 Intermediate: Databases, Macros, and Styles

Overview/Description
This course, Microsoft Excel 97 Intermediate: Databases, Macros, and Styles, discusses intermediate techniques such as creating and modifying a database, manipulating data within a database, and creating and running macros.

Target Audience
This course requires that you have a working knowledge of basic Excel operations.

Expected Duration
This course, including the practice exercises, will take up to 4 hours to complete.

Objectives:

Creating a Database

  • Create a database
  • Edit database records
  • Locate records
  • Sort database records

    • Working with a Database

  • Filter a database
  • Manipulate a database
  • Perform calculations in a database
  • Create a pivot table
  • Query an external database
  • Import and export files

    • Creating Macros and Styles

  • Record and run a macro
  • Delete a macro
  • Create a macro using relative referencing
  • Assign a macro to a toolbar button
  • Creating and Using Styles


    • Course Number: MOFF0014