GO! with Microsoft Office Excel 2003 Comprehensive and Student CD Package

by Gaskin, Shelley; Ferrett, Robert L.; Preston, John; Preston, Sally

• ISBN13: 9780132437714
• ISBN10: 0132437716
• Edition: 1st
• Format: Paperback
• Copyright: 2004-01-01
• Publisher: Prentice Hall

Summary

Written for a diverse audience (all ages, different educational backgrounds, varying educational goals), this book allows for self-paced or online learning. The primary goal ofGO! Series: Microsoft Excel 2003 Comprehensiveis to teach Microsoft Excel 2003 quickly and easily, with an approach that is based on clearly-defined projects. A key feature of the book is the use of Microsoft procedural syntax: steps begin withwherethe action is to take place, followed by the action itself. The instruction is error-free, clearly written, and logically arranged. This book provides users with the skills to solve business problems using the computer as a tool.Combining all of the material of Volumes 1 and 2 of the series, the Comprehensive edition covers: getting started, with Excel; creating a workbook with formulas; advanced formulas, functions, and charting; customizing a workbook; adding logic and protecting the workbook; checking work and working with others; advanced formatting and functions; using database capabilities in Excel; integrating Excel with other office applications; PivotTables and PivotCharts; customized Excel with macros; and visual basic for applications.An efficient and handy guide for anyone interested in learning the ins and outs of Microsoft Excel 2003.

Table of Contents

Getting Started with Excel 2003

Editing Workbooks, Formulas, and Cells

Formatting a Worksheet

Ranges and Functions

Creating Charts and Diagrams

Working with Templates, Large Worksheets, and other File Formats

Creating Templates, Using Lookup Functions and Data Validation, and Auditing Worksheets

Using Database Capabilities in Excel

Using What If Analysis Tools

Advanced Excel Analysis Tools

Macros and Visual Basic for Applications

Collaborating With Others (XML)

Table of Contents provided by Publisher. All Rights Reserved.