|
|
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
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
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
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
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
|
Customisable
Courseware
