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
     Examples: 
     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

Copyright © 2014 The Active Network, Inc.