This is Real Life Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Interviews | March 9, 2015

    Rhianna Walton: IMG Erik Larson: The Powells.com Interview



    Erik LarsonI've been a fan of Erik Larson's riveting brand of narrative history for years, and his latest book, Dead Wake: The Last Crossing of the Lusitania,... Continue »
    1. $19.60 Sale Hardcover add to wish list

    spacer

This item may be
out of stock.

Click on the button below to search for this title in other formats.


Check for Availability
Add to Wishlist

Other titles in the New Perspectives series:

New Perspectives on Microsoft Office Excel 2007, Comprehensive Video Companion DVD (New Perspectives)

New Perspectives on Microsoft Office Excel 2007, Comprehensive Video Companion DVD (New Perspectives) Cover

 

Synopses & Reviews

Publisher Comments:

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.

About 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.

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.

Product Details

ISBN:
9780538745048
Publisher:
Cengage Learning
Subject:
Spreadsheets - General
Author:
Parsons, June Jamrich
Author:
Carey, Patrick
Author:
Oja, Dan
Author:
Parsons, June Jamrich (June Jamrich Parsons)
Author:
Ageloff, Roy
Subject:
Excel;video;companion;microsoft;office;spreadsheet;DVD;Excel 2007;Premium Video Edition;Office 2007;Parsons;Oja;Ageloff;Carey;Video Companion
Subject:
Excel
Subject:
Video
Subject:
Companion
Subject:
Microsoft
Subject:
Office
Subject:
spreadsheet
Subject:
DVD
Subject:
Excel 2007
Subject:
premium video edition
Subject:
office 2007
Subject:
Parsons
Subject:
Oja
Subject:
Ageloff
Subject:
Carey
Subject:
Video Companion
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Series:
New Perspectives
Publication Date:
20090710
Binding:
Digital or multimedia (detail unspecified)
Language:
English
Dimensions:
7.60x4.80x.50 in. .20 lbs.
Age Level:
Ageloff

Related Subjects

Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

New Perspectives on Microsoft Office Excel 2007, Comprehensive Video Companion DVD (New Perspectives)
0 stars - 0 reviews
$ In Stock
Product details pages Course Technology - English 9780538745048 Reviews:
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.