COURSE SEARCH
 
   HOME > COURSES > MICROSOFT EXCEL 2000 LEVEL 2; INTERMEDIATE 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 2; Intermediate




Course Aims
Readers will build on basic knowledge of a spreadsheet application or the fundamentals and move on to more complex formulae and other more advanced Excel 2000 features.
Assumed Knowledge
Readers should have completed our "Microsoft Excel 2000 Level 1; Introduction" course or be familiar with creating and working on Excel spreadsheet files.
Course Audience
People who need to use Excel 2000 regularly to present attractive spreadsheets and perform tasks above the introductory level.

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

Table of Contents
Absolute Addresses and Worksheet Protection
  		• Compatibility between v97 and v2000
  		• The AutoFill Feature; The 5-minute spreadsheet
  		• Freezing Panes
  		• Special AutoFill Features
  		• Worksheet and Workbook Protection
  		• Partial Protection
  		• Allow restricted modification
  		• Selecting Multiple Ranges of cells
     
    Worksheet Functions
  		• Worksheet Functions
  		• The Function Wizard
  		• The Formula Palette
  		• Function Syntax
  		• Mathematical Functions
  		• Date Functions
  		• Statistical Functions
  		• Logical Functions
  		• Range Names
  		• Exercise; Using the file Personal Finance
  		• Naming Worksheets
     
    Creating and Editing Charts
  		• The Chart Facility
  		• The Excel Chart Range
  		• The Chart Wizard
  		• Example; Create a Chart
  		• Changing the Chart Type
  		• Print a Chart
  		• Adding a Trendline
  		• Exercise; formatting a trendline
    Multiple File Linking
  		• The Workbook Concept
  		• File Linking
  		• Scrolling Through Sheet Tabs
  		• Inserting & Deleting Sheets
  		• Arranging Multiple Workbook Windows
  		• Multiple Worksheet Views
  		• Applying Split Bars
  		• Example; Opening one sheet in four panes using Split Bars
  		• Creating a Workspace
  		• Working with Data across Worksheets
  		• 3-D Formulae
  		• Exercise; Linking Workbooks
  		• Exercise continued; 4 - Copying Data across Worksheets
  		• Exercise continued; 5 - Creating a 3-D Formulae
  		• Exercise continued; 6 - Linking Sheets in a Workbook
  		• Exercise continued; 7 - Linking Files (workbooks)
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Sunday 20th May 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft