Excel Power VBA Bootcamp Washington DC

Alexandria, Virginia
Tuesday, September 25, 2012


Day 1 Day 2
7:30 - 8:00 7:30 - 8:00
Breakfast served on location Breakfast served on location
8:00 - 12:00 8:00 - 12:00
Getting Started with Excel VBA Advanced VBA Techniques
▪ Getting Started with Excel Macros ▪ Manipulating Pivot Tables via Code
▪ Using the Visual Basic Editor ▪ Enhancing Charts with VBA
▪ Building your own User Defined Functions ▪ Emailing From Excel Via VBA
▪ Understanding Variables  
▪ Debugging your VBA  Code  
12:00 - 1:00 12:00 - 1:00
Lunch Buffet served on location  Lunch Buffet served on location 
1:00 – 5:00 1:00 – 5:00
Navigating Cells and Manipulating Workbooks and WorkSheets Creating User Forms and Add-Ins
▪ Writing VBA to Manipulate Workbooks ▪ Enhancing Workbooks with User Forms
▪ Writing VBA to Manipulate Worksheets ▪ Review of Active X Form Controls
▪ Navigating Cells via VBA
     Finding the last used Column
     Finding the first Empty Row
     Looping through a Range
▪ Creating Your own Excel Add-Ins
     What is an Excel Add-In
     Creating an Add-in
     Protecting your Add-in
     Distributing Add-Ins
5:00 – 6:30 5:00 – 6:30
Free Form Q&A Free Form Q&A
▪ Catch up on Class Projects ▪ Catch up on Class Projects
▪ Get Help on Specific Projects ▪ Get Help on Specific Projects
▪ General Q & A ▪ General Q & A
29 spaces remaining

Contact Information

  • Phone: 214-578-2141
    Email: mha105@yahoo.com

Payment Instructions

  • Register with Credit Card
    Click the Register Now button above

    Invoice or PO
    If your organization requires an invoice or purchase order,
    contact us
    Be sure to include your contact information.

    Register with Check
    To Register with Check or Money Order, make payable to DataPig Technologies.

    Mail to:
    DataPig Technologies
    7548 Preston Rd #141-136
    Frisco, TX  75034

    *Be sure to include your email address so that we may contact you with registration information

© 2015
Quick, easy and affordable online event registration and event management software for all event sizes.