Overview

This book provides an overview of the basics of Excel 2003. It includes tables which summarize each task covered to make it a reference that your students will want to keep.

Full Product Details

Author:   Julie Hayward Spooner
Publisher:   Pearson Education (US)
Imprint:   Scott Jones Publishing Inc., US
Dimensions:   Width: 21.30cm , Height: 2.80cm , Length: 27.60cm
Weight:   1.370kg
ISBN:  

9781576761137

ISBN 10:   1576761134
Pages:   752
Publication Date:   15 September 2006
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   Out of stock  

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

Reviews

Author Information

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions