Excel 97 Advanced

2 Day Course
Code EXMA97

This course has been retired. Please view currently available User ECDL Training Courses.

Modules

Topics Covered (50 topics)

  • Conditional Logic
  • Nested Formulae
  • Multiple Conditions
  • Lookup Tables
  • Creating Lookup Tables
  • Lookup Formulae
  • Manipulating Information
  • String Functions
  • IS Functions
  • Data Validation
  • Formatting Numbers
  • Creating Number Formats
  • Applying Conditional Formats
  • Outlining
  • Creating Outlines Automatically and Manually
  • Changing the Organisation of an Outline
  • Using Styles in an Outline
  • Consolidation
  • Spreadsheet Consolidation
  • Working with Lists
  • Using the Data Form
  • Sorting a List
  • Summarising Data in a List
  • Working with a Database
  • Using a List as a Database
  • AutoFilter
  • Filter Criteria
  • Database Statistics
  • Using the Template Wizard
  • Pivot Tables
  • Creating a Pivot Table
  • Updating a Pivot Table
  • Adding and Removing Fields
  • Pivot Table Layouts
  • Using Totals
  • Grouping Items
  • Using Analysis Tools
  • Goal Seek
  • Data Tables
  • Scenario Manager
  • Custom Views
  • Printing Reports
  • Solver
  • Displaying Data in a Map
  • Auditing
  • Macros
  • Recording and Running Macros
  • Assigning Macros to Menus, Toolbars and Buttons
  • Macro Virus Checking

Prerequisites

Users new to or relatively inexperienced in using Excel 97 should attend Excel Introductory Level prior to this course.

or call:408-759-5074

Course PDF

Print

Sections