|
SEO
training seminars, Perth, WA
|
Microsoft Excel 2000 Courseware Training Materials
Intermediate Level
Course
Courseware Training Manual
 1. WORKSHEETS, A FURTHER LOOK
-
RENAMING WORKSHEETS
-
DELETING AND INSERTING WORKSHEETS
-
FINDING FILES
-
DISPLAYING OTHER TOOLBARS
-
CUSTOMIZING THE LOOK OF THE TOOLBARS & MENUS
-
FREEZE PANES
-
GROUPING AND UNGROUPING WORKSHEETS
-
THE SERIES COMMAND
2. FURTHER FORMATTING TECHNIQUES
-
CONDITIONAL FORMATTING
-
CREATING NEW STYLES BASED ON EXISTING CELL FORMATTING
-
USING COLORS IN EXCEL 2000
-
USING COLORS BASED ON VALUES
-
GRIDLINES
-
HIDING DATA AND RE-DISPLAYING DATA
3. FURTHER FUNCTIONS
-
WHAT ARE FUNCTIONS?
-
USING PASTE FUNCTION
-
THE IF( ) FUNCTION
-
DATA VALIDATION FUNCTIONS
-
THE HLOOKUP / VLOOKUP FUNCTIONS
-
A SAMPLE HLOOKUP
-
THE CHOOSE FUNCTION
-
ENTERING A CHOOSE FUNCTION
-
THE DATE FUNCTIONS
-
MATHEMATICAL DATE FUNCTIONS
-
TIME FUNCTIONS
-
TEXT MANIPULATION FUNCTIONS
4. DATABASE AND LIST MANAGEMENT
-
WHAT IS A DATABASE?
-
EXCEL 2000 DATABASES
-
DATABASE TERMINOLOGY
-
CREATING, EDITING AND NAVIGATING A DATABASE
-
SORTING AN INTERNAL EXCEL 2000 DATABASE
-
WHAT IS AUTOFILTER?
-
FILTERING DATA
-
TOP 10 AUTOFILTER
-
ADVANCED FILTERING
-
TOTALING AND MANIPULATING FILTERED DATA
-
CREATING SUBTOTALS
-
USING DATA FORMS
-
THE EXCEL 2000 DATA FORM
5. CUSTOMIZING CHARTS
-
THE CHART WIZARD (1) - CHART TYPE
-
THE CHART WIZARD (2) - DATA SOURCE
-
THE CHART WIZARD (3) - CHART OPTIONS
-
THE CHART WIZARD (4) - CHART LOCATION
-
ADDING AND REMOVING DATA
-
CHANGING DATA BY DRAGGING AND DROPPING COLUMNS
-
FORMATTING THE CHART AREA
-
CHART FORMATTING - LEGENDS
-
CHART FORMATTING - AXIS
-
CHART FORMATTING - THE PLOT AREA
-
CHART FORMATTING - GRIDLINES
-
CHART FORMATTING - THE DATA SERIES
6. DRAWING AND PICTURES
-
DRAWING LINES, BOXES, OVALS AND ARCS
-
USING AUTOSHAPES
-
CREATING TEXT BOXES
-
PICTURES
-
BRING TO FRONT/SEND TO BACK
-
GROUPING AND UN-GROUPING OBJECTS
7. EXCEL 2000 AND OTHER APPLICATIONS
-
USING THE CONVERSION FEATURE
-
CUT, COPY AND PASTE - USING THE CLIPBOARD
-
USING PASTE SPECIAL
-
OLE - EMBEDDING VS. LINKING
-
LINKING DATA FROM OTHER WORKSHEETS
-
LINKING DATA FROM WORD
-
LINKING DATA TO WORD
Other Microsoft Office 2000 Courseware materials
|
|
Customisable
Courseware