Microsoft Office Excel 2007 : Comprehensive Concepts and Techniques

by Shelly, Gary B.; Cashman, Thomas J.; Quasney, Jeffrey J.

• ISBN13: 9781418843441
• ISBN10: 141884344X
• Additional ISBN(s): 9781439079010 , 9781418848354
• Edition: 1st
• Format: Paperback
• Copyright: 2007-08-29
• Publisher: Cengage Learning

Summary

In Microsoft Excel 2007: Comprehensive Concepts and Techniques you?ll find features that are specifically designed to improve retention, and prepare readers for future success. Our trademark step-by-step, screen-by-screen approach now encourages readers to expand their understanding of the Access 2007 software through experimentation, exploration, and planning ahead.

Table of Contents

Creating a Worksheet and an Embedded Chart

Formulas, Functions, Formatting, and Web Queries

What-If Analysis, Charting, and Working with Large Worksheets Web Feature: Creating Static and Dynamic Web Pages Using Excel

Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks

Creating, Sorting, and Querying a Table

Creating Templates and Working with Multiple Worksheets and Workbooks Integration Feature: Object Linking and Embedding (OLE) and SmartArt Graphics

Using Macros and Visual Basic for Applications (VBA) with Excel

Formula Auditing, Data Validation, and Complex Problem Solving

Importing Data and Working with Pivot

Charts and Pivot

Tables Pivot

Table List Feature: Creating a Pivot

Table List Web Page Using Excel

Appendices

Project Planning Guidelines

Introduction to Microsoft Office 2007

Microsoft Excel Help

Publishing Office Web Pages to a Web Server

Customizing Excel

Microsoft Office Certification

Table of Contents provided by Publisher. All Rights Reserved.