Microsoft Office Excel 2007 Plain & Simple

Paperback (REV)
$17.55
BN.com price
(Save 29%)$24.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (28) from $1.99   
  • New (2) from $15.50   
  • Used (26) from $1.99   
Sending request ...

Overview

Here’s WHAT You’ll Learn

  • Easily navigate the new user interface
  • Ceate formulas and functions
  • Use charts and diagrams to display information visually
  • Enhance your spreadsheet with graphic effects
  • Reuse data from other Microsoft Office documents
  • Team up and share spreadsheets with colleagues

Here’s HOW You’ll Learn It

  • Jump in wherever you need answers
  • Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
  • Handy TIPS teach new techniques and shortcuts
  • Quick TRY THIS! exercises help you apply what you learn right away
Read More Show Less

Product Details

  • ISBN-13: 9780735622913
  • Publisher: Microsoft Press
  • Publication date: 2/14/2007
  • Series: Plain & Simple Series
  • Edition description: REV
  • Pages: 288
  • Sales rank: 656,652
  • Product dimensions: 9.10 (w) x 7.30 (h) x 0.60 (d)

Meet the Author

Curtis Frye is the author of numerous books on Excel and other Office products, most recently Microsoft Excel 2010 Step by Step. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

Read More Show Less

Table of Contents

Acknowledgments;
Chapter 1: Introduction: About This Book;
No Computerese!;
A Quick Overview;
A Few Assumptions;
A Final Word (or Two);
Chapter 2: What’s New in Excel 2007?;
Touring the New User Interface;
Arranging Data into Tables;
Introducing Galleries;
Using the Mini Toolbar;
Creating Formulas Using New Functions;
Using More Colors;
Creating Better Conditional Formats;
Creating More Attractive Charts;
Chapter 3: Getting Started with Excel 2007;
Surveying the Excel Screen;
Starting Excel;
Finding and Opening Existing Workbooks;
Using File Properties;
Creating a New Workbook;
Working with Multiple Workbooks;
Sizing and Viewing Windows;
Zooming In or Out on a Worksheet;
Viewing a Worksheet in Full Screen Mode;
Saving and Closing an Excel Workbook;
Using the Excel Help System;
Chapter 4: Building a Workbook;
Understanding How Excel Interprets Data Entry;
Navigating the Worksheet;
Selecting Cells;
Entering Text in Cells;
Entering Numbers in Cells;
Entering Dates and Times in Cells;
Entering Data with Other Shortcuts;
Creating a Data Table;
Editing Cell Contents;
Inserting a Symbol in a Cell;
Creating Hyperlinks;
Cutting, Copying, and Pasting Cell Values;
Undoing or Redoing an Action;
Finding and Replacing Text;
Checking the Spelling of Your Worksheet;
Chapter 5: Managing and Viewing Worksheets;
Viewing and Selecting Worksheets;
Renaming Worksheets;
Moving Worksheets;
Copying Worksheets;
Inserting and Deleting Worksheets;
Hiding or Showing a Worksheet;
Changing Worksheet Tab Colors;
Inserting, Moving, and Deleting Cells;
Inserting, Moving, and Deleting Columns and Rows;
Hiding and Unhiding Columns and Rows;
Entering Data and Formatting Many Worksheets at the Same Time;
Changing How You Look at Excel Workbooks;
Naming and Using Worksheet Views;
Chapter 6: Using Formulas and Functions;
Understanding Formulas and Cell References in Excel;
Creating Simple Cell Formulas;
Assigning Names to Groups of Cells;
Using Names in Formulas;
Creating a Formula that References Values in a Table;
Creating Formulas that Reference Cells in Other Workbooks;
Summing a Group of Cells without Using a Formula;
Creating a Summary Formula;
Summing with Subtotals and Grand Totals;
Exploring the Excel Function Library;
Using the IF Function;
Checking Formula References;
Debugging Your Formulas;
Chapter 7: Formatting the Worksheet;
Formatting Cell Contents;
Formatting Cells Containing Numbers;
Formatting Cells Containing Dates;
Adding Cell Backgrounds and Shading;
Formatting Cell Borders;
Defining Cell Styles;
Aligning and Orienting Cell Contents;
Formatting a Cell Based on Conditions;
Changing How Conditional Formatting Rules Are Applied;
Displaying Data Bars, Icon Sets, or Color Scales Based on Cell Values;
Copying Formats with the Format Painter;
Merging or Splitting Cells or Data;
Chapter 8: Formatting the Worksheet;
Applying Workbook Themes;
Coloring Sheet Tabs;
Changing a Worksheet’s Gridlines;
Changing Row Heights and Column Widths;
Inserting Rows or Columns;
Moving Rows and Columns;
Deleting Rows and Columns;
Outlining to Hide and Show Rows and Columns;
Hiding Rows and Columns;
Protecting Worksheets from Changes;
Locking Cells to Prevent Changes;
Chapter 9: Printing Worksheets;
Previewing Worksheets Before Printing;
Printing Worksheets with Current Options;
Choosing Whether to Print Gridlines and Headings;
Choosing Printers and Paper Options;
Printing Part of a Worksheet;
Printing Row and Column Headings on Each Page;
Setting and Changing Print Margins;
Setting Page Orientation and Scale;
Creating Headers and Footers;
Adding Graphics to a Header or a Footer;
Setting and Viewing Page Breaks;
Chapter 10: Customizing Excel to the Way You Work;
Opening Ready-to-Use Workbook Templates;
Saving a Workbook as a Template;
Adding Commands to the Quick Access Toolbar;
Controlling which Error Messages Appear;
Defining AutoCorrect and AutoFormat Entries;
Controlling Worksheet Gridline Appearance;
Chapter 11: Sorting and Filtering Worksheet Data;
Sorting Worksheet Data;
Creating a Custom Sort List;
Filtering Data Quickly with AutoFilter;
Creating an Advanced Filter;
Validating Data for Correctness during Entry;
Getting More out of Advanced Filters;
Finding Unique Values in a Data List;
Finding Duplicate Values in a Data List;
Chapter 12: Summarizing Data Visually Using Charts;
Displaying Data Graphically;
Creating a Chart Quickly;
Changing a Chart’s Appearance;
Formatting Chart Legends and Titles;
Changing the Body of a Chart;
Customizing Chart Data;
Working with Common Charts;
Working with Uncommon Charts;
Adding a Trendline to a Chart;
Chapter 13: Enhancing Your Worksheets with Graphics;
Working with Graphics in Your Worksheets;
Adding Graphics to Worksheets;
Adding Drawing Objects to a Worksheet;
Adding Fills to Drawing Objects;
Adding Effects to Drawing Objects;
Customizing Pictures and Objects;
Aligning and Grouping Drawing Objects;
Using WordArt to Create Text Effects in Excel;
Inserting Clip Art into a Worksheet;
Inserting and Changing a Diagram;
Creating an Organization Chart;
Chapter 14: Sharing Excel Data with Other Programs;
Introducing Linking and Embedding;
Linking and Embedding Other Files;
Exchanging Table Data between Excel and Word;
Copying Excel Charts and Data into PowerPoint;
Exchanging Data between Access and Excel;
Importing a Text File;
Chapter 15: Using Excel in a Group Environment;
Sharing Workbooks in Excel;
Commenting in Cells;
Tracking Changes in Workbooks;
Accepting or Rejecting Changes;
Saving Worksheets to the Web;
Dynamically Update Worksheets Published to the Web;
Retrieving Web Data from Excel;
Modifying Web Queries;
Introducing XML;
Interacting over the Web with XML;
Appendix : About the Author;
Appendix : Choose the Right Book for You;
Published and Upcoming Titles;

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
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted July 29, 2011

    No text was provided for this review.

  • Anonymous

    Posted March 8, 2011

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

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