Synopses & Reviews
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 of GO! Series: Microsoft Excel 2003 Volume 2 is 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 with where the 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. Volume 2 takes up where Volume 1 leaves off, covering the following topics: 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 with a basic knowledge of Microsoft Excel 2003 that is interested in delving deeper into the subject.
About the Author
Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.
Table of Contents
7. Creating Templates, Using Lookup Functions and Data Validation, and Auditing Worksheets.
8. Using Database Capabilities in Excel.
9. Using What If Analysis Tools
10. Advanced Excel Analysis Tools.
11. Collaborating with Others
12. Customizing Excel.