View Course Outline

Microsoft® Excel 2000 course, 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. This course meets MOUS certification objectives.

Course includes 5+ hours of total training time...

Microsoft Office 2000: Excel 2000

Microsoft® Excel 2000 course, 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. This course meets MOUS certification objectives.

• The Excel Environment
• Entering Values
• Managing Workbooks
• Formatting Cells
• Summarizing Numbers
• Creating Charts
• Printing
• Customizing Excel

• Managing References
• Named Ranges
• Manipulating Ranges
• Basic Functions
• Lookup Functions
• Financial Functions
• Considering Alternatives
• Enhanced Formatting
• Dynamic Formatting
• Graphical Objects

• Managing Workbooks
• Using Templates
• Sharing a Workbook
• Query a Database
• Working with Lists
• Working with Pivot Tables
• Excel and the Internet
• Creating Macros
• Preparing for Certification

back to top

Reed Jacobson is one of the top experts in the country on Microsoft products. Reed is the author of the best selling Microsoft Press book Excel Visual Basics Step by Step, which has been published in over 20 languages worldwide. He has been a featured presenter at Microsoft conferences in Orlando, New Orleans, Buenos Aires, and Kuala Lampur. Before becoming an author and consultant, Reed worked for ten years as a programmer for Hewlett-Packard. His years of training experience and programming background bring a profound insight to his training sessions.

back to top