Synopses & Reviews
Part of our New Perspectives Series, this text offers a case-based, problem-solving approach to learning the more advanced features of this powerful spreadsheet. This more technical text provides a quick review of the basics before moving on to cover macros, VBA, and more.
Synopsis
Part of our New Perspectives Series, this text offers a case-based, problem-solving approach to learning the more advanced features of Microsoft Excel 2000. The second half of the text offers extensive coverage of VBA in Excel 2000.
About the Author
Lisa Friedrichsen is a Professor at Johnson County Community College in Overland Park, Kansas where she teaches database and Web-related classes. As an author, Lisa has written several Access, Office, and Web-related textbooks. Lisa has developed many relational database systems in the fields of marketing, healthcare, and education.
Table of Contents
Tutorial 1: Using Excel as a Decision Support Tool Tutorial 2: Using Excel as a List Management Tool Tutorial 3: Using Excel Charts to Make Business Decisions Tutorial 4: Using Excel for Advanced Charting Tutorial 5: Troubleshooting Formulas and Using Advanced Functions Tutorial 6: Introduction to Visual Basic for Applications Using Excel Tutorial 7: Creating Custom Functions Tutorial 8: Creating Custom Forms Tutorial 9: Examining Variables and Ranges and Controlling Code Execution Tutorial 10: Sharing Excel Data with Other Programs