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 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
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)
