Microsoft Excel 2000 foundation courseware training materials, resources & training manuals for tutor-led Excel 2000 IT courses (foundation level)

Training Materials for:
Windows Vista
Windows XP
Microsoft Word 2007
Microsoft Excel 2007
PowerPoint 2007
Microsoft Access 2007
Internet Explorer 7
Outlook 2007
Expression Web
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
Computer Concepts
ECDL / ICDL Downloads

PLUS MANY MORE ...

Microsoft Excel 2000 Courseware Training Materials
Foundation Level Course

Courseware Training Manual

1. A FIRST LOOK AT EXCEL 2000

THE ADVANTAGES OF USING EXCEL 2000

WHAT ARE WORKBOOKS AND WORKSHEETS?

CREATING AND OPENING WORKBOOKS

To create a new default workbook
To create a new workbook file using a specified template
To open an existing workbook

ENTERING DATA

To enter numbers
To enter text
To enter dates or times
To modify the movement of the active cell when you press Enter

FURTHER DATA ENTRY TECHNIQUES

To enter data into a range of cells
To fill a range of cells with the same data

AUTOCORRECT

To view items that will be corrected by AutoCorrect
To add items to AutoCorrect
To delete an AutoCorrect entry

AUTOCOMPLETE

USING THE PICK LIST

To use a Pick List

NAVIGATING IN THE WORKSHEET

To move to a cell using the mouse
To move to a particular cell (quick way)
To move from cell to cell using the keyboard
To move within a selection
To move between sheets using the mouse
To move between sheets using the keyboard
To move using Go To
To move within formulas

SELECTING ITEMS WITHIN EXCEL 2000

To select a cell
To select a range of cells by dragging the mouse
To select a range of cells (making up a rectangular block)
To select a non-contiguous range
To select a row
To select a column
To select an entire worksheet
To select several sheets
To select all sheets

INSERTING AND DELETING CELLS, ROWS AND COLUMNS

To insert a row into a worksheet
To insert columns into a worksheet
To delete a row or column
To insert cells or ranges
To delete cells or ranges

SAVING WORKBOOKS

To save a workbook
To save a backup copy
To save summary information

MOVING BETWEEN WORKSHEETS

To move to a different worksheet within a workbook
To move to the first or last worksheet in a workbook
To move between worksheet tabs using the keyboard

USING THE SPELLING CHECKER

To check spelling in a worksheet

CLOSING AN EXCEL 2000 WORKBOOK

To close a file
To minimize a workbook window

EXITING EXCEL 2000

To exit Excel 2000

2. A CLOSER LOOK AT THE EXCEL 2000 SCREEN

THE STANDARD TOOLBAR

THE FORMATTING TOOLBAR

SELECTING WORKSHEET VIEWS

To change the View options
To zoom the view

UNDO AND REPEAT

To undo a command
To repeat a command

THE OFFICE ASSISTANT

What is the Microsoft Office Assistant?
Todays Tip
To display the Office Assistant
Displaying Tips via the Office Assistant
To hide the Office Assistant

3. FORMATTING AND CUSTOMIZING DATA

FORMATTING OPTIONS WITHIN EXCEL 2000

ALIGNMENT

To align data between the left and right sides of a cell
To align data between the top and bottom of a cell
To change the 'read' orientation of data in cells
To wrap multiple lines of data in a cell

DATA INDENTATION AND ROTATION

To indent data within a cell
To rotate text to any angle

TO CENTER ITEMS IN A CELL/CELLS

To center a heading over multiple columns
To center data within a cell

USING FONTS

To change the font used in a cell or range
To change the default font of the current workbook
To change the default font in all new workbooks
To change the font attributes for selected cells and numbers
To change other font characteristics

FORMATTING NUMBERS

To change number formatting using the formatting icons
To apply a custom format to numbers in a cell or range
To format a number as a percentage
To round numbers using a numeric format

DECIMAL PLACES

To establish a fixed number of decimal places for cell formats
To round a number to a certain number of decimal places
To set decimal places for all numeric values on the workbook

FORMATTING COLUMNS AND ROWS

To change the width of a column
To set the column width to match the data automatically
To change the width of multiple columns to match the data
To set new default column widths
To change the height of a row
To automatically change a row height to match the data

DELETING CELLS, FORMATS, OBJECTS AND WORKSHEETS

To delete the contents of a cell or range
To delete data without removing the underlying cell formats
To delete rows and columns
To delete cells or ranges
To delete worksheets

ADDING, EDITING AND REMOVING BORDERS

To apply a border to cells or ranges
To remove a border from cells or ranges
To change the style and color of borders

USING AUTOFORMAT

To AutoFormat a table

COPYING DATA

To copy data to a different location on the same page
To use the Clipboard to copy data to other programs
To copy multiple items to the Clipboard
To view the Clipboard toolbar
Pasting multiple items from the Clipboard

COPYING DATA USING DRAG AND DROP

To move and copy data to another worksheet
To copy data to another workbook
To copy data over several cells (fill)
To use the Clipboard to copy an object between pages, workbooks, or programs
To copy an object to a different location on the sheet
To insert new cells to make space for the copied data

COPYING COLUMNS AND ROWS

To copy a numeric value down a column
To copy a column of text into a row
To copy a formula across several cells in a column or row

4. FORMULAS, FUNCTIONS AND NAMED RANGES

FORMULAS

To enter a formula
To enter a cell or range reference by pointing

OPERATOR EVALUATION ORDER WITHIN EXCEL 2000

FUNCTIONS

To enter functions directly into the worksheet cell

FUNCTIONS (CONTINUED)

USING THE SUM FUNCTION

To sum numbers automatically
To use the SUM function

OTHER COMMONLY USED FUNCTIONS

USING PASTE FUNCTION

To use the Paste Function to enter a function

NAMING CELLS AND RANGES

Rules for naming cells and ranges
To name cells (long method)
To name cells (short method)
To navigate workbooks using named ranges
To create named ranges based on cell values
To delete named cells/ranges

USING NAMED RANGES WITH FORMULAS

5. INTRODUCING CHARTS

CREATING A CHART

To use the Chart Wizard to create a chart

MANIPULATING CHARTS

To move a chart
To re-size a chart
To delete a chart

CHANGING THE CHART TYPE

To use the Chart Type icon

6. PRINTING

PAGE SETUP

To change Page Setup options
To set print quality
To set the scale of the page

MARGINS

To change the margins
To change header and footer margins
To change margins in Print Preview
To change the way the data is centered on the page

CENTERING PRINTED OUTPUT

To center your printed output on a page

HEADERS AND FOOTERS

To use standard headers and footers
To create custom headers and footers

SHEET PRINTING OPTIONS

To change sheet options

CHOOSING A PRINTER AND CHANGING SETTINGS

To select a printer
To change the printer settings
To set the print area

PRINTING A WORKSHEET

To print
To print column or row titles on every page
To print sideways
To preview a worksheet

PRINTING MULTIPLE FILES

To print a number of files at the same time

Other Microsoft Office 2000 Courseware materials

   © 1995-2008 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged. Terms & Conditions
   Course content subject to change without notice.

Now download complete samples of all our courses

Download Computer Training Sample Courses

    Consider the benefits of investing in quality computer courseware materials:
    For schools, colleges, professional IT trainers & computer training companies

    You get duplication rights for all 150+ computer courses when you invest in the 'Courseware Library'

Cheltenham Courseware for Australian Schools & Computer Training Companies | You are not using a JavaScript enabled browser. The JS used on this site is used for presentational purposes only.

Microsoft Excel 2000 Courseware Training MaterialsFoundation Level Course