Excel Programming
CTU-EXCEL10PR-C

 Email this information to yourself or a friend

 Remind me of this course at a later date




Official Program Description

Learn how to utilize Visual Basic for Application and how to construct programs with Excel in order to automate repetitive jobs or complex operations.

Who Should Attend

Individuals looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, anyone who already has knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Prerequisites

Proficient knowledge of Excel.

Attend and You Will Learn

Introducing Visual Basic for Applications

  • Recording a macro
  • Running a macro
  • Understanding the VB editor
  • Using the menu bar
  • Using the standard toolbar
  • Using the Project Explorer
  • Using the properties window
  • Understanding the code window
  • Understanding the code window options
  • Editing code
  • Closing the visual basic editor

Introducing Objects

  • Understanding the object browser
  • Understanding objects
  • Understanding the object hierarchy
  • Referencing objects
  • Understanding collections
  • Using the Editing features
  • Using the immediate window
  • Using the auto list
  • Using auto quick info

Introducing Variables

  • Understanding variables
  • Declaring variables
  • Understanding data types
  • Storing values in variables
  • Storing objects in variables

Creating Procedures and Functions

  • Understanding procedures
  • Using the Macro Recorder to create sub procedures
  • Calling procedures from procedures
  • Using intrinsic functions
  • Using message boxes
  • Using input boxes
  • Creating functions
  • Passing arguments to a function

Working with Conditional Statements

  • Understanding conditional statement
  • Working with decision structures
  • Working with looping structures

Creating Applications

  • Useful commands for automation
  • Techniques and tips
  • Directing user action
  • Message box and input box
  • Conditional branching
  • Do loops

Debugging Your Application

  • Understanding errors
  • Debugging code
  • Debugging tools
  • Using the locals window
  • Using the watch window
  • Using breakpoints



Sections

  Excel Programming
CTU-EXCEL10PR-C - 013
   
 
  2015 - TTS - Jan - Apr 2015   Status:  Available
 
In-Class:   Wed, Thu 9:00AM - 4:30PM
29 Apr 2015 to 30 Apr 2015
Class Schedule: 2 Sessions
Contact Hours: 12.0
Course Fee(s):
Registration Fee non-credit    $449.00
Gov't & Non-Profit Registration Fee non-credit    $349.00
Potential Discount(s):
CTU-MultClassDisc>250
  1.20 CEUs
Location:   On Campus
 
  Excel Programming
CTU-EXCEL10PR-C - 014
   
 
  2016 - TTS - Jul - Aug 2015   Status:  Available
 
In-Class:   Wed, Thu 9:00AM - 4:30PM
26 Aug 2015 to 27 Aug 2015
Class Schedule: 2 Sessions
Contact Hours: 12.0
Course Fee(s):
Registration Fee non-credit    $449.00
Gov't & Non-Profit Registration Fee non-credit    $349.00
Potential Discount(s):
CTU-MultClassDisc>250
  1.20 CEUs
Location:   On Campus