Microsoft Office Excel 2003 Quicksteps

( 5 )

Overview

Learn Instantly from Step-by-Step Graphics!

We know a picture is worth a thousand words—so we went heavy on pictures and light on words in this easy-to-use guide. Color screenshots and brief instructions show you how to use Excel’s number-crunching features in no time. Follow along and learn to enter and format data, calculate with functions and formulas, create charts and graphs, analyze data, and more. Each chapter’s “How to” list and color-coded tabs make it easy to flip ...

See more details below
Paperback
$14.68
BN.com price
(Save 26%)$19.99 List Price
Other sellers (Paperback)
  • All (66) from $1.99   
  • New (7) from $1.99   
  • Used (59) from $1.99   
Sending request ...

Overview

Learn Instantly from Step-by-Step Graphics!

We know a picture is worth a thousand words—so we went heavy on pictures and light on words in this easy-to-use guide. Color screenshots and brief instructions show you how to use Excel’s number-crunching features in no time. Follow along and learn to enter and format data, calculate with functions and formulas, create charts and graphs, analyze data, and more. Each chapter’s “How to” list and color-coded tabs make it easy to flip straight to the tasks you need to do. Get the book that gets you started using Excel right away.

In Each Chapter:

  • Shortcuts for accomplishing common tasks
  • Helpful reminders or alternate ways of doing things
  • Bonus information related to the topic being covered
  • Errors and pitfalls to avoid
  • Screenshots with captions show and explain exactly what you’ll see on your computer screen while you’re doing a task

John Cronan has more than 18 years of computing experience. He has worked on more than 20 books, including Windows XP: A Beginner’s Guide, FrontPage 2003: The Complete Reference, Excel for Windows 98 Made Easy, and Office 2000 Answers: Certified Tech Support.

Read More Show Less

Product Details

  • ISBN-13: 9780072232288
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 1/27/2004
  • Series: Quicksteps Series
  • Edition number: 1
  • Pages: 224
  • Product dimensions: 7.90 (w) x 9.90 (h) x 0.45 (d)

Meet the Author

Series editors Martin and Carole Matthews each have more than thirty years of computing experience. They have written 57 U.S. editions of 32 titles, a number of which have been critically acclaimed. Among their more recent books are: Windows XP, A Beginner’s Guide; FrontPage 2002: The Complete Reference; Windows 2000, A Beginner’s Guide; Office 2000 Answers, Certified Tech Support; Windows 98 Companion; and Windows 98 Answers, Certified Tech Support.

Read More Show Less

Table of Contents

Acknowledgments xv
Introduction xvii
Chapter 1 Stepping into Excel 1
Start Excel 1
Use the Start Menu to Load Excel 1
Starting Excel 3
Open a Workbook 4
Opening a Workbook 5
Add Identifying Information 5
Find a Workbook 6
Using Task Panes 7
Personalize Excel 7
Remove the Getting Started Task Pane 7
Select a Toolbar to Display 7
Show Toolbars on Two Rows 8
Customize a Toolbar 8
Using Toolbars 10
Get Help 10
Open Help 10
Using Help 11
Do Research 11
End Your Excel Workbook 12
Save a Workbook Automatically 12
Save a Workbook Manually 12
Save a Copy of Your Workbook 13
Save a Workbook As a Template 14
Close an Excel Session 14
Chapter 2 Entering and Editing Data 15
Enter Data 15
Enter Text 17
Completing an Entry 18
Enter Numeric Data 18
Enter Dates 19
Formatting Numbers 20
Use Times 22
Adding Data Quickly 24
Edit Data 24
Edit Cell Data 24
Remove Cell Contents 25
Selecting Cells and Ranges 26
Copy and Paste Data 27
Use Paste Special 27
Find and Replace Data 28
Verify Spelling 30
Modify Automatic Corrections 31
Chapter 3 Formatting a Worksheet 33
Work with Cells, Rows, and Columns 33
Adding and Removing Rows, Columns, and Cells 34
Adjust Row Height 34
Adjust Column Width 35
Hide and Unhide Rows and Columns 36
Change Cell Borders 37
Add a Background 39
Add a Comment 40
Change How Text Looks 40
Use Fonts 40
Using Comments 41
Change Alignment and Orientation 42
Use Styles 44
Transfer Formatting 45
Format Automatically 46
Format Conditionally 47
Arrange and Organize Worksheets 48
Lock Rows and Columns 48
Split a Worksheet 49
View Worksheets from Multiple Workbooks 49
Working with Worksheets 50
Chapter 4 Using Formulas and Functions 51
Reference Cells 51
Change Cell References in Formulas 52
Change to R1C1 References 53
Using Cell Reference Operators 54
Name a Cell 54
Go to a Named Cell 54
Build Formulas 54
Create a Formula 55
Edit a Formula 56
Move Formulas 57
Copy Formulas 57
Using Formulas 58
Recalculate Formulas 58
Use External References in Formulas 59
Use Functions 60
Enter a Function 61
Using Functions 63
Sum Numbers in Columns or Rows Quickly 63
Find and Correct Errors 63
Check for Errors 64
Trace Precedent and Dependent Cells 64
Watch a Cell 65
Evaluate a Formula in Pieces 66
Chapter 5 Printing Data 67
Set Up the Print Job 67
Add Headers and Footers 68
Formatting Headers and Footers 70
Add Pictures to Headers and Footers 70
Adjust Margins 71
Select Page Orientation and Scaling 72
Use Headings as Page Titles 73
Choosing Worksheet Print Options 74
Change the Order Pages Print 74
Print Comments 74
Choosing What to Print 75
Print the Data 75
Use Print Areas 75
Preview the Print Job 76
Output the Print Job 80
Chapter 6 Charting Data 83
Build a Chart with the Chart Wizard 85
Start the Chart Wizard 85
Choose a Chart Type 86
Select Data for Charting 87
Modify Chart Items 90
Choose a Chart Location 90
Modify Existing Charts 92
Create a Chart from the Chart Toolbar 92
Selecting Chart Items 93
Identify Items 93
Add Titles 94
Show or Hide Axes 95
Add or Remove Gridlines 95
Show or Hide a Legend 96
Add Data Labels 97
Display the Data Table 97
Format Chart Items 98
Add a Second Value Axis 99
Create Your Own Chart Type 100
Working with Charts 101
Use Charts 101
Add Pictures and Text 101
Add a Trendline 103
Print a Chart 104
Work with Pie Charts 105
Chapter 7 Working with Graphics 107
Add Graphics 107
Add Pictures 109
Organize Clip Art 112
Use Clip Art 113
Add AutoShapes 115
Add Objects from Other Programs 115
Working with Curves 116
Add Special Effects to Text 118
Create a Diagram 119
Format and Modify Graphics 121
Use Color Effects 121
Using Handles and Borders to Change Graphics 122
Resize and Rotate a Graphic 124
Trim a Picture 125
Positioning Graphics 126
Combine Graphics by Grouping 126
Create a Mirrored Image 127
Keep Changes Intact 127
Chapter 8 Managing Data 129
Build Lists 129
Create a List 130
Adding Rows and Columns to a List 131
Enter and Manage Data Using a Form 132
Locating Data Using a Form 134
Add a Total Row 134
Remove a List 134
Validate Data 136
Organize Data 139
Sort Data by Columns 139
Sort Data by Rows 140
Create an AutoFilter 141
Removing Filters 142
Outline Data Automatically 142
Outline Data by Grouping 143
Add Styles to an Outline 143
Using Outlines 144
Acquire Data 144
Convert Text to Data 144
Add All Data from an Access Table 147
Add Selective Data from an Access Table 147
Get Data from the Web 150
Change External Data 151
Setting External Data Range Properties 152
Chapter 9 Analyzing and Sharing Data 153
Get the Results You Want 153
Use Goal Seek 154
Compare Alternatives Using Scenarios 156
Use Multiple Variables to Provide a Result 160
Save Solver Results and Settings 162
Changing Solver Settings 164
Work with PivotTables 164
Create a PivotTable 165
Create the PivotTable Layout 166
Using PivotTables 167
Create a PivotTable Chart 168
Work with Others 169
Guard Workbooks with Passwords 169
Using Passwords in a Shared Workbook 170
Share a Workbook 170
Merge Shared Workbooks 172
Working with Changes in a Shared Workbook 173
Protect a Shared Workbook 173
Work with Views 174
Protect Non-Shared Workbooks and Worksheets 175
Chapter 10 Extending Excel 177
Use Excel with Web Technology 177
Save or Publish a Workbook as a Web Page 178
Save Workbook Items as a Web Page 182
Publish Workbook Items 182
Using Excel Interactive Web Pages 183
Keep Web Pages Updated 183
Package Excel Web Files 183
Use Hyperlinks 186
Plan for the Future 190
Automate Excel 191
Use Recorded Macros 191
Edit a Macro 195
Starting a Macro 196
Communicate with Excel 196
Listen to Excel 196
Tell Excel What to Do 196
Index 199
Read More Show Less

Customer Reviews

Average Rating 3
( 5 )
Rating Distribution

5 Star

(1)

4 Star

(1)

3 Star

(1)

2 Star

(1)

1 Star

(1)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 5 Customer Reviews
  • Anonymous

    Posted June 21, 2005

    Great Tool

    I don¿t use Excel all the time. But when I do, I don¿t have time to troubleshoot problems. This hands-on, user friendly book has helped me conquer Excel. The text is readable and well organized. The visuals are clean and fully support the instructions. I found that you can start from the beginning and teach yourself EXCEL with simple step by step instructions or you can flip straight to your topic of interest and further build your skills. This is a great tool for all levels of expertise.

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted February 17, 2010

    No text was provided for this review.

  • Anonymous

    Posted February 5, 2011

    No text was provided for this review.

  • Anonymous

    Posted March 4, 2009

    No text was provided for this review.

  • Anonymous

    Posted August 23, 2009

    No text was provided for this review.

Sort by: Showing all of 5 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)