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

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

• ISBN13: 9780538745048
• ISBN10: 0538745045
• Edition: 1st
• Format: Digital
• Copyright: 2009-07-10
• Publisher: Cengage Learning

Summary

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.

Table of Contents

Getting Started with Excel

Understanding Spreadsheets

Planning a Workbook

Working with Formulas

Introducing Functions

Formatting a Workbook

Formatting Data

Formatting Worksheet Cells

Working with Table Styles

Introducing Conditional Formats

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

Working with Charts and Graphics

Creating Charts

Working on Chart Design

Creating a Column Chart

Creating a Line Chart

Working with Excel Tables, PivotTables, and PivotCharts

Creating an Excel Table

Sorting Data

Filtering Data

Analyzing Data with PivotTables

Managing Multiple Worksheets and Workbooks

Grouping Worksheets

Using 3-D References to Add Values Across Worksheets

Linking Workbooks

Creating a Custom Workbook Template

Using Advanced Functions, Conditional Formatting, and Filtering

Creating Nested IF Functions

Using Lookup Tables and Functions

Summarizing Data Conditionally

Using Advanced Filtering

Developing an Excel Application

Naming Cells and Ranges

Validating Data Entry

Protecting a Worksheet and Workbook

Recording a Macro

Developing a Financial Analysis

Working with Loans and Mortgages

Projecting Future Income and Expenses

Auditing a Workbook

Performing What-If Analyses

Working with What-If Analysis and Goal Seek

Using Scenario Manager

Finding an Optimal Solution Using Solver

Connecting to External Data

Working with Text Files

Using the Query Wizard

Creating a Web Query

Expanding Excel with Visual Basic for Applications

Working with the Visual Basic Editor

Retrieving Information from the User

Creating a Message Box

Table of Contents provided by Publisher. All Rights Reserved.