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

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

by June Jamrich Parsons, Roy Ageloff, Patrick Carey, Dan Oja
     
 

ISBN-10: 0538745045

ISBN-13: 9780538745048

Pub. Date: 07/10/2009

Publisher: Cengage Learning

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

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.

Product Details

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

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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >