learning resources
Fill in the simple form below and we will contact you for FREE!
Join us on:
Home > Courses Certifications > Programming > Microsoft Excel 2003-Programming
Duration: 3 Days
Chapter 1: What's New in Excel 2003 Using Improved Statistical Functions Creating Smart Documents Creating Document Workspaces Implementing Information Rights Management Comparing Workbooks Side by Side Getting Information with the Research Task Pane Using Extended XML Capabilities Creating Excel Lists Mapping Excel Data to XML Schemas Publishing Spreadsheets with Web Components Chapter 2 Exploring Excel Workbooks Worksheets Cells and Ranges The Excel Interface Formulas
Chapter 3: Exploring Visual Basic for Applications An overview of Object-Orientated Programming Properties Methods Events Collections Working with Macros Recording and Viewing Macros Running a Macro Debugging a Macro Implementing Macro Security and Digital Signatures Chapter 4: VBA Programming Starter Kit Introducing the Visual Basic Editor Opening the Visual Basic Editor Recognizing Parts of the Visual Basic Editor Customizing the Visual Basic Editor Managing Code Windows Handling Windows Adding Code Notes on Programming Style and Code Readability Developing Projects with the Project Explorer Creating VBA Modules Deleting VBA Modules Copying Modules between Projects Declaring Variables, Constants, and Data Types Declaring Variables Defining Data Types Defining Constants Handling Strings Handling Dates and Times Modules between Projects Handling Variants and Data Type Conversions Understanding Variable Scope and Lifetimes Assigning Values to Variables Creating an Array Creating Multidimensional Arrays Creating Dynamic Arrays Writing to the Screen and Accepting Input Creating a Message Box Creating an Input Box Defining Object Variables Creating Custom Data Types With.End With Command Controlling Program Flow Selection Statements Loops GoTo Statement Error Handling Chapter 5: Creating Sub and Function Procedures Defining Sub Procedures Defining the Scope of a Sub Procedure Running a Sub Procedure from Within Another Procedure Retaining Values Between Procedure Calls Defining Function Procedures Creating a Function Procedure Running Function Procedures Passing Arguments to Procedures Passing Named Arguments
Assigning Values to Variables
Controlling Program Flow
Chapter 6:The Application Object Introducing the Application Object Working with Arrays Properties Methods Chapter 7: Workbooks and Worksheets The Workbooks Collection Creating New Workbooks Opening Workbooks Workbook Properties Workbook Methods Printing and Previewing Workbooks The Sheets and Workbooks Collection Properties Methods Worksheet Methods Chapter 8: Ranges and Cells Basic Range Manipulations Finding the Active Range Selecting a Range Referring to Ranges Selecting a Range Referring to Ranges Referencing Ranges on the Active Worksheet Referencing Ranges on an Inactive Worksheet Referencing Cells in a Range Referencing Cells Using the Offset Property Defining a Range Using the Cells Referencing Columns and Rows Referencing Non-Contiguous Groups of Cells Manipulating Groups of Cells Resizing Cells Programmatically Joining Two Ranges Together Detecting Empty Cells Using Named Ranges Defining a Named Range Changing Notation Styles Reserved Range Names Copying Data Between Ranges and Arrays Getting Data Entry Right the First Time
Manipulating Groups of Cells
Using Named Ranges
Chapter 9 Manipulating Data with VBA Manipulating Text Determining if a value in a cell is Text Preparing String Data for Processing Determining the Number of Characters in a string Concatenating Text from Two or More Cells or Variables Returning the First or Last Several Characters from a String Returning Characters from Arbitrary Positions in a String Finding a String Within Another String Chapter 10: Manipulating Numbers Performing Summary Calculations Performing Financial Calculations Manipulating Dates and Times Time and Date Serial Numbers Date and Time Functions Chapter 11: Formatting Excel Objects Using Excel Color Constants and the Color Palette Manipulating the Current Excel Color Palette Using the Excel Color Palette on the Web Formatting Worksheet Elements Formatting Fonts Formatting Cells Formatting Borders Chapter 12: Creating Add-Ins and COM Add-Ins Introducing Add-Ins Installing an Add-In Unloading an Ad-In Creating Excel Add-Ins Creating an Add-In Saving the Add-In Installing the Add-In Chapter 13: Using the AddIns Collection AddIns Collection Addin Object Creating Automation and COM Add-Ins Using the IDTExtensibility2 Interface Registry Keys Building an Automation Add-In with Visual Basic 6 Designing the Add-In Registry Entries Building a COM Add-In with Visual Basic.NET Running the Shared Add-In Wizard Modifying the Template Installing the Add-In Chapter 14: Understanding and Using Events Workbook Entries Open Event Activate Event SheetActivate Event NewSheet Event Before Save Event Deactivate Event BeforePrint Event BeforeClose Event Worksheet Events Change Event SelectionChange Event BeforeRightClick Event Application Events Turning on Application Event Monitoring Detecting When a Workbook is Opened Chapter 15: Manipulating Files Locating External Files Returning All Files Limiting the File Search Finding Files with the Filedialog Dialog Box Writing to an External File Reading from an External File Searching a File for a Value Chapter 16: Developing Class Modules What is an Object? What is a Class? What Are Properties? What Are Methods? What Are Events? Introducing Class Modules Accessing Objects Declaring Objects Objects and Nothing Objects with Multiple Object Variables Properties, Methods, and Events Public vs. Private Properties, Methods, and Events Properties Methods Events Building a Class Creating a Class Module Defining Simple Properties Defining Property Routines Defining Methods Defining Events Defining Private Variables, subroutines, and Functions Special Events for Classes Resolving References Practical Class Design A Simple Class A Collection Class Extending a Simple Class A Collection Class A Class with Business Rules
Manipulating Dates and Times
Formatting Worksheet Elements
Creating Automation and COM Add-Ins
Building a COM Add-In with Visual Basic.NET
Application Events
Properties, Methods, and Events
Building a Class
Chapter 17: Charts Introducing Charts Creating Embedded Charts or Chart Sheets Defining the Chart Object Model Manipulating Charts Activating a Chart Deactivating a Chart Modifying a Chart's Data Series Modifying a Chart to Use Data from Arrays Defining a Chart's Labels Formatting a chart Modifying All Charts in a Workbook Printing Charts Chapter 18: PivotTables and PivotCharts Introducing PivotTables Creating a PivotTable with the Pivot Table Wizard Introducing Pivotcharts Creating a Pivotchart with the PivotTable Wizard Online Analytical Processing (OLAP) Issues PivotTable Objects PivotTables Collection PivotTable Object PivotCaches Collection PivotCaches Collection PivotCache Object PivotField Objects PivotItem Object Programming PivotTables Creating a PivotTable Creating a PivotChart Manipulating PivotTables Programmatically Pivoting a PivotTables Programmatically Resetting a PivotTable to its original Position Recording and Restoring Arbitrary Pivot Table Positions Chapter 19: Command Bars Identifying Parts of the Menu System CommandBars Collection CommandBar Objects Listing CommandBar Objects Adding a Floating Command Bar Deleting a Command Bar Command Bar Cotrols CommandBarControls Collection CommandBarControl Object Button Controls Creating Toolbars Combo Box Controls Using a Combo Box Pop-Up Controls Displaying a Pop-Up Adding Items to an Existing Menu Chapter 20:Customizing Dialog Boxes Displaying Existing Dialog Boxes Modifying Existing Dialog Boxes Exploring the Dialogs Collection Passing Arguments to Existing Dialog Boxes Planning with Dialog Boxes Chapter 21: Creating User Forms Creating a UserForm Adding a UserForm Designing a UserForm Modifying a UserForm Properties of a UserFrom Displaying a UserForm UserForm Controls Programming Controls Common Properties, Methods, and Events The Labe l Contol The CommandButton Control The TextBox Control The CheckBox Control The ToggleButton Control The SpinButton Control The Frame Control The OptionButto n Control The Image Control The ScrollBar Control The ListBox Control The ComboBox Control The RefEdit Control The TabStrip Control The MultiPage Control Chapter 22: Creating Advanced User Forms Capturing Information Form Application Overview Designing a Form Displaying Data Navigating The Worksheet Editing Data Adding Data Validating Data Displaying the User Form Chapter 23: Building a Multi-Step Wizard Wizard Application Overview Handling Menus Building the UserForm Navigating the Pages Collecting Options for the Wizard Summarizing the Options Running the Wizard
Manipulating Charts
PivotTable Objects
Manipulating PivotTables Programmatically
UserForm Controls
Chapter 24: Excel and Other Office Applications Starting Another Application Activating Another Application Binding Late Binding Early Binding Interacting with Other Office Applications Opening a Document in Word Accessing an Active Word Document Creating a New Word Document Controlling Excel from Other Office Applications Chapter 25: Excel and the Structured Query Language Comparing Spreadsheets and Databases Fundamental Database Concepts Database Keys Accessing Databases from Excel Manipulating Databases with SQL The Select Statement Simple Select Statements Retrieving Rows Sorting Rows Using Multiple Tables Using Functions The Insert Statement Using the Insert Statement The Update Statement The Delete Statement Chapter 26: Introducing ADO The ADO Object Model Using Functions The Connection Object Key Properties and Methods of the Connection Object Connecting to Different Database Management Systems Using The Errors Collection Using the Error Object The Command Object Key Properties an Methods of the Command Object Using the Parameters Collection Using the Parameter Object The Recordset Object Key Properties and Methods of the Recordset Object Using the Fields Collection Using the Field Object Creating a New Word Document Deleting a Command Bar Command Bar Cotrols CommandBarControls Collection CommandBarControl Object Button Controls Chapter 27: Excel Query Program Excel Query Program Overview Setting up the Project Initializing the Program Ending the Program Connecting to a Database Initializing the DBInfo UserForm Changing Database Providers Selecting Windows Authentication Saving Database Info Editing a Query Executing a Database Query Getting the Information to Run the Query Building a Connection String Getting the Query Running a Query Copying Rows Using the Excel Query Program Configure the Connection Information Enter a Query Run the Query Chapter 28: Excel and the Web HTML Saving a Worksheet as a Web Page Publishing a Worksheet to the Web Making Web-Based Worksheets interactive Using the Internet as a Data Source Opening Web Pages as Workbooks Using Web Queries Parsing Web Pages for Specific Information Using the Internet to Publish Results Setting Up a Web Server Saving Worksheets as Web Pages Adding Interactivity with the Web Components Communicating with a We Server Using Internet Solutions with Excel
Interacting with Other Office Applications
The Insert Statement
The Command Object
The Recordset Object
Using the Excel Query Program
Add to Favourites Contact us Back to top Home > Courses Certifications > Programming > Microsoft Excel 2003-Programming
Add to Favourites Contact us Back to top
Tel: 0861 111 460 E-mail: solutions@newhorizonsct.co.za
Copyright (c) 2005 New Horizons - All Rights Reserved.Procomp Computer Services CC trading as New Horizons Computer Learning Centre. Registration No. 2002/029621/23
Add to Favourites 
Location
