Each chapter
includes

Task
Summary
A table that lists every task covered
in a chapter and how to execute it. It is designed as a quick reference to
review how to use Excel commands and features.

Chapter
Exercises
A variety of exercises based on the
material in the chapter, and in some instances topics from previous chapters
are included as a review. For an explanation of the exercises, see the
Introducing Focus on Excel 2003 Exercises following this section.

Focus On
Functions
Students typically have a difficult time learning functions. This
enrichment feature teaches more about functions through the use of a
combination lesson/exercise. A function is demonstrated through worksheet
pictures and accompanying explanations. After the student learns about the
function, an exercise is offered to test understanding. These features appear
between chapters and can be assigned by the instructor at any time.

Focus On
Business Math
At many schools there is no "prereq" for enrolling in Excel. As a
result, many students enroll without a sufficient understanding of basic
business mathematics. These students typically have a difficult time learning
Excel. This feature is designed for such students and provides an enrichment
feature that teaches basic math skills used in business Through the use of
examples, the concepts are explained, and the student has an opportunity to
test their understanding by completing a short exercise. These features appear
between chapters and can be assigned by the instructor at any time.
Each exercise
set includes

On Your
Own
Students take the skills learned in the current chapter and apply them to a
situation in their own life. Independent thinking is important with this
exercise, because students need to analyze where and how they can apply Excel
skills.

Challenge
Yourself
Starting with Chapter 4, there are one to three challenges per chapter. These
challenges require critical thinking about the application of skills presented
in the current and previous chapters. They are designed so students can prove
that they have a good understanding of Excel concepts and can apply them to
thoughtprovoking situations.

Case
Studies
Starting with Chapter 2, scenarios about are two companies appear at the end
of every chapter. Students apply the Excel concepts to the forms and financial
setups these companies use.
Table
of Contents
Preface
Introducing Excel
Using Excel
A Brief History of the Spreadsheet
The Microsoft Excel 2003 Difference
Focus On Excel 2003’s Content
End of Chapter Materials
How the Exercises Work
Conventions Used in this Textbook
Focus on Excel 2003’s CD Content
File Management
CHAPTER 1:
Navigating Excel
Lesson 1.1: Windows and the Excel Environment
Lesson 1.2: Working with Worksheets and Workbooks
Introduction to Focus on Excel 2003 Chapter Exercises
CHAPTER 2:
Building a Worksheet
Lesson 2.1: Entering and Editing Data
Lesson 2.2: Entering Functions Using Autosum
Lesson 2.3: Preparing to Print
Chapter 2 Exercises
Focus on Business Math: Understanding and Calculating Averages
Focus on Business Math: Converting a Percent to Decimal and a Decimal
to Percent
Focus on Business Math: Calculating Percentages
CHAPTER 3: Formatting and Modifying a Worksheet
Lesson 3.1: Formatting Basics
Lesson 3.2: Enhancing a Worksheet
Chapter 3 Exercises
Focus on Functions: The Effect of Zeros and Empty Cells on Function
Results
Focus on Business Math: Understanding Depreciation
Focus on Business Math: Evaluating Stock Profit and Loss
CHAPTER 4: Applying the Power of Formulas and Functions
Lesson 4.1: Creating Formulas
Lesson 4.2: Entering Functions and Calculating On Dates
Lesson 4.3: Financial Functions and What If Analysis
Lesson 4.4: Naming Cells for Easy Referencing
Chapter 4 Exercises
Focus on Functions: Returning the Computer Date and Time with TODAY
and NOW
Focus on Functions: Summing a Different Way with SUMIF
Focus on Business Math: How Payroll Is Calculated
CHAPTER 5: Creating Charts
Lesson 5.1: Introducing Charts and Creating a Column Chart
Lesson 5.2: Editing a Chart
Lesson 5.3: Creating a Pie Chart and Printing Charts
Chapter 5 Exercises
Focus on Functions: Counting a Different Way with COUNTIF
Focus on Business Math: Calculating Commissions and Bonuses
CHAPTER 6: Working with Workbooks
Lesson 6.1: Exploring Workbook Fundamentals
Lesson 6.2: Creating 3D References and Linking Formulas
Chapter 6 Exercises
Focus on Functions: Changing Case with Text Functions
Focus on Functions: Nesting AND and OR for Multiple Criteria in
Arguments
Focus on Business Math: Calculating Sales Tax
CHAPTER 7: Managing Data with Excel Lists
Lesson 7.1: Understanding, Viewing, and Sorting Lists
Lesson 7.2: Working with Records
Lesson 7.3: Analyzing List Data
Lesson 7.4: Improving List Printouts
Chapter 7 Exercises
Focus on Functions: Using Database Functions
Focus on Business Math: What Happens When You Pay or Earn Interest
Focus on Business Math: Understanding a Sales Invoice
CHAPTER 8: More Functions and Advanced Features
Lesson 8.1: Planning with Financial Functions
Lesson 8.2: Inserting Horizontal and Vertical Lookup Functions
Lesson 8.3: Setting Up Data Tables
Lesson 8.4 Solving Problems with Advanced Tools
Chapter 8 Exercises
Focus on Functions: Calculating the Real Cost of a Loan with CUMIPMT
Focus on Functions: Returning a Row or Column Location with MATCH
CHAPTER 9: Controlling and Automating Workbooks
Lesson 9.1: Making Design Changes and Creating a Custom View
Lesson 9.2: Recording a Macro and Adding a Command Button to a Toolbar
Lesson 9.3: Protecting a Workbook and Creating a Template
Chapter 9 Exercises
Focus on Functions: Comparing Data with EXACT
CHAPTER 10: Sharing Data
Lesson 10.1: Importing Data from External Databases
Lesson 10.2: Using Workbook Data in Other Programs and on the Web
Lesson 10.3: Managing Shared Workbooks
Chapter 10 Exercises
APPENDICES
Appendix A: Menu Command Summary for Excel 2003
Appendix B: Function Reference (on CD)
Appendix C: Excel 2003 Task Panes (on CD)
Appendix D: Excel 2003 Smart Tags (on CD)
Appendix E: Microsoft Office Specialist Certificate Requirements (on CD)
Focus on Excel 2003
by Julie Spooner
ISBN: 1576761134 