New Perspectives on Microsoft Office Excel 2007, Comprehensive, Premium Video Edition

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

• ISBN13: 9780538475594
• ISBN10: 0538475595
• Edition: DVD
• Format: Paperback
• Copyright: 2010-02-10
• Publisher: Cengage Learning

Summary

Market leading text, New Perspectives on Microsoft Office Excel 2007 now comes with video!

The tutorial videos focus on the most important or difficult concepts and skills, helping students better engage in and retain information. With the text's critical thinking, case-based approach students understand why they're learning what they're learning, and are prepared to easily transfer skills to new situations.

Table of Contents

Managing Your Files

Getting Started with Microsoft Office 2007

Getting Started with Excel

Formatting a Workbook

Working with Formulas and Functions

Working with Charts and Graphics

Working with Excel Tables, Pivot Tables, and Pivot Charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions, Conditional Formatting, and Filtering

Developing an Excel Application

Developing a Financial Analysis

Performing What-If Analyses

Connecting to External Data

Expanding Excel with Visual Basic for Applications

Additional Cases

Appendices

Working with Text Functions and Creating Custom Formats

Integrating Excel with Other Windows Programs

Creating a Shared Workbook

Working with Enhanced Formatting Tools

Table of Contents provided by Publisher. All Rights Reserved.