Audience

Application developers responsible for developing custom Microsoft Office 2000 solutions

Prerequisites

Knowledge of the preceding SmartCourse in the MicrosoftOffice 2000 - Solution Development SmartCurriculum; knowledge of the basic features of Microsoft Word, Excel, Access, and PowerPoint; familiarity with recording macros; an understanding of object properties, methods, and fundamental programming constructs such as looping statements; familiarity with basic database concepts and web browsing would also be beneficial

Course Aim

To give the student the skills to develop custom applications using the tools provided by Excel

Learning Objectives

Describe the Excel object model and include Excel functionality in custom applications. Create and modify workbooks and worksheets programmatically. Write code to reference and format cells on a worksheet. Return and work with a range object. Create a chart from worksheet data programmatically. Analyze data from a workbook. Programmatically create and modify a PivotTable. Publish documents as HTML. Work with the Excel event model. Publish Excel components on web pages.

Topics Covered

Working with Excel objects - Storing code for Excel solutions - The Excel object model - Application events - Working with workbooks - Working with worksheets - Hands-on: Creating a workbook with a worksheet The Range object - Returning a range object - Working with ranges - Hands-on: Working with a range object - Defining a named range - Using worksheet functions Charts and PivotTables - Creating charts - Modifying charts - Creating and modifying PivotTables - Hands-on: Working with PivotTables Distributing and publishing workbooks - Inserting external data into a worksheet - Publishing a workbook - Hands-on: Distributing a workbook to users - Routing and printing a workbook

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1995-2005 E&A Inc.. All rights reserved.
1-877-298-1322