Microsoft Office Excel 2003 Quicksteps / Edition 1

Microsoft Office Excel 2003 Quicksteps / Edition 1

3.0 5
by John Cronan, Roger Stewart
     
 

ISBN-10: 0072232285

ISBN-13: 9780072232288

Pub. Date: 01/27/2004

Publisher: McGraw-Hill Professional Publishing

Brace youself, because here comes QuickSteps: The fast, easy, accessible information on Excel 2003 in a full-color cookbook-style format. Provides answers to all of your How-do-I questions in a concise and meaningful way. Lengthwise page layout allows for easy page viewing. Useful tips and cautions are displayed in the margins so that they don’t break the

Overview

Brace youself, because here comes QuickSteps: The fast, easy, accessible information on Excel 2003 in a full-color cookbook-style format. Provides answers to all of your How-do-I questions in a concise and meaningful way. Lengthwise page layout allows for easy page viewing. Useful tips and cautions are displayed in the margins so that they don’t break the flow of the quick steps themselves.

Product Details

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

Table of Contents

Acknowledgmentsxv
Introductionxvii
Chapter 1Stepping into Excel1
Start Excel1
Use the Start Menu to Load Excel1
Starting Excel3
Open a Workbook4
Opening a Workbook5
Add Identifying Information5
Find a Workbook6
Using Task Panes7
Personalize Excel7
Remove the Getting Started Task Pane7
Select a Toolbar to Display7
Show Toolbars on Two Rows8
Customize a Toolbar8
Using Toolbars10
Get Help10
Open Help10
Using Help11
Do Research11
End Your Excel Workbook12
Save a Workbook Automatically12
Save a Workbook Manually12
Save a Copy of Your Workbook13
Save a Workbook As a Template14
Close an Excel Session14
Chapter 2Entering and Editing Data15
Enter Data15
Enter Text17
Completing an Entry18
Enter Numeric Data18
Enter Dates19
Formatting Numbers20
Use Times22
Adding Data Quickly24
Edit Data24
Edit Cell Data24
Remove Cell Contents25
Selecting Cells and Ranges26
Copy and Paste Data27
Use Paste Special27
Find and Replace Data28
Verify Spelling30
Modify Automatic Corrections31
Chapter 3Formatting a Worksheet33
Work with Cells, Rows, and Columns33
Adding and Removing Rows, Columns, and Cells34
Adjust Row Height34
Adjust Column Width35
Hide and Unhide Rows and Columns36
Change Cell Borders37
Add a Background39
Add a Comment40
Change How Text Looks40
Use Fonts40
Using Comments41
Change Alignment and Orientation42
Use Styles44
Transfer Formatting45
Format Automatically46
Format Conditionally47
Arrange and Organize Worksheets48
Lock Rows and Columns48
Split a Worksheet49
View Worksheets from Multiple Workbooks49
Working with Worksheets50
Chapter 4Using Formulas and Functions51
Reference Cells51
Change Cell References in Formulas52
Change to R1C1 References53
Using Cell Reference Operators54
Name a Cell54
Go to a Named Cell54
Build Formulas54
Create a Formula55
Edit a Formula56
Move Formulas57
Copy Formulas57
Using Formulas58
Recalculate Formulas58
Use External References in Formulas59
Use Functions60
Enter a Function61
Using Functions63
Sum Numbers in Columns or Rows Quickly63
Find and Correct Errors63
Check for Errors64
Trace Precedent and Dependent Cells64
Watch a Cell65
Evaluate a Formula in Pieces66
Chapter 5Printing Data67
Set Up the Print Job67
Add Headers and Footers68
Formatting Headers and Footers70
Add Pictures to Headers and Footers70
Adjust Margins71
Select Page Orientation and Scaling72
Use Headings as Page Titles73
Choosing Worksheet Print Options74
Change the Order Pages Print74
Print Comments74
Choosing What to Print75
Print the Data75
Use Print Areas75
Preview the Print Job76
Output the Print Job80
Chapter 6Charting Data83
Build a Chart with the Chart Wizard85
Start the Chart Wizard85
Choose a Chart Type86
Select Data for Charting87
Modify Chart Items90
Choose a Chart Location90
Modify Existing Charts92
Create a Chart from the Chart Toolbar92
Selecting Chart Items93
Identify Items93
Add Titles94
Show or Hide Axes95
Add or Remove Gridlines95
Show or Hide a Legend96
Add Data Labels97
Display the Data Table97
Format Chart Items98
Add a Second Value Axis99
Create Your Own Chart Type100
Working with Charts101
Use Charts101
Add Pictures and Text101
Add a Trendline103
Print a Chart104
Work with Pie Charts105
Chapter 7Working with Graphics107
Add Graphics107
Add Pictures109
Organize Clip Art112
Use Clip Art113
Add AutoShapes115
Add Objects from Other Programs115
Working with Curves116
Add Special Effects to Text118
Create a Diagram119
Format and Modify Graphics121
Use Color Effects121
Using Handles and Borders to Change Graphics122
Resize and Rotate a Graphic124
Trim a Picture125
Positioning Graphics126
Combine Graphics by Grouping126
Create a Mirrored Image127
Keep Changes Intact127
Chapter 8Managing Data129
Build Lists129
Create a List130
Adding Rows and Columns to a List131
Enter and Manage Data Using a Form132
Locating Data Using a Form134
Add a Total Row134
Remove a List134
Validate Data136
Organize Data139
Sort Data by Columns139
Sort Data by Rows140
Create an AutoFilter141
Removing Filters142
Outline Data Automatically142
Outline Data by Grouping143
Add Styles to an Outline143
Using Outlines144
Acquire Data144
Convert Text to Data144
Add All Data from an Access Table147
Add Selective Data from an Access Table147
Get Data from the Web150
Change External Data151
Setting External Data Range Properties152
Chapter 9Analyzing and Sharing Data153
Get the Results You Want153
Use Goal Seek154
Compare Alternatives Using Scenarios156
Use Multiple Variables to Provide a Result160
Save Solver Results and Settings162
Changing Solver Settings164
Work with PivotTables164
Create a PivotTable165
Create the PivotTable Layout166
Using PivotTables167
Create a PivotTable Chart168
Work with Others169
Guard Workbooks with Passwords169
Using Passwords in a Shared Workbook170
Share a Workbook170
Merge Shared Workbooks172
Working with Changes in a Shared Workbook173
Protect a Shared Workbook173
Work with Views174
Protect Non-Shared Workbooks and Worksheets175
Chapter 10Extending Excel177
Use Excel with Web Technology177
Save or Publish a Workbook as a Web Page178
Save Workbook Items as a Web Page182
Publish Workbook Items182
Using Excel Interactive Web Pages183
Keep Web Pages Updated183
Package Excel Web Files183
Use Hyperlinks186
Plan for the Future190
Automate Excel191
Use Recorded Macros191
Edit a Macro195
Starting a Macro196
Communicate with Excel196
Listen to Excel196
Tell Excel What to Do196
Index199

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Microsoft Office Excel 2003 Quicksteps 3 out of 5 based on 0 ratings. 4 reviews.
Guest More than 1 year ago
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.
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago