COURSE SEARCH
 
   HOME > COURSE > MICROSOFT EXCEL 2000 LEVEL 1; INTRODUCTION 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 1; Introduction



Course Aims
Readers will learn the basics of a spreadsheet application and will be able to create and modify calculating spreadsheets using Excel 2000.
Assumed Knowledge
No prior experience of Excel is expected. Although reader with limited experience on other spreadsheet applications will find it comfortable. A working knowledge of the windows operating system and use of the mouse and keyboard is essential.
Course Audience
People who are required to know how to create spreadsheets or work on existing Excel spreadsheets, using formatting and calculation tools.

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

Table of Contents
Introduction to Excel 2000
  		• What is an Electronic Spreadsheet?
  		• Spreadsheet Terminology
  		• The Excel Window and Screen
  		• The Working Window
  		• Using the Mouse and Keyboard
  		• Moving Around the Sheet
  		• Exercise; Create A Simple Spreadsheet
  		• Exercise; Add Data
  		• Selecting Cells and Ranges
  		• Exercise; Create a New Workbook
  		• File Management
  		• Getting Help
  		• Summary of the Movement Keys
  		• 'Personalized' menus and toolbars in Excel 2000
  		• Create shortcuts and Customise toolbars in Excel 2000
  		• Opening and saving your Office files
     
    Creating a Worksheet
  		• The Excel Menus
  		• Entering Data
  		• Undo and Redo
  		• Formulae
  		• Introduction to the AutoFill Feature
  		• Copying Cells
  		• Copying Formulae
  		• Adding to a Worksheet
  		• The Sum Function
  		• Exercise; Create another Spreadsheet
    Formatting a Worksheet
  		• Setting Column Widths
  		• The Formatting Commands
  		• Aligning Cell Contents
  		• Changing Fonts and Attributes
  		• Inserting and Deleting Rows and Columns
  		• Example; Adding and Centring a Title
  		• Adding Borders and Shading
  		• Number Formatting
  		• Using the Format Painter
  		• The Microsoft Office 2000 Drawing Features
  		• Using the AutoFormat Command
  		• Exercise
     
    Print a Worksheet
  		• Preview a Worksheet
  		• Headers and Footers
  		• Page Breaks
  		• Printing and Print Areas
  		• Aligning the Printout
  		• Print Row and Column Headings and Gridlines
  		• Defining Row and Column Titles
  		• Example, Setting up Print Titles; Using the file Company.xls
  		• Print a Selection
  		• Year 2000 Issues
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Thursday 9th February 2012  © COPYRIGHT 2012 - website design by Website Design by Visualsoft