New Perspectives on Microsoft Office Excel 2007, Comprehensive Video Companion DVD / Edition 1

Other Format (Print)
Buy Used
Buy Used from BN.com
$83.21
(Save 25%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 98%)
Other sellers (Other Format)
  • All (6) from $1.99   
  • New (1) from $75.31   
  • Used (5) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$75.31
Seller since 2008

Feedback rating:

(1762)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
2009 DVD-ROM New Ships out next day, click expedited for faster shipping.

Ships from: cadiz, KY

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by

Overview

Learn and retain the most challenging and important topics of Microsoft Office Excel 2007 using a medium that you probably use daily: video! NEW PERSPECTIVES ON MICROSOFT OFFICE EXCEL 2007, COMPREHENSIVE, VIDEO COMPANION contains 45 illustrative videos between 5-7 minutes in length that go beyond simply showing how to complete tasks. Each video begins with a conceptual explanation and then is followed by a practical demonstration of that skill within the application. This video companion maps directly to the New Perspectives on Microsoft Office Excel 2007, Comprehensive textbook.

Read More Show Less

Product Details

  • ISBN-13: 9780538745048
  • Publisher: Cengage Learning
  • Publication date: 7/10/2009
  • Series: New Perspectives Series
  • Edition description: New Edition
  • Edition number: 1
  • Product dimensions: 5.60 (w) x 8.40 (h) x 0.70 (d)

Meet the Author

June Parsons and Dan Oja purchased their first computer, an Apple II+, in 1981 and quickly became fluent in BASIC, dBASE II, Lotus 123, WordStar, and a variety of accounting programs. The next year, they opened a successful small computer retail store that also offered software instruction to children and adults. June taught at the university level for more than 20 years, has a doctorate in Educational Technology, and was certified by the ICCP in 1995. June and Dan began writing and creating educational software for Course Technology in 1992. They contributed to the Windows for Business and Illustrated Series and developed the New Perspectives, e-Course, and Practical series. They work via the Internet with a team of highly skilled media specialists and desktop publishers located in various states and provinces.

June Parsons and Dan Oja purchased their first computer, an Apple II+, in 1981 and quickly became fluent in BASIC, dBASE II, Lotus 123, WordStar, and a variety of accounting programs. The next year, they opened a successful small computer retail store that also offered software instruction to children and adults. June taught at the university level for more than 20 years, has a doctorate in Educational Technology, and was certified by the ICCP in 1995. June and Dan began writing and creating educational software for Course Technology in 1992. They contributed to the Windows for Business and Illustrated Series and developed the New Perspectives, e-Course, and Practical series. They work via the Internet with a team of highly skilled media specialists and desktop publishers located in various states and provinces.

Roy Ageloff has taught courses in computer programming, database design and development, accounting information systems, and office productivity software at the University of Rhode Island and has written textbooks in programming languages, database software, and spreadsheet applications. He is a business consultant and teacher at Paradise Valley Community College, Arizona.

Patrick Carey received his M.S. in Biostatistics from the University of Wisconsin, where he worked as a researcher designing and analyzing clinical studies. He co-authored his first textbook on using Excel as a statistical tool. Patrick has authored or co-authored over 20 academic and trade texts for the software industry.

Read More Show Less

Table of Contents


Tutorial 1: Getting Started with Excel. Understanding Spreadsheets. Planning a Workbook. Working with Formulas. Introducing Functions. Tutorial 2: Formatting a Workbook. Formatting Data. Formatting Worksheet Cells. Working with Table Styles. Introducing Conditional Formats. Tutorial 3: Working with Formulas and Functions. Understanding Cell References When Copying Formulas. Understanding Function Syntax. Working with AutoFill. Working with Logical Functions. Working with Financial Functions. Tutorial 4: Working with Charts and Graphics. Creating Charts. Working on Chart Design. Creating a Column Chart. Creating a Line Chart. Tutorial 5: Working with Excel Tables, PivotTables, and PivotCharts. Creating an Excel Table. Sorting Data. Filtering Data. Analyzing Data with PivotTables. Tutorial 6: Managing Multiple Worksheets and Workbooks. Grouping Worksheets. Using 3-D References to Add Values Across Worksheets. Linking Workbooks. Creating a Custom Workbook Template. Tutorial 7: Using Advanced Functions, Conditional Formatting, and Filtering. Creating Nested IF Functions. Using Lookup Tables and Functions. Summarizing Data Conditionally. Using Advanced Filtering. Tutorial 8: Developing an Excel Application. Naming Cells and Ranges. Validating Data Entry. Protecting a Worksheet and Workbook. Recording a Macro. Tutorial 9: Developing a Financial Analysis. Working with Loans and Mortgages. Projecting Future Income and Expenses. Auditing a Workbook. Tutorial 10: Performing What-If Analyses. Working with What-If Analysis and Goal Seek. Using Scenario Manager. Finding an Optimal Solution Using Solver. Tutorial 11: Connecting to External Data. Working with Text Files. Using the Query Wizard. Creating a Web Query. Tutorial 12: Expanding Excel with Visual Basic for Applications. Working with the Visual Basic Editor. Retrieving Information from the User. Creating a Message Box.
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)