|
|
Microsoft Excel 2000 Courseware
Intermediate Level Training Materials
Courseware Training Manual
1. WORKSHEETS, A FURTHER LOOK
RENAMING WORKSHEETS
DELETING AND INSERTING WORKSHEETS
- To insert a worksheet using the Insert menu
- To delete a worksheet using the Edit menu
- To insert or delete a worksheet by right-clicking
FINDING FILES
- To find a file using all or part of the file name
- To find a file containing a particular piece of text
- To search sub-folders
DISPLAYING OTHER TOOLBARS
- To display other toolbars
CUSTOMIZING THE LOOK OF THE TOOLBARS & MENUS
FREEZE PANES
- To freeze panes
- To unfreeze panes
GROUPING AND UNGROUPING WORKSHEETS
- To group worksheets
- To ungroup worksheets
THE SERIES COMMAND
- To apply a series using drag and drop techniques
- To apply a number series using drag and drop techniques
2. FURTHER FORMATTING TECHNIQUES
CONDITIONAL FORMATTING
- To format a range of cells using conditional formatting
CREATING NEW STYLES BASED ON EXISTING CELL FORMATTING
- To create a style based on existing formatting within a cell
- To apply a style to selected cells
USING COLORS IN EXCEL 2000
- To change the color of your text
- To print text in color or black and white
- To apply colors to cells
- To apply a pattern to cells
USING COLORS BASED ON VALUES
- To change colors based on the value in the cells
- To display negative numbers so that they are enclosed within brackets
GRIDLINES
- To turn off the gridlines on-screen
- To turn on the gridlines so that they will be printed
HIDING DATA AND RE-DISPLAYING DATA
- To hide columns (the long way)
- To re-display hidden columns (the hard way)
- To hide rows
- To re-display hidden rows
- To hide worksheets
- To re-display hidden worksheets
- To hide columns (using the mouse)
- To re-display hidden columns (using the mouse)
3. FURTHER FUNCTIONS
WHAT ARE FUNCTIONS?
- To enter functions directly into the worksheet cell
USING PASTE FUNCTION
- Ways to access the Paste Function Wizard
- To use the Paste Function to enter a function
- Using the mouse to enter information into the Paste Function wizard
THE IF( ) FUNCTION
DATA VALIDATION FUNCTIONS
THE HLOOKUP / VLOOKUP FUNCTIONS
- HLOOKUP Syntax
- VLOOKUP Syntax
A SAMPLE HLOOKUP
THE CHOOSE FUNCTION
ENTERING A CHOOSE FUNCTION
- To enter a CHOOSE function
THE DATE FUNCTIONS
- How are dates stored?
- To enter the current date into a spreadsheet
- To separate the year from a date
- To separate the month from a date
- To show the day of the week
- To show the day of the month
MATHEMATICAL DATE FUNCTIONS
- To calculate the difference between two dates in days or weeks
- To add days or weeks to a date
- To add months to a date
- To find out the last day of the month
TIME FUNCTIONS
TEXT MANIPULATION FUNCTIONS
4. DATABASE AND LIST MANAGEMENT
WHAT IS A DATABASE?
EXCEL 2000 DATABASES
- Excel 2000 database limitations
DATABASE TERMINOLOGY
CREATING, EDITING AND NAVIGATING A DATABASE
- To create an internal database
SORTING AN INTERNAL EXCEL 2000 DATABASE
- To sort the data within a database
- Using the 'Then by' Sort option
WHAT IS AUTOFILTER?
- To use AutoFilter
- Using drop down AutoFilters
FILTERING DATA
- To specify a conditional filter criteria
- Using the And/ Or filters
- To remove all AutoFilters
TOP 10 AUTOFILTER
ADVANCED FILTERING
- To use the Advanced Filter
- Criteria for Advanced Filter
- To remove all Advanced Filters
TOTALING AND MANIPULATING FILTERED DATA
- Totaling fields within a filtered database
- Manipulating filtered data
CREATING SUBTOTALS
- To create subtotals
- To remove subtotals
USING DATA FORMS
- To use a data form
- To add a new record
- To edit a record
- To move between records in the list
- To find records
- To delete a record
- To close a Data Form
THE EXCEL 2000 DATA FORM
- Data Form Controls and Function
5. CUSTOMIZING CHARTS
THE CHART WIZARD (1) - CHART TYPE
THE CHART WIZARD (2) - DATA SOURCE
- To display a series in columns
- To display a series in rows
THE CHART WIZARD (3) - CHART OPTIONS
- The chart options dialog box
- To add titles to a chart
- To customize the chart axis
- To customize chart gridlines
- To customize the chart legend
- To customize data labels
- To display a data table
THE CHART WIZARD (4) - CHART LOCATION
- To define the chart location
ADDING AND REMOVING DATA
- To add data to a chart
- To remove data from a chart
CHANGING DATA BY DRAGGING AND DROPPING COLUMNS
- To modify chart data using drag and drop techniques within the chart
FORMATTING THE CHART AREA
- To format the chart area
- To format the chart area - Patterns
- To use the chart border formatting options
- To use the chart area formatting options
- To use fill effects to format a chart area
- To format using a picture
- To format the chart area - Font
- To format the chart area - Properties
CHART FORMATTING - LEGENDS
CHART FORMATTING - AXIS
- To format axis patterns
- To format axis scales
- To format axis fonts
- To format axis numbers
- To format axis alignment
CHART FORMATTING - THE PLOT AREA
CHART FORMATTING - GRIDLINES
- To format chart gridlines
CHART FORMATTING - THE DATA SERIES
- To format the data series patterns
- To format the data series axis
- To format the data series Y error bars
- To format the data series data labels
- To format the data series order
- To format the data series options
6. DRAWING AND PICTURES
DRAWING LINES, BOXES, OVALS AND ARCS
- To display the drawing toolbar
- To draw lines, boxes, ovals, and arcs
- To move an object around a page
- To copy objects
USING AUTOSHAPES
- To insert an AutoShape object into your Worksheet
- To format AutoShape objects
CREATING TEXT BOXES
- To create a text box
- To edit text in a text box
- To delete a text box
- To insert text into a text box
PICTURES
- To insert clipart
- The Picture toolbar
- To move a picture
- To re-size a picture
- To delete a picture
BRING TO FRONT/SEND TO BACK
- To control how pictures are layered on top of each other
GROUPING AND UN-GROUPING OBJECTS
- To group objects so that they are treated as a single object
- To un-group objects that have been grouped into a single object
7. EXCEL 2000 AND OTHER APPLICATIONS
USING THE CONVERSION FEATURE
- To convert Lotus 1-2-3 or other worksheets into Excel 2000 worksheets
- To change data to graphic objects
CUT, COPY AND PASTE - USING THE CLIPBOARD
- To cut data to the Clipboard
- To copy data to the Clipboard
- To paste data from the Clipboard
USING PASTE SPECIAL
- To use the Paste Special command
OLE - EMBEDDING VS. LINKING
- What is embedding?
- What is linking?
LINKING DATA FROM OTHER WORKSHEETS
- To link data from other worksheets
- To link data from other workbooks
- To update links
LINKING DATA FROM WORD
- To copy data to the Clipboard
- To Paste Link the selected Word data to Excel 2000
LINKING DATA TO WORD
- To copy data to the Clipboard
- To Paste Link the selected Excel 2000 data to Word
|
Customisable
Courseware
