Technical Excel 2003 Tutorials

Here are some good technical Excel 2003 Tutorials and Articles from Microsoft. These will help you learn the technical side of Excel, including how to use XML functionality with Exel, Map Data, use Windows Forms, create a Report Templare, and write macros using Visual Basic for Applications (VBA). Also, here is Chapter 20: Creating Advanced User Forms, from the book “Microsoft Office Excel 2003 Programming Inside Out”.


 - Add XML Functionality in Microsoft Office Excel 2003 from Microsoft Visual Basic .NET
 - Creating Charts in Microsoft Office Excel 2003 Using Visual Basic for Applications Code
 - Creating XML Mappings in Excel 2003
 - Different Ways of Using Web Queries in Microsoft Office Excel 2003
 - How Excel 2003 Infers XSDs When Importing XML Data
 - Microsoft Office Excel 2003 Preview
 - Part 1: Automating the XML Data Mapping Process in Excel 2003
 - Part 2: Mapping XML from SQL Server to a Single Cell in Excel 2003
 - Part 3: Replicating Excel 2003 Formulas to SQL Server
 - Populating an Excel 2003 Worksheet with Multiple Related Records from a Windows Form
 - Super-Easy Guide to the Microsoft Office Excel 2003 Object Model
 - Understanding Security for Add-ins and VBA Macros in Excel 2003
 - Using the Excel 2003 XML Tools Add-in Version 1.1
 - Using the Excel XML Toolbox for Microsoft Office Excel 2003
 - Using Visual Basic and ASP with XML to Generate Excel 2003 Workbooks
 - XML and Microsoft Office Excel 2003: Creating an Expense Report Template

Popularity: 82% [?]