ActiveEducation's Excel 97 Introduction

by ActiveEducation, ActiveEducation Staff, Jodie Jones

Excel 97: Introduction ActiveEducation's course, Excel 97: Introduction, presents the basic operations for creating and editing worksheets and charts. Course Objectives  Understand basic worksheet fundamentals  Create and format a worksheet  Edit a worksheet  Create charts  Enhance a worksheet file  Use functions and review basic techniques Lesson Topics Lesson 1: Understanding Basic Worksheet Fundamentals Understanding Basic Window Elements Moving Around in the Worksheet Window Selecting Cells Accessing Online Help Lesson 2: Creating and Formatting a Worksheet Editing Cell Contents Saving a Workbook File Creating a Formula Formatting Numeric Entries Printing a Worksheet Lesson 3: Editing a Worksheet Displaying a Workbook File Modifying the Worksheet Filling a Range of Cells Creating Absolute Formulas Enhancing a Worksheet Lesson 4: Creating Charts Understanding Charts Modifying the Chart Type Enhancing a Chart Printing a Chart Lesson 5: Enhancing a Worksheet File Using AutoFormat Using Conditional Formatting Adding Comments to Cells Adding Text Objects Adding Headers and Footers Modifying the Page Layout Lesson 6: Using Functions Using Named Ranges Using Excel Functions Using Row and Column Labels in Formulas Conducting a Test Reviewing Basic Techniques

198 pages, Spiral-bound

First published January 12, 1997