Excel 2000

Excel 2000 series, expert Reed Jacobson guides you through spreadsheet fundamentals and provides inside tips for powerful business applications. You'll learn formatting, summarizing, and charting methods, along with some little-known techniques that will help you get up to speed and working efficiently.

Excel 2000 Session 1

· Introduction

· Entering Values

· Managing Workbooks

· Creating a Form or Document

· Summarizing Numbers

· Formatting Numbers

· Creating Charts

· Customizing Excel

· Discovering More

Excel 2000 Session 2

· Managing References

· Manipulating Ranges

· Lookup Functions

· Considering Alternatives

· Dynamic Formatting

· Named Ranges

· Basic Functions

· Financial Functions

· Enhanced Formatting

· Graphical Objects

Excel 2000 Session 3

· Managing Workbooks

· Using Templates

· Query a Database

· Working with Pivot Tables

· Creating Macros

· Sharing a Woorkbook

· Working with Lists

· Excel and the Internet

· Preparing for Certification

Reed Jacobson is one of the top experts on Microsoft Excel. He is the author of the best selling Microsoft Press book, Excel Visual Basic Step by Step. Reed worked as a programmer for Hewlett-Packard for ten years before becoming a consultant, specializing in Microsoft Excel, Visual Basic, and other Microsoft Office products