Training Classes Learn How To

COURSE SEARCH

HOME > COURSES > MICROSOFT EXCEL 97 ADVANCED

MEMBERS LOGIN

UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW

HOME

COURSE LIBRARY

QUESTIONS & ANSWERS

There are many excellent online courses. This has been hugely beneficial in my day to day work.

- Louise Nolan

MORE INFO

Microsoft Excel 97 Advanced

Course Aims
This training course aims to give experienced users of Excel 97 knowledge of some of the more advanced commands and functions and how to apply them to solving their own business problems. Workshop based, the course will provide the readers with an opportunity to explore individual interests within the framework of a structured course.

Assumed Knowledge
A thorough working knowledge of Excel 97 gained from prior attendance on an "MS Excel 97 Introduction" course or from a user environment.

Course Audience
Existing users of MS Excel 97 who wish to explore the more sophisticated features of this package.

This course can be found in the following categories:

Courses > Microsoft > Office 97
Courses > Microsoft > Excel

Table of Contents

Introduction

Advanced Spreadsheet Functions and Features

Year 2000

Customizing Excel

Customising Toolbars and Menus

Templates and Views

Creating Workbook Templates

Custom Templates

Default Templates

Storing Templates

Creating Custom Views

Saving the Excel Workspace

Formatting Excel

Formatting Numbers

Using Custom Formats

Custom Number Format Sections

Custom Number Format Codes

Custom Date Format Codes

Formatting SpeedKeys

Using Conditional Formats

Using Styles

Hiding Data

Functions

Conditional Formulae (IF, AND and OR)

Function Dialogue Box

Lookup and Reference Functions

Using the LOOKUP Function

Using the VLOOKUP Function

Using the HLOOKUP Function

Preventing LOOKUP Errors

Conditional Statistical Functions

Manipulating Text with String Functions

Date and Time Functions

Problem Solving

Goal Seeking

Using Solver

The Scenario Manager

Scenario Summaries

Merging Scenarios

Additional Features

Using Named Ranges

Using Paste Special

Object Linking and Embedding

Applying Worksheet Protection

Password Protecting a File

Worksheet Auditing

Adding Comments to the Worksheet

Using Worksheet Auditing Tools

Data Entry Validation

Validating the Whole Worksheet

Auditing Data Dependency

Finding and Replacing Data

Advanced Charting Facilities

Using Custom Chart Templates

Adding and Deleting Chart Data

Changing Chart Values

Creating Projections with Trendlines

Creating Combination Charts

Creating Data Map Charts

Adding Graphics

Using the Drawing Tools

Inserting WordArt

Inserting Clip Art

Data Management

Searching for Data with Advanced Filters

Compiling Consolidations

Summarising Data with Outlines

Analysing Data with PivotTables

Creating a PivotTable

Modifying a PivotTable

Using Macros

Understanding Macros

Recording a Basic Macro

Running a Macro

Macro Virus Protection

Year 2000 Best Practices

Year 2000 Best Practices

TRY BEFORE YOU BUY

BECOME A RESELLER

TERMS & PRIVACY

Tuesday 22nd May 2012