Perpetual Solutions
Tuition House
27-37 St Georges Road, London
SW19 4DS

+44 (0)20 7620 0033
+44 (0)20 7620 0055

Training Course Outline

IT Vendor Courses User ECDL Training Courses

Excel 97 Advanced

Course Duration: 2 Days

Course Code: EXMA97

Course Description:

This course is designed for experienced users of Excel 97 who have attended the Introductory course or who have equivalent knowledge, including the ability to create and format worksheets, and confidently create formulae

Prerequisites:

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

This course includes the following modules:

Topics Covered

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

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print Print this course