|
LEARN
EXCEL 2000
© 2000 Prentice Hall
ISBN: 1-58076-261-1
Lesson 1: The Basics
Task 1: Navigating a Workbook
Task 2: Selecting Individual Cells
Task 3: Entering Text and Numbers
Into Cells
Task 4: Fixing Simple Typing Errors
Task 5: Summing a Column of Numbers
Task 6: Saving a Workbook, Printing
and Closing a Worksheet
Task 7: Getting Help Using the Office
Assistant and Exiting Excel
Lesson 2: Formatting the Worksheet
Task 1: Opening an Existing Workbook
Task 2: Selecting Groups of Cells
Task 3: Formatting Large Numbers,
Currency, Decimal Places, and Dates
Task 4: Adjusting Columns and Cells
for Long Text or Numbers
Task 5: Aligning Text in the Cell
Task 6: Changing the Font, Size,
and Emphasis of Text
Task 7: Adding Lines, Borders, Colors,
and Shading
Lesson 3: Editing Cell Contents
Task 1: Changing Numbers and Editing
Text
Task 2: Inserting and Deleting Rows,
Columns, and Sheets
Task 3: Removing Cell Content and
Formatting
Task 4: Undoing and Redoing Previous
Steps
Task 5: Automatically Correcting
Common Typing Errors
Task 6: Automatically Finishing
Commonly Used Words or Phrases
Task 7: Checking Your Spelling
Lesson 4: Filling, Copying, and
Printing
Task 1: Creating Sequential Labels
Task 2: Creating a Series of Numbers
Task 3: Freezing Panes and Changing
Zoom
Task 4: Copying Cell Contents
Task 5: Selecting a Range of Cells
to Print and Previewing the Printout
Task 6: Improving the Printed Spreadsheet
Task 7: Printing Row or Column Labels
Lesson 5: Making the Computer
Do the Math
Task 1: Adding, Subtracting, Multiplying,
and Dividing Using Cell References and Numbers
Task 2: Using Formulas with More
than One Cell Reference
Task 3: Combining Operations and
Filling Cells with Formulas
Task 4: Filling Cells with Relative
and Absolute Formulas
Task 5: Applying Basic Formulas
to a Loan Repayment
Task 6: Using Built-in Financial
Formulas
Task 7: Using Counting and Conditional
Formulas
Task 8: Using Excel to Explore Different
Possibilities
Lesson 6: Understanding the Numbers
Using a Chart
Task 1: Creating a Chart to Show
a Trend
Task 2: Creating a Chart to Show
Contributions to a Whole
Task 3: Creating a Chart to Make
Comparisons
Task 4: Editing the Elements of
a Chart
Task 5: Changing Chart Types
Task 6: Printing a Chart
Lesson 7: Sorting, Grouping and
Filtering Data
Task 1: Sorting Rows by Department
Task 2: Grouping and Subtotaling
by Department
Task 3: Displaying Totals and Subtotals
Without the Details
Task 4: Filtering Information to
Show Specified Rows
Task 5: Identifying Overdue Orders
Using the Logical IF Function
Task 6: Removing Filters, Totals,
and Outlines
Lesson 8: Creating Connections
to Build Summaries,
Improve Teamwork, and Work on the Web
Task 1: Inserting and Moving a New
Sheet
Task 2: Designing a Summary Sheet
for Convenient Charting
Task 3: Linking the Results of Several
Sheets to a Summary Sheet
Task 4: Insert a Hyperlink to Another
Worksheet
Task 5: Saving a Worksheet as a
Web Page
Task 6: Using a Worksheet on the
Web
|