COURSE SEARCH
 
   HOME > COURSE > 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     CONTACT US
There are many excellent online courses. This has been hugely beneficial in my day to day work.
- Louise Nolan


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:
Course Library > Microsoft > Office 97
Course Library > 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
    Thursday 9th February 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft