|
1. WORKSHEETS, A FURTHER LOOK
RENAMING WORKSHEETS
To rename a worksheet
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
To use 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
To create a chart
THE CHART WIZARD (2) - DATA SOURCE
To display a series in columns
To display a series in rows
THE CHART WIZARD (3) - CHART OPTIO NS
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
To format a chart legend
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
To format 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
|
Computer Based Training