Intermediate Excel 2002 Author:Pamela W. Adams The Intermediate Excel 2002 courseware begins with creating a chart sheet in Excel 2002 (Office XP version). You will create both chart sheets and embedded charts and learn to use the Charting toolbar and edit and enhance charts in the first two sections. Section three is a review of the AutoCalculator, simple formulas and basic functions (sum... more », average, count) in Excel including a simple IF statement. Section four will teach you how to create a list (database) in Excel and use the Data Form to maintain the list. Section five will introduce you to sorting and filtering lists in Excel including Subtotals. Section six will introduce data functions in lists, sumif and countif statements and range names.« less