9781418842956

Microsoft Office Excel 2003, Illustrated Introductory, CourseCard Edition

by
  • ISBN13:

    9781418842956

  • ISBN10:

    1418842958

  • Edition: 1st
  • Format: Paperback
  • Copyright: 3/21/2005
  • Publisher: Course Technology
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping On Orders Over $59!
    Your order must be $59 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $87.95

Summary

Part of the Illustrated series, this text offers a visual, flexible way to build Microsoft Excel 2003 skills.

Table of Contents

Prefacep. vi
Getting Started with Excel 2003p. 1
Defining Spreadsheet Softwarep. 2
Starting Excel 2003p. 4
Viewing the Excel Windowp. 6
Working with toolbars and menus in Excel 2003
Opening and Saving a Workbookp. 8
Creating a new workbook
Opening a workbook using a template
Entering Labels and Valuesp. 10
Navigating a worksheet
Naming and Moving a Sheetp. 12
Copying worksheets
Previewing and Printing a Worksheetp. 14
Using Zoom in Print Preview
Getting Helpp. 16
Using the Office Assistant
Closing a Workbook and Exiting Excelp. 18
Concepts Reviewp. 20
Skills Reviewp. 21
Independent Challengesp. 23
Visual Workshopp. 26
Building and Editing Worksheetsp. 1
Planning and Designing a Worksheetp. 2
Editing Cell Entriesp. 4
Recovering a lost workbook file
Entering Formulasp. 6
Creating Complex Formulasp. 8
Order of precedence in Excel formulas
Editing formulas
Introducing Excel Functionsp. 10
Using the MIN and MAX functions
Using Excel Functionsp. 12
Copying and Moving Cell Entriesp. 14
Using the Office Clipboard
Understanding Relative and Absolute Cell Referencesp. 16
Using a mixed reference
Printing worksheet formulas
Copying Formulas with Relative Cell Referencesp. 18
Filling cells with sequential text or values
Copying Formulas with Absolute Cell Referencesp. 20
Inserting and deleting selected cells
Concepts Reviewp. 22
Skills Reviewp. 23
Independent Challengesp. 24
Visual Workshopp. 28
Formatting a Worksheetp. 1
Formatting Valuesp. 2
Using the Format Painter
Using Fonts and Font Sizesp. 4
Inserting and adjusting clip art
Changing Attributes and Alignmentp. 6
Rotating and indenting cell entries
Using AutoFormat
Adjusting Column Widthsp. 8
Specifying row height
Inserting and Deleting Rows and Columnsp. 10
Hiding and unhiding columns and rows
Adding and editing comments
Applying Colors, Patterns, and Bordersp. 12
Formatting columns or rows
Using Conditional Formattingp. 14
Deleting conditional formatting
Checking Spellingp. 16
Using e-mail to send a workbook
Concepts Reviewp. 18
Skills Reviewp. 20
Independent Challengesp. 22
Visual Workshopp. 26
Working with Chartsp. 1
Planning and Designing a Chartp. 2
Creating a Chartp. 4
Moving and Resizing a Chartp. 6
Changing the location of a chart
Editing a Chartp. 8
Rotating a 3-D chart
Formatting a Chartp. 10
Adding data labels to a chart
Enhancing a Chartp. 12
Changing text alignment in charts
Annotating and Drawing on a Chartp. 14
Adding an organizational chart or other diagram type
Exploding a pie slice
Previewing and Printing a Chartp. 16
Using the Page Setup dialog box for a chart
Concepts Reviewp. 18
Skills Reviewp. 19
Independent Challengesp. 21
Visual Workshopp. 24
Working with Formulas and Functionsp. 1
Creating a Formula with Several Operatorsp. 2
Using Paste Special
Using Names in a Formulap. 4
Defining and removing styles
Producing a list of names
Generating Multiple Totals with AutoSump. 6
Quick calculations with AutoCalculate
Using Dates in Calculationsp. 8
Applying and creating custom number and date formats
Building a Conditional Formula with the IF Functionp. 10
Correcting circular references
Using Statistical Functionsp. 12
Using the COUNTA function
Calculating Payments with the PMT Functionp. 14
Calculating future value with the FV function
Displaying and Printing Formula Contentsp. 16
Setting margins and alignment when printing part of a worksheet
Concepts Reviewp. 18
Skills Reviewp. 19
Independent Challengesp. 21
Visual Workshopp. 24
Managing Workbooks and Preparing Them for the Webp. 1
Freezing Columns and Rowsp. 2
Viewing and arranging worksheets
Splitting the worksheet into multiple panes
Inserting and Deleting Worksheetsp. 4
Grouping worksheets
Specifying headers and footers
Consolidating Data with 3-D Referencesp. 6
Linking data between workbooks
Hiding and Protecting Worksheet Areasp. 8
Changing workbook properties
Saving Custom Views of a Worksheetp. 10
Creating a workspace
Controlling Page Breaks and Page Numberingp. 12
Using Page Break Preview
Creating a Hyperlink Between Excel Filesp. 14
Finding and replacing data and formats
Using research services
Saving an Excel File as a Web Pagep. 16
Converting Excel files to other file types
Holding Web discussions
Concepts Reviewp. 18
Skills Reviewp. 19
Independent Challengesp. 21
Visual Workshopp. 24
Automating Worksheet Tasksp. 1
Planning a Macrop. 2
Macros and viruses
Recording a Macrop. 4
Running a Macrop. 6
Setting macro security levels
Adding a digital signature to a macro
Editing a Macrop. 8
Adding comments to Visual Basic code
Using Shortcut Keys with Macrosp. 10
Running a macro from a hotspot on your worksheet
Using the Personal Macro Workbookp. 12
Working with the Personal Macro Workbook
Adding a Macro as a Menu Itemp. 14
Adding a custom menu
Creating a Toolbar for Macrosp. 16
Organizing macros
Concepts Reviewp. 18
Skills Reviewp. 19
Independent Challengesp. 21
Visual Workshopp. 24
Using Listsp. 1
Planning a Listp. 2
Creating a Listp. 4
Filtering lists using AutoFilter
Adding Records with the Data Formp. 6
Finding Recordsp. 8
Using wildcards to fine-tune your search
Deleting Recordsp. 10
Deleting records using the worksheet
Sorting a List on One Fieldp. 12
Sorting records using the AutoFilter
Sorting a List on Multiple Fieldsp. 14
Specifying a custom sort order
Printing a Listp. 16
Setting a print area
Concepts Reviewp. 18
Skills Reviewp. 19
Independent Challengesp. 20
Visual Workshopp. 24
Glossaryp. 1
Indexp. 6
Table of Contents provided by Ingram. All Rights Reserved.

Rewards Program

Write a Review