Excel Macros and VBA Course, Private 1-1, Live Virtual Classroom

Recording and Running Macros in Excel

Create simple macros using the macro recorder and run them from shortcuts or buttons on the ribbon

• Setting Excel Macro Options
• Record and run Simple Macros
• Assign Macros to the Quick Access Toolbar

Introduction to the Excel VBA Editor

Use the VBA Editor to navigate projects and explore object properties. Create, copy and import/export modules

• Starting the Visual Basic Editor
• Using the Project Explorer
• Using the Properties Window
• Creating, Importing and Exporting Modules
• Explore Recorded Macros

Creating Procedures and Functions

Create simple macro procedures in code that use variable to store data and communicate with the user

• Creating Sub and Function Procedures
• Declare and Use Variables
• Displaying Message to the User
• Getting Input From the User

Working With the Excel Object Model

The Excel course will explore a variety of ways our code can manipulate data within cells, create and navigate around worksheets and workbooks

• Understanding Objects, Properties and Methods

Interacting With the Spreadsheet

• Referencing Cells and Ranges
• Gathering Cell and Range Information
• Using the Offset Method
• Using With Blocks
• Referencing Workbooks and Worksheets
• Updating Values in the Spreadsheet and Putting Values into the Spreadsheet

Functions

• Using Standard Excel Functions in VBA
• Creating new Custom Functions

Controlling Program Flow

Using Decision Making and Looping Structures to Control the way Your Program Works

• Using the IF Statement
• Using the Select Case Statement
• Using For Next Loops
• Using Do Loops
• Using For Next Loops

Practical Project and Examples