Font size:

Summary

Microsoft Excel is an extremely powerful tool that you can use to manipulate, analyze, and present data. Sometimes though, despite the rich set of features in the standard Excel user interface (UI), you might want to find an easier way to perform a mundane, repetitive task, or to perform some task that the UI does not seem to address. Fortunately, Office applications like Excel have Visual Basic for Applications (VBA), a programming language that gives you the ability to extend those applications. VBA works by running macros, step-by-step procedures written in Visual Basic. Learning to program might seem intimidating, but with some training, patience and some exercises such as the ones in this course, many users find that learning even a small amount of VBA code makes their work easier and gives them the ability to do things in Office that they did not think were possible. Once you have learned some VBA, it becomes much easier to learn a whole lot more—so the possibilities here are limitless.

Outline

Module 1: Getting StartedIntroducing Visual Basic for ApplicationsDisplaying the Developer Tab in the RibbonRecording a MacroSaving a Macro-Enabled WorkbookRunning a MacroEditing a Macro in the Visual Basic EditorUnderstanding the Development EnvironmentUsing Visual Basic HelpClosing the Visual Basic EditorUnderstanding Macro Security

Module 2: Working with Procedures and FunctionsUnderstanding ModulesCreating a Standard ModuleUnderstanding ProceduresCreating a Sub ProcedureCalling ProceduresUsing the Immediate Window to Call ProceduresCreating a Function ProcedureNaming ProceduresWorking with the Code Editor

Module 3: Understanding ObjectsUnderstanding ObjectsNavigating the Excel Object HierarchyUnderstanding CollectionsUsing the Object BrowserWorking with PropertiesUsing the With StatementWorking with MethodsCreating an Event Procedure

Module 4: Using Expressions, Variables, and Intrinsic FunctionsUnderstanding Expressions and StatementsDeclaring VariablesUnderstanding Data TypesWorking with Variable ScopeUsing Intrinsic FunctionsUnderstanding ConstantsUsing Intrinsic ConstantsUsing Message BoxesUsing Input BoxesDeclaring and Using Object Variables

Module 5: Controlling Program ExecutionUnderstanding Control-of-Flow StructuresWorking with Boolean ExpressionsUsing the If...End If Decision StructuresUsing the Select Case...End Select StructureUsing the Do...Loop StructureUsing the For...To...Next StructureUsing the For Each...Next StructureGuidelines for use of Control-of-Flow Structures

Module 6: Working with Forms and ControlsUnderstanding UserFormsUsing the ToolboxWorking with UserForm Properties, Events, and MethodsUnderstanding ControlsSetting Control Properties in the Properties WindowWorking with the Label ControlWorking with the Text Box ControlWorking with the Command Button ControlWorking with the Combo Box ControlWorking with the Frame ControlWorking with Option Button ControlsWorking with Control AppearanceSetting the Tab OrderPopulating a ControlAdding Code to ControlsLaunching a Form in Code

Module 7: Working with the PivotTable ObjectUnderstanding PivotTablesCreating a PivotTable Using Worksheet DataWorking with the PivotTable ObjectsWorking with the PivotFields CollectionAssigning a Macro to the Quick Access Toolbar

Module 8: Debugging CodeUnderstanding ErrorsUsing Debugging ToolsSetting BreakpointsStepping through CodeUsing Break Mode during Run modeDetermining the Value of Expressions

Module 9: Handling ErrorsUnderstanding Error HandlingUnderstanding VBA's Error Trapping OptionsTrapping Errors with the On Error StatementUnderstanding the Err ObjectWriting an Error-Handling RoutineWorking with Inline Error Handling
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live2/21/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>3 days995.002467193
KS Wichita2/21/2018 8:30:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>3 days995.002466870
KS Wichita5/16/2018 8:30:00 AM<span class="course-type type-c" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'ILT')" onmouseout="clearHoverInfo()">C</span>3 days995.002466871
Virtual Live5/16/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>3 days995.002467196
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 4 of 4 items