close
You are not logged in
close
This Month Specials
 

Special Promotion

$199 PowerPoint for Business Blowout! (Normally $299/ea)

PowerPivot Fundamentals Level 5a $199 (Normally $299)

15% off all Web Design Classes

$199 QuickBooks Level 1 or Level 2 for PC, Mac, or Online Classes (Normally $299/ea)

Now $545-Excel Power Programming with VBA (Normally $659)

Now $649-Photoshop Essentials 2 Day Course (Normally $749)

(book before 12/31/16)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

close
1 Union Square West, Suite 805, NY, NY 212.658.1918

Excel Power Programming with VBA Phase I Level 6

Excel 2010 Training Class Logo

The Excel Power Programming with VBA class concentrates on practical automation of repetitious Excel tasks and reports. By the end of the Excel training course, you will feel confident in writing macros to automate your Excel tasks even if the data is not consistently formatted, creating custom Excel applications and environments, and creating custom Excel Add-ins to increase the functionality of the program. This Excel class is perfect for those consistently working with Excel who need to automate repetitive tasks.

 

 

Call 212.658.1918 or Email us

 

Class Perks

 

* The most practical and hands-on training to boost productivity and skill

* State-of-the-art curriculums refined by industry experts over nearly two decades

* Interactive, personable, and engaging instructors with several years of in-field and training experience

* Free Retakes for Life!®

* Small classroom sizes for personalized attention

* Custom in-depth manuals and mousepads with key shortcuts

* Convenient location and comfortable learning environment

 

Materials

  • Custom Printed Manual
  • Multiple XLS and XLT examples for in class and after class
  • Shortcut sheets
  • After class resources

Course Outline

MACROS

  • What are macros
  • How to record macros
  • How to run macros
  • How Macros are related to VBA

VBA EDITOR

  • What is VBA
  • How to edit VBA Code

    What is a “sub” routine

  • What is Project Explorer
    • How to turn on Project Explorer
    • Excel Objects and Modules
      • What are Excel Objects
      • What are Modules
      • Making a sheet hidden
  • Properties,
    • What are Properties and their purpose
    • Renaming Modules
    • Renaming Sheets
  • Watch Window
    • What is a watch window and how to use it
  • Comments
    • What are comments
    • How are comments marked
    • The importance of comments
  • Debugger
    • What is the debugger
    • How is it used
    • Step into
    • Step over
    • Step Out
    • Play
    • Breakpoint
    • Reset
    • Monitoring values

DECLARING VARIABLES

  • What are Variables
  • How to declare variables
    • Using “Option Explicit”
    • Declaring multiple variables
    • Requiring variable declaration
  • Types of Variables
    • String
    • Integer
    • Single
    • Double
    • Boolean
    • Date
    • Time
    • Variant
      • Why to avoid variant declaration
      • When to use variant

REFERENCING  AND MANIPULATING

  • Cells
    • Selecting a specific cell
    • Selecting the active cell
    • Setting the value of a cell
    • Deleting cell contents
  • Rows
    • Selecting a specific row
    • Selecting the active row
    • Selecting the last row
    • Insert a row
    • Deleting row contents
  • Columns
    • Selecting a specific column
  • Selecting the active column
  • Selecting the last column
  • Insert a column
  • Deleting the column contents
  • Worksheets
    • Selecting a specific Worksheet
    • Selecting the active worksheet
    • Adding a new worksheet
    • Naming a worksheet
  • Range
    • Selecting a range of cells

STRINGS

  • How to Reference a string
  • Concatenating strings

IF STATEMENTS

  • If Then Statements
  • If Then Else Statements

LOOPS

  • Do While Loop
  • For Next Loop
  • For Next Loop with Step
  • Do Until Loop
  • For Each Loop

ACTIVATING SCRIPT WHEN WORKBOOK OPENS

  • Workbook_Open
  • Auto_Open

© NYIM Training 2017

Client Testimonials
This course exceeded my expectations.Saba is a great instructor! She answered all my questions and went beyond to link it to real life examples.- Laura H. attended Excel Power Programming with VBA Phase I Level 6
Saba made the class non- intimidating and informative due to her casual approach, teaching from the basics forward and her helpfulness with every little question. I did like that the class was small and hands on with computers.- N.B. attended Excel Power Programming with VBA Phase I Level 6
Saba really knows her stuff! Lively attitude kept things interesting. She was very interactive and engaging us in the class.- V.B. attended Excel Power Programming with VBA Phase I Level 6
I don't even know what else Saba could have done to make the class better - she was so on point and really interesting. - L.P. attended Excel Power Programming with VBA Phase I Level 6
Thank you for the session! It was really helpful and I've learned a lot from Joe.- N.N. attended Excel Power Programming with VBA Phase I Level 6