CourseGuide: Microsoft Office Excel 2003-Illustrated BASIC,9780619057725

CourseGuide: Microsoft Office Excel 2003-Illustrated BASIC

by
Edition: 1st
ISBN13: 9780619057725
ISBN10: 0619057726
Format: Spiral Bound
Pub. Date: 2004-04-28
Publisher(s): Course Technology
List Price: $89.68

Buy New

Usually ships in 2 to 3 business days.
$85.41
Add to Cart

Rent Textbook

Select for Price
Add to Cart
There was a problem. Please try again later.

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

Buy from our Marketplace starting at $6.61

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Table of Contents

Preface iv
EXCEL 2003
Getting Started with Excel 2003
1(1)
Defining Spreadsheet Software
2(2)
Starting Excel 2003
4(2)
Viewing the Excel Window
6(2)
Working with toolbars and menus in Excel 2003
Opening and Saving a Workbook
8(2)
Creating a new workbook
Opening a workbook using a template
Entering Labels and Values
10(2)
Navigating a worksheet
Naming and Moving a Sheet
12(2)
Copying worksheets
Previewing and Printing a Worksheet
14(2)
Using Zoom in Print Preview
Getting Help
16(2)
Using the Office Assistant
Closing a Workbook and Exiting Excel
18(2)
Concepts Review
20(1)
Skills Review
21(2)
Independent Challenges
23(3)
Visual Workshop
26
EXCEL 2003
Building and Editing Worksheets
1(1)
Planning and Designing a Worksheet
2(2)
Editing Cell Entries
4(2)
Recovering a lost workbook file
Entering Formulas
6(2)
Creating Complex Formulas
8(2)
Order of precedence in Excel formulas
Editing formulas
Introducing Excel Functions
10(2)
Using the MIN and MAX functions
Using Excel Functions
12(2)
Copying and Moving Cell Entries
14(2)
Using the Office Clipboard
Understanding Relative and Absolute Cell References
16(2)
Using a mixed reference
Printing worksheet formulas
Copying Formulas with Relative Cell References
18(2)
Filling cells with sequential text or values
Copying Formulas with Absolute Cell References
20(2)
Inserting and deleting selected cells
Concepts Review
22(1)
Skills Review
23(1)
Independent Challenges
24(4)
Visual Workshop
28
EXCEL 2003
Formatting a Worksheet
1(1)
Formatting Values
2(2)
Using the Format Painter
Using Fonts and Font Sizes
4(2)
Inserting and adjusting clip art
Changing Attributes and Alignment
6(2)
Rotating and indenting cell entries
Using AutoFormat
Adjusting Column Widths
8(2)
Specifying row height
Inserting and Deleting Rows and Columns
10(2)
Hiding and unhiding columns and rows
Adding and editing comments
Applying Colors, Patterns, and Borders
12(2)
Formatting columns or rows
Using Conditional Formatting
14(2)
Deleting conditional formatting
Checking Spelling
16(2)
Using e-mail to send a workbook
Concepts Review
18(2)
Skills Review
20(2)
Independent Challenges
22(4)
Visual Workshop
26
EXCEL 2003
Working with Charts
1(1)
Planning and Designing a Chart
2(2)
Creating a Chart
4(2)
Moving and Resizing a Chart
6(2)
Changing the location of a chart
Editing a Chart
8(2)
Rotating a 3-D chart
Formatting a Chart
10(2)
Adding data labels to a chart
Enhancing a Chart
12(2)
Changing text alignment in charts
Annotating and Drawing on a Chart
14(2)
Adding an organizational chart or other diagram type
Exploding a pie slice
Previewing and Printing a Chart
16(2)
Using the Page Setup dialog box for a chart
Concepts Review
18(1)
Skills Review
19(2)
Independent Challenges
21(3)
Visual Workshop
24
EXCEL 2003
Working with Formulas and Functions
1(1)
Creating a Formula with Several Operators
2(2)
Using Paste Special
Using Names in a Formula
4(2)
Defining and removing styles
Producing a list of names
Generating Multiple Totals with AutoSum
6(2)
Quick calculations with AutoCalculate
Using Dates in Calculations
8(2)
Applying and creating custom number and date formats
Building a Conditional Formula with the IF Function
10(2)
Correcting circular references
Using Statistical Functions
12(2)
Using the COUNTA function
Calculating Payments with the PMT Function
14(2)
Calculating future value with the FV function
Displaying and Printing Formula Contents
16(2)
Setting margins and alignment when printing part of a worksheet
Concepts Review
18(1)
Skills Review
19(2)
Independent Challenges
21(3)
Visual Workshop
24
Glossary 1(5)
Index 6

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.