EXCEL 2000 INTERMEDIATE

COURSE OUTLINE

SECTION 1 – USING WORKBOOKS

· WORKBOOK OVERVIEW

SECTION 2- LINKING & CONSOLIDATING

· WORKING WITH FORMULAS THAT LINK WORKSHEETS AND FILES

· CONSOLIDATING DATA FROM VARIOUS WORKSHEETS

SECTION 3 – USING EXCEL AS A DATABASE

· DATABASE OVERVIEW

· RULES FOR DESIGNING A DATABASE

SECTION 4 – SORTING AND SUBTOTALING

· SORTING A WORKSHEET DATABASE

· SORTING BY COLUMNS

· CREATING CUSTOM SORT ORDERS

· PRODUCING SUBTOTALS ON A SORTED LIST

SECTION 5 – USING FILTERS AND CRITERIA

· USING AUTOFILTER

· PLACING TOTALS BELOW A FILTERED LIST

· SETTING A CUSTOM AUTOFILTER

· USING THE TOP TEN AUTOFILTER

· WORKING WITH CRITERIA RANGES

SECTION 6 - USING A DATA FORM

· DATA FORMS

· SEARCHING FOR RECORDS IN A DATA FORM

SECTION 7 – CHARTING

· CREATING A CHART

· CHARTING ASSUMPTIONS

· MODIFYING THE CHART

· WORKING WITH SERIES-RELATED OPTIONS

· CHANGING SERIES ORIENTATION FROM ROWS TO COLUMNS

· CHANGING THE DATA SERIES ORDER

· ENHANCING THE CHART

· UPDATING A CHART’S DATA SERIES

· USER-DEFINED CUSTOM TYPES

· PRINTING CHARTS

Course Length: 1 day

Prerequisites: Excel 2000 Fundamentals