|
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
|
Computer Based Training