Excel Macros & VBA (Day 1 of 2)

Course Prerequisites
Students should have a firm understanding of how Excel works and what it is used for.
Understanding and experience with formulas, functions, and PivotTables within Excel is strongly recommended. No previous experience with Visual Basic for Applications is required.  Please ensure you know the topics covered in - Excel Advancing your Knowledge.

Course Overview
This is day 1 in a two day course.   This course is intended to help all intermediate to advanced users get up to speed quickly with Visual Basic for Applications. We will cover different features of the Visual Basic Editor interface; show users how to record, edit, debug, and manage macros; and learn about the syntax that VBA uses to create macros.

Developing Macros

  • Create a Macro Using the Macro Recorder
  • Visual Basic for Applications
  • Object-Oriented Programming
  • Macros
  • Macro Options
  • The Macro Recorder
  • Personal Macro Workbooks
  • How to Create a Macro Using the Macro Recorder

Edit a Macro

  • The Visual Basic Editor
  • Projects
  • Modules
  • The Modules Folder
  • Objects
  • Properties
  • Methods
  • VBA Comments
  • How to Edit a Macro

Debug a Macro

  • The Debugging Process
  • Debugging Tools
  • How to Debug a Macro

Customize the Quick Access Toolbar and Hotkeys

  • How to Customize the Quick Access Toolbar and Hotkeys

Set Macro Security

  • Digital Certificates
  • Digital Signatures
  • Macro Security Settings
  • How to Set Macro Security

Formatting Worksheets Using Macros

  • Insert Text
  • The Selection Property
  • The Active Sheet Property
  • The Name Property
  • The Value Property
  • Concatenation
  • How to Insert Text

Format Text

  • How to Format Text

Sort Data

  • The Range Object
  • The Select Method
  • The Current Region Property
  • How to Sort Data

Duplicate Data

  • Data Types
  • Variables
  • Variable Naming Rules
  • Operators
  • The Assignment Operator
  • Arithmetic Operators
  • Comparison Operators
  • Logical Operators
  • The For Next Loop
  • Do Loops
  • The Worksheets Object
  • The Count Property
  • The Offset Property
  • The Copy Method
  • The Paste Method
  • How to Duplicate Data

Generate a Report

  • The Columns Property
  • The AutoFit Method
  • The Address Property
  • The Call Statement
  • The Font Property
  • The End Property
  • How to Generate a Report