COURSE SEARCH
 
   HOME > COURSES > MICROSOFT EXCEL 2000 LEVEL 3; 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 2000 Level 3; Advanced




Course Aims
Readers will learn advanced Excel 2000 features allowing them to manage databases and manipulate stored data. Completing this level will be enough to use Excel 2000 as an efficient flat file database.
Assumed Knowledge
Readers should have completed our "Microsoft Excel 2000 Level 2; Intermediate" course or be competent Excel users regularly using complex functions and formulae.
Course Audience
Competent Excel users who are facing difficulties in some of their spreadsheet aspirations and who want to create databases.

This course can be found in the following categories:
Courses > Microsoft > Office 2000
Courses > Microsoft > Excel
Courses > MOS

Table of Contents
Introduction to Database Lists
  		• The Concepts of a Database
  		• Excel’s Database List Structure
  		• Example; Create a Database or List
  		• Using the Data Form
  		• Sorting Records
  		• Delete Records
  		• Finding Records
     
    Auto Filter and Statistical Functions
  		• Data Extraction
  		• The Advanced Filter
  		• Using the Top 10 Feature
  		• Copying Filtered Data to Another Location
  		• Statistical Functions
  		• Combining Extraction with Statistics
     
    Lookup and Input Table
  		• The Lookup Function
  		• The One Input Table
  		• The Two Input Table
  		• Lookup Exercise
    Customising and Array Formulas
  		• Custom Lists
  		• Customising AutoFill
  		• Exercise; Building Custom Number Formats
  		• Array Formulas
  		• User defined Functions
  		• Globally Available User-Defined Functions
  		• The Excel Macro Recorder
  		• Exercise 1: Recording a Macro
  		• Exercise 2: Running a Macro
     
    Pivot Tables
  		• Pivot Tables
  		• Pivot Tables and Pivot Charts
  		• Pivot Table Examples
     
    Scenarios and Goal Seek
  		• Overview of Using Scenario Manager
  		• Scenarios Command
  		• Using Goal Seek
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Sunday 20th May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft