Microsoft Office Excel 2007 QuickSteps

( 3 )

Overview

Step-by-Step, Full-Color Graphics!

Get started using Microsoft Office Excel 2007 right away—the QuickSteps way. Color screenshots and clear instructions show you how to use all the new and improved features available in this premier spreadsheet program. Follow along and learn to work with the new Office interface and ribbon, create workbooks, use Excel's XML file formats, enter and edit data, use formulas and functions, create charts and tables, analyze data, and more. Plus, ...

See more details below
Paperback (New Edition)
$14.47
BN.com price
(Save 27%)$19.99 List Price
Other sellers (Paperback)
  • All (47) from $1.99   
  • New (6) from $4.98   
  • Used (41) from $1.99   
Sending request ...

Overview

Step-by-Step, Full-Color Graphics!

Get started using Microsoft Office Excel 2007 right away—the QuickSteps way. Color screenshots and clear instructions show you how to use all the new and improved features available in this premier spreadsheet program. Follow along and learn to work with the new Office interface and ribbon, create workbooks, use Excel's XML file formats, enter and edit data, use formulas and functions, create charts and tables, analyze data, and more. Plus, it's easy to flip straight to the information you need using the color-coded tabs. Get the book that gets you started using Excel 2007 in no time.

In each chapter:

  • Shortcuts for accomplishing common tasks
  • Need-to-know facts in concise narrative
  • Helpful reminders or alternate ways of doing things
  • Bonus information related to the topic being covered
  • Errors and pitfalls to avoid
Read More Show Less

Product Details

  • ISBN-13: 9780072263725
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 12/19/2006
  • Series: Quicksteps Series
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 224
  • Sales rank: 505,107
  • Product dimensions: 8.00 (w) x 10.00 (h) x 0.53 (d)

Meet the Author

John Cronan has been working with computers for more than 25 years. His books include eBay QuickSteps, Microsoft Office Excel 2003 QuickSteps, Microsoft Office Access 2007 QuickSteps, and others.

Read More Show Less

Table of Contents


Acknowledgments     iv
Introduction     xii
Stepping into Excel     1
Opening Excel     3
Get Started with Excel     3
Explore the Excel Window     3
Create a Workbook     3
Understanding the Ribbon     7
Open an Existing Workbook     7
Change the Appearance of New Workbooks     8
Customize the Quick Access Toolbar     10
Get Help     14
Open Help     15
Use the Excel Help Window     16
Understanding Excel's XML File Formats     18
Close Your Excel Workbook     18
Save a Workbook Automatically     18
Save a Workbook Manually     21
Save a Copy of Your Workbook     22
Add Identifying Information     22
Understanding Excel File Compatibility     24
Exit an Excel Session     24
Entering and Editing Data     25
Understanding Data Types     26
Enter Data     26
Enter Text     26
Enter Numeric Data     29
Completing an Entry     30
Enter Dates     30
Use Times     31
Formatting Numbers     32
Understanding Excel Dates and Times     34
Edit Data     35
Edit Cell Data     35
Adding Data Quickly     36
Remove Cell Contents     36
Copy and Paste Data     38
Selecting Cells and Ranges     39
Use Paste Special     39
Find and Replace Data     39
Verify Spelling     42
Modify Automatic Corrections     44
Formatting a Worksheet     45
Adding and Removing Rows, Colunms, and Cells     46
Work with Cells, Rows, and Columns     46
Adjust Row Height     46
Adjust Column Width     47
Hide and Unhide Rows and Columns     48
Change Cell Borders     49
Add a Comment     51
Formatting Comments     53
Apply Formatting     53
Understanding Excel Formatting     54
Apply Themes     54
Create Custom Themes     59
Searching for Themes     60
Use Cell Styles     60
Change Fonts     64
Change Alignment and Orientation     65
Add a Background     66
Transfer Formatting     68
Arrange and Organize Worksheets     69
Lock Rows and Columns     69
Split a Worksheet     71
Working with Worksheets     72
View Worksheets from Multiple Workbooks     72
Compare Workbooks     72
Using Formulas and Functions     75
Understanding Cell Referencing Types     76
Reference Cells     76
Change Cell References     76
Change to R1C1 References     76
Name Cells     77
Using Cell Reference Operators     79
Go to a Named Cell     79
Build Formulas     79
Create a Formula     79
Working with Cell Names     80
Edit a Formula     82
Move Formulas     83
Using Formulas     84
Copy Formulas     84
Recalculate Formulas     85
Use External References in Formulas     85
Understanding the Trust Center     87
Format Conditionally     91
Using Functions Quickly     95
Use Functions     95
Enter a Function     95
Enter a Sum in Columns or Rows Quickly      98
Find and Correct Errors     98
Check for Errors     98
Trace Precedent and Dependent Cells     100
Watch a Cell     100
Evaluate a Formula in Pieces     101
Viewing and Printing Data     103
Understanding Excel Views     104
Lay Out a Worksheet     104
Add Headers and Footers     104
Adding Content to Headers and Footers     109
Add Pictures to Headers and Footers     109
Change Margins     110
Select Page Orientation     112
Use Headers as Page Titles     112
Working with Zoom     114
Print the Data     115
Change the Order in Which Pages Print     115
Choosing Worksheet Print Options     116
Print Comments     116
Use Print Areas     116
Choosing What to Print     118
Preview the Print Job     119
Scale Your Data Before Printing     125
Output the Print Job     125
Charting Data     129
Building a Chart     131
Create and Design a Chart     131
Choose a Chart Type     131
Selecting Data for Charting      134
Choose a Chart Location     134
Modify How the Data Is Plotted     137
Apply a Chart Layout     139
Change a Chart's Style     140
Selecting Chart Elements     141
Modify Chart Elements     141
Add Titles     141
Show or Hide Axes     142
Add or Remove Gridlines     142
Identifying Chart Elements     143
Show or Hide a Legend     143
Add Data Labels     143
Display the Data Table     145
Create Your Own Chart Type     145
Add a Second Value Axis     146
Format Chart Elements     147
Working with Charts     148
Use Charts     149
Add Charts Elsewhere     149
Analyze Charts     150
Print a Chart     153
Working with Shapes and Pictures     155
Understanding Shapes     156
Add Shapes, Pictures, and Text     156
Add Shapes     156
Working with Curves     157
Insert Pictures     158
Using Pictures     163
Organize Pictures     163
Add Text     167
Use SmartArt      169
Changing SmartArt     171
Working with Shapes     171
Select, View, and Delete Shapes     171
Using Handles and Borders to Change Shapes     173
Crop Pictures     174
Position Shapes     175
Combining Shapes by Grouping     177
Formatting Shapes and Text     177
Use Styles     177
Apply Styling Elements to Pictures     178
Changing a Picture's Attributes     180
Change a Shape's Fill     180
Add WordArt Styling to Text     181
Make Detailed Formatting Changes     184
Managing Data     185
Understanding Excel Tables     186
Build Tables     186
Create a Table     186
Adding Rows and Columns to a Table     189
Delete Rows and Columns Within a Table     189
Add a Total Row     189
Apply Styles to a Table     190
Working with Tables     192
Validate Data     195
Locating Validation Data     197
Organize Data     198
Sort Data by Columns     199
Sort Data by Rows     202
Removing Filters      203
Create an AutoFilter     203
Setting Up Criteria and Extract Ranges     206
Use Advanced Filtering     206
Outline Data Automatically     207
Using Outlines     208
Outline Data by Manually Grouping     210
Add Subtotals     210
Add Styles to an Outline     211
Analyzing and Sharing Data     213
Get the Results You Want     213
Use Goal Seek     214
Compare Alternatives Using Scenarios     216
Use Multiple Variables to Provide a Result     219
Save Solver Results and Settings     222
Changing Solver Settings     224
Work with PivotTables     224
Create a PivotTable     224
Understanding PivotTable Terms     225
Create the PivotTable Layout     225
Style a PivotTable     229
Using PivotTables     231
Create a PivotTable Chart     231
Work with Other Users     234
Protect Workbooks with Passwords     234
Share a Workbook     235
Working with Changes in a Shared Workbook     237
Protect a Shared Workbook     237
Discontinue Sharing a Workbook     238
Work with Views     240
Protect Worksheet and Workbook Elements     241
Extending Excel     243
Acquire Data     244
Convert Text to Data     244
Add a Table from an Access Database     246
Get Data from the Web     247
Add External Data from Existing Connections     248
Setting External Data Range Properties     249
Manage Connections     249
Use Excel with Web Technology     252
Understanding the Difference Between Save and Publish     253
Save a Workbook as a Web Page     253
Publish Workbook Items as a Web Page     255
Understanding Excel Services     256
Use Hyperlinks     256
Automate Excel     260
Use Recorded Macros     260
Edit a Macro     262
Index     265
Read More Show Less

Customer Reviews

Average Rating 3.5
( 3 )
Rating Distribution

5 Star

(1)

4 Star

(1)

3 Star

(0)

2 Star

(1)

1 Star

(0)

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 3 Customer Reviews
  • Anonymous

    Posted March 10, 2009

    good learning

    explains things easily makes learning easier

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

    Posted April 24, 2009

    No text was provided for this review.

  • Anonymous

    Posted May 5, 2010

    No text was provided for this review.

Sort by: Showing all of 3 Customer Reviews

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