SUMMARY OF LEVEL 1

AUDITING
	PRECEDENTS
	DEPENDENTS
	VALUE ERROR
	FORMULA AUDITING TOOLBAR

AUTOMATIC SUBTOTALS
	DISPLAY/SUPPRESS DETAIL
	REMOVE SUBTOTALS

CHARTS
	CREATE CHART
	EDIT CHART DATA
	CHANGE AREA TO BE CHARTED
	MOVE CHART
	SIZE A CHART
	ADD/EDIT CHART AND AXIS TITLES
	CHART TOOLBAR
	CHANGE SERIES COLORS
	  - Gradient Fill Effect
	  - Texture Fill Effect
	  - Pattern Fill Effect
	  - Picture Fill Effect
	ROTATE LABEL TEXT
	FONT
	CHANGE CHART TYPE
	CHANGE CHART/PLOT AREA BACKGROUND COLOR
	DELETE CHART

COMMENTS
	CREATE COMMENT
	DISPLAY/HIDE COMMENT
	REVIEWING TOOLBAR
	MOVE COMMENT BOX
	PRINT COMMENT
	RESIZE COMMENT BOX
	EDIT COMMENT
	REMOVE A COMMENT

CONDITIONAL FORMATTING
	ADD CONDITIONAL FORMAT
	FORMULA CONDITIONAL FORMAT
	COMPARE TEXT
	REMOVE CONDITIONAL FORMAT

CUSTOM NUMBER FORMATS
	FORMAT SYMBOLS
	ADD TEXT TO NUMBERS
	CREATE CUSTOM NUMBER FORMAT
	SELECT CUSTOM FORMAT
	SET COLOR ATTRIBUTE
	POSITIVE AND NEGATIVE NUMBERS, ZERO AND TEXT
	SUPPRESS ZERO ENTRIES
	EDIT CUSTOM FORMAT
	REMOVE CUSTOM FORMAT

DATA FORM
	OPTIONS
	DISPLAY SPECIFIC RECORD
	SPECIFY CRITERIA
	ERROR MESSAGE

FILTER
	CREATE AUTOFILTER
	REDISPLAY ALL RECORDS
	DISPLAY HIGHEST/LOWEST VALUES
	CUSTOMIZED FILTER
	REMOVE FILTER BUTTONS

FUNCTIONS
	SUM
	AVERAGE
	MAX
	MIN
	IF
	  - Nested IF Functions

LINK CELLS
	UNLINK CELL

LOCK CELLS
	REMOVE CELL PROTECTION
	PROTECT WORKBOOK
	  - Remove Password Protection
	PROTECT WORKBOOK STRUCTURE
	  - Remove Workbook Protection

LOOKUP TABLES
	VERTICAL LOOKUP TABLE
	HORIZONTAL LOOKUP TABLE

MACROS
	OVERVIEW
	RECORD MACRO
	RUN MACRO
	SAVE PERSONAL MACROS
	KEYBOARD SHORTCUT KEY
	  - Add Keyboard Shortcut Key
	  - Remove Keyboard Shortcut Key
	ADD MACRO TO TOOLBAR
	  - Remove Macro from Toolbar
	EDIT MACRO
	DELETE MACRO

PIVOT TABLES
	CREATE PIVOT TABLE
	  - Example of Pivot Tables
	PIVOT TABLE TOOLBAR
	EDIT DATA

SORT
	SORT BY SINGLE COLUMN
	SORT BY MULTIPLE COLUMNS
	SORT COLUMNS HORIZONTALLY
	SORT BY MONTHS, DAYS OR CUSTOM LIST

TEMPLATES
	CREATE TEMPLATE
	SELECT TEMPLATE
	MODIFY TEMPLATE
	AUTOTEMPLATE

TOOLBARS
	DISPLAY TOOLBAR
	CREATE TOOLBAR
	CUSTOMIZE TOOLBAR
	RESET SYSTEM TOOLBARS
	DELETE TOOLBAR

VALIDATION
	DATA TYPES
	SET VALIDATION RULE
	INPUT MESSAGE
	ERROR MESSAGE
	REMOVE VALIDATION