Excel 2007 Just the Steps For Dummies

Overview

Just the steps you need to create spreadsheets, charts, and more

Simple steps...

...for great results

Create a Basic Chart

1.Select the data (sequential or nonsequential) you want to plot in the chart. See Figure 11-1 for an example of sequential data selected for a chart.

2.Press the F11 key. Excel immediately adds a new sheet called Chart ...

See more details below
Paperback
$12.50
BN.com price
(Save 16%)$14.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (40) from $1.99   
  • New (16) from $2.85   
  • Used (24) from $1.99   
Sending request ...

Overview

Just the steps you need to create spreadsheets, charts, and more

Simple steps...

...for great results

Create a Basic Chart

1.Select the data (sequential or nonsequential) you want to plot in the chart. See Figure 11-1 for an example of sequential data selected for a chart.

2.Press the F11 key. Excel immediately adds a new sheet called Chart 1 to your workbook with the data plotted into a column chart. Figure 11-2 shows you the various elements that can make up a chart

Some newer keyboards use a different function for the F11 key. If your F11 key does not produce a chart, use the Insert tab as explained in the next section.

  • Title: A descriptive name for the overall chart. By default, titles are not added in a basic chart.
  • X or Category axis: Column or row headings from your selected data, which Excel uses for Category axis names.
  • X Axis Title: A descriptive name for the Category axis. By default, a category label is not added in a basic chart.

Get ready to

  • Enter data into a spreadsheet
  • Build formulas and functions
  • Format cells and add graphics
  • Sort and analyzedata
  • Create charts andPivotTables
  • Blend Excel intoPowerPoint®
Read More Show Less

Product Details

  • ISBN-13: 9780470039212
  • Publisher: Wiley
  • Publication date: 2/19/2007
  • Series: For Dummies Series
  • Edition number: 1
  • Pages: 240
  • Sales rank: 1,388,091
  • Product dimensions: 7.20 (w) x 9.20 (h) x 0.60 (d)

Table of Contents


Introduction     1
Putting Excel to Work     3
Working with Excel Files     5
Entering Spreadsheet Data     15
Building Formulas     27
Protecting Excel Data     37
Sprucing Up Your Spreadsheets     45
Formatting Cells     47
Applying Additional Formatting Options     55
Designing with Graphics     63
Managing Workbooks     73
Viewing Data in Different Ways     81
Changing Worksheet Views     83
Sorting Data     91
Creating Charts     101
Printing Workbooks     113
Analyzing Data with Excel     123
Working with Outlines     125
Filtering Data     135
Creating PivotTables     145
Building Simple Macros     157
Saving Time with Excel Tools     163
Utilizing Excel with Other People and Applications     169
Collaborating in Excel     171
Integrating Excel into Word     177
Blending Excel and PowerPoint     185
Using Excel with Access     191
Practical Applications for Excel     199
Designing an Organization Chart     201
Creating a Commission Calculator     209
Tracking Medical Expenses     215
Planning for Your Financial Future     223
Index     227
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

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

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