Programming with Excel Macros and VBA,1-Day Course, Online. Instructor-led.

MICROSOFT EXCEL MACROS AND EXCEL VBA COURSE,

• 1-TO-1
• Online, Connection Details provided upon booking. Read more
• Instructor-led

Excel Macros and Excel VBA is used to automate Excel Spreadsheets.

You already have Excel Skills and would like to record and program macros .

• Saturday sessions: Please email or call us to arrange a pro-rata hourly price.

COURSE OUTLINE

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 Excel 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 Excel 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

• 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

WHAT IS INCLUDED:

• PCWorkshops Certificate
• Course notes
• Practical Class exercises, Homework / Revision work
• To assist after the course, 1 free online question / revisions session.
• Max group size is 4.