Scott/Jones ∑ Scott/Jones ∑ Scott/Jones ∑ Scott/Jones ∑ Scott/Jones ∑ Scott/Jones ∑ Scott/Jones ∑ Scott/Jones

Home | Textbook Catalog | Order Book | Syllabi



Save 12% over most
bookstore prices by ordering
directly from Scott/Jones!

Focus on Excel

Julie Spooner

ISBN 1-57676-113-4

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 "pre-req" 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 thought-provoking 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

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 3-D 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

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: 1-57676-113-4

Home | Textbook Catalog | Order Book | Syllabi

Scott/Jones Inc., El Granada CA
Website maintenance & updating by
Jane Scott/Jones
Updated January
, 2004.