Processing your application. Please be patient while we make sure we receive every piece of it.
Office 2010 Applications
Excel 2010 Programming with VBA (3 Day Programming Course)
3 Days
REQUEST
PRIVATE SESSION
COURSE DESCRIPTION
OVER
VIEW
+
OBJEC
TIVES
+
AUD
IENCE
+
PRERE
QUISI
TES
+
OUT
LINE
+
Do your spreadsheets have code behind them? Has the person maintaining that code moved on to a new position, and now you have 'inherited' code you do not understand? While your job description may not be 'programmer', you may still have programming duties. Or, are you just looking to extend or automate processes that Excel cannot do out-of-the-box?
This course will teach the basic skills necessary to create, modify and edit code. Pursue skills and knowledge how to manipulate workbooks, worksheets and cells and to create custom functions.
Advanced Excel users.  Knowledge of Pivot Tables is useful but not essential.
Advanced or Intermediate Excel
GettingStarted
IntroducingVisual Basic for Applications
Displayingthe Developer Tab in the Ribbon
Recordinga Macro
Savinga Macro-Enabled Workbook
Runninga Macro
Editinga Macro in the Visual Basic Editor
Understandingthe Development Environment
UsingVisual Basic Help
Closingthe Visual Basic Editor
UnderstandingMacro Security
 
Workingwith Procedures and Functions
UnderstandingModules
Creatinga Standard Module
UnderstandingProcedures
Creatinga Sub Procedure
CallingProcedures
Usingthe Immediate Window to Call Procedures
Creatinga Function Procedure
NamingProcedures
Workingwith the Code Editor
 
UnderstandingObjects
UnderstandingObjects
Navigatingthe Excel Object Hierarchy
UnderstandingCollections
Usingthe Object Browser
Workingwith Properties
Usingthe With Statement
Workingwith Methods
Creatingan Event Procedure
 
UsingExpressions, Variables, and Intrinsic Functions
UnderstandingExpressions and Statements
DeclaringVariables
UnderstandingData Types
Workingwith Variable Scope
UsingIntrinsic Functions
UnderstandingConstants
UsingIntrinsic Constants
UsingMessage Boxes and Using Input Boxes
Declaringand Using Object Variables
 
ControllingProgram Execution
UnderstandingControl-of-Flow Structures
Workingwith Boolean Expressions
Usingthe If...End If Decision Structures
Usingthe Select Case...End Select Structure
Usingthe Do...Loop Structure
Usingthe For...To...Next Structure
Usingthe For Each...Next Structure
Guidelinesfor use of Control-of-Flow Structures
 
Workingwith Forms and Controls
UnderstandingUserForms
Usingthe Toolbox
Workingwith UserForm Properties, Events, and Methods
UnderstandingControls
SettingControl Properties in the Properties Window
Workingwith the Label Control
Workingwith the Text Box Control
Workingwith the Command Button Control
Workingwith the Combo Box Control
Workingwith the Frame Control
Workingwith Option Button Controls
Workingwith Control Appearance
Settingthe Tab Order
Populatinga Control
AddingCode to Controls
Launchinga Form in Code
 
Workingwith the PivotTable Object
UnderstandingPivotTables
Creatinga PivotTable Using Worksheet Data
Workingwith the PivotTable Objects
Workingwith the PivotFields Collection
Assigninga Macro to the Quick Access Toolbar
 
DebuggingCode
UnderstandingErrors
UsingDebugging Tools
SettingBreakpoints
Steppingthrough Code
UsingBreak Mode during Run mode
Determiningthe Value of Expressions
 
HandlingErrors
UnderstandingError Handling
UnderstandingVBA's Error Trapping Options
TrappingErrors with the On Error Statement
Understandingthe Err Object
Writingan Error-Handling Routine
Workingwith Inline Error Handling
SITE MAP