ASP.NET, VB.NET, and C# Training Classes     
USACanada UK Ireland International
1 877 849 1850   0808 234 2132   1 800 550 311   +1 678 648 3113
  Home   Contact Us
ASP.NET Training * VB.NET Training * C# Training * .NET 3.5 Training * ASP Training * ASP.NET AJAX Training
Visual Basic and VBA Training * Microsoft Expression Training *VS 2005 Tools for Office Training
SharePoint Training *Silverlight Training * SQL Server Training * Live Online Training


 * ASP.NET
 * Visual Basic .NET
 * C#
 * ASP & COM



Please contact us
for GSA pricing.

GSA

Contract #
GS-35F-0307T



Complimentary .NET Training Seminar

Organizations in the Atlanta, Georgia area are encouraged to contact Accelebrate® about having a complimentary, one-hour .NET seminar delivered for their developers. Contact us today for more information.



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Oakland / San Jose / San Francisco, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Kingston, Jamaica
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge, Louisiana
  • Valletta, Malta
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Taunton, Massachusetts / Providence, Rhode Island
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Lansing, Michigan
  • Saginaw / Flint / Bay City / Midland, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • Gulfport / Biloxi, Mississippi
  • Whiteman Air Force Base / Kansas City, Missouri
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Newark, New Jersey
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

VSTO Training: Visual Studio Tools for Microsoft Office Second Edition

Print This Outline
E-mail This Outline
Get A Quote
Course Number: 198
Duration: 2 days
view class outline

VSTO Overview

Accelebrate's VSTO training is designed for developers who want to develop solutions based on Microsoft Office 2003 or 2007, using Visual Studio Tools for Microsoft Office Second Edition. You'll learn about the types of solutions you can create with Visual Studio Tools for Office, understand how work with the Office object models, find out how to create your own user interface through Windows forms or the Actions pane, learn about deploying your solutions to end-user computers, and much more.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/microsoft.htm.

VSTO Prerequisites

Accelebrate's Visual Studio 2005 Tools for Microsoft Office (VSTO) training is designed for developers who have a programming background and are familiar with .NET concepts and the Visual Studio IDE. Previous experience with VBA in Office solutions can be helpful, but is not required. Most examples are presented in Visual Basic, but a C# topic is included to help C# developers translate the concepts to their language of choice, and to give Visual Basic developers the tools they need to read and understand examples available from other sources that are presented in C#.

Hands-on/Lecture Ratio

This training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 15 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.

VSTO Training Materials

All attendees receive more than 250 pages of comprehensive, illustrated courseware and a copy of Professional Visual Studio 2005 Tools for Office.

Software Needed on Each Student PC

  • Microsoft Office 2003 or later (complete install)
  • Microsoft Visual Studio 2005 SP1 + Visual Studio Tools for Microsoft Office Second Edition
  • Please contact us for additional setup instructions

VSTO Training Objectives

  • Know which products and components need to be installed on both development and end-user computers to create and use Office solutions.
  • React to events triggered by the Office user.
  • Perform Office-related tasks such as sending an e-mail or building a spreadsheet through code.
  • Translate Office programming concepts between Visual Basic and C#.
  • Create add-ins and code-behind solutions for Office.
  • Use data in your Word and Excel solutions.
  • Deploy your solutions to an end-user computer.

VSTO Training Outline

  • Getting Started with VSTO
    • Building Solutions with VSTO 2005 SE and the Microsoft Office System
    • Creating Your First Visual Studio Tools for Office Project
    • Introducing Managed Code
  • Working with the Microsoft Office Object Models
    • COM Objects in a Managed Code Environment
    • Working with Properties, Methods, and Member Objects
    • Responding to Events
    • Using Word Objects
    • Working with Excel Objects
    • Microsoft PowerPoint Objects
    • Building Command Bars in Office 2003
  • Techniques for C# Programmers Working in Office
    • Using C# to Work with the Office Object Models
    • Dealing with Parameters
    • Accessors in the Excel and Word PIAs
    • Using Late-Bound Members
  • Creating Add-Ins for Microsoft Office
    • The VSTO SE Add-In Model
    • Creating an Add-Ins with VSTO 2005 SE
    • Customizing the Ribbon in Office 2007
    • Custom Task Panes in Office 2007
  • Building Outlook Solutions
    • Creating an Outlook Add-In
    • Navigating the Outlook Object Model
    • Working with Outlook 2007 Data
    • Taking Advantage of Outlook Form Regions in Outlook 2007
  • Document-Based Solutions with Word
    • Building Document-Based Solutions for Word
    • Working with Host Controls in Word
    • Binding Data to a Word Document
  • Building Document-Based Solutions for Excel
    • Building Document-Based Solutions for Excel
    • Working with Host Controls in Excel
    • Binding Data to an Excel Workbook
  • Deploying your VSTO Solution
    • Sharing your Solutions with Others
    • Deploying Document-Based Solutions
    • Deploying VSTO 2005 SE Add-Ins
    • Customizing a Setup Project
  • Conclusion
 

Print This OutlineE-mail This OutlineGet A Quote

Accelebrate®
Comes to You!


Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.

For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.

 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!



VB.NET, C#, ASP, & ASP.NET Training * Java Training * SQL Server Training
Adobe Training * PHP Training * XML Training * Perl Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003-2006 by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | San Diego, CA | San Francisco, CA | Denver, CO | Washington, DC | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Oklahoma City, OK | Toronto, ON | Philadelphia, PA | Pittsburgh, PA | Portland, OR | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK

About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Open Source & Apache Training