Microsoft Excel: Visual Basic For Applications (VBA) Programming (2 day)

Course Overview

Learn how to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.

In this course, students will learn how to simplify their work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.

Students will gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students will strengthen their knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

CourseMonster has vetted every training supplier to ensure that you receive the best quality Microsoft training available.

Related Courses

• Microsoft Excel: Introduction for Beginners (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (1 day)
• Microsoft Excel: Financial Modelling using Excel
• Microsoft Excel: Formulae & Functions (1 day)
• Microsoft Office: Word, Excel & PowerPoint: Introduction for Beginners (1 day)
• Microsoft Excel: Data Analysis Decision Making/Solve Business Problems (2 day)
• Microsoft Excel: Visual Basic for Applications (VBA) Programming (4 day)
• Microsoft Excel: Charts, Pivot Tables & Macros (1 day)
• Microsoft Excel: Financial Modelling (2 day)
• Microsoft Excel: Business Modelling for Telecoms (2 day)

Audience

Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Skills Gained

Upon successful completion of this course, students will be able to: -

• develop macros
• format worksheets
• create an interactive worksheet
• work with multiple worksheets
• perform calculations

Course Outline

Lesson 1: Simple Task Macros

• Macro basics
• Edit a macro
• A toggle macro
• Make VB code readable
• Protecting Code

Lesson 2: Manage a task with macros

• Stepping through a macro
• R1C1 formula style
• User Input
• Relative Reference macro
• Turn off Excel alerts
• Assemble the pieces

Lesson 3: Exploring VB Objects

• Excel Object Model
• Objects, properties and methods:
• Application
• Workbook
• Worksheet
• AutoList
• Object Browser
• Help
• Explore the Range object

Lesson 4: Conditional and Looping Control Structures

• IF THEN ELSE statement on Msg Box
• Input Box
• Loops For each loop
• Counter Loop
• Do until loop

Lesson 5: User Defined Functions

• Write a Function
• If function
• SELECT CASE statement
• Use Excel function

Lesson 6: Debugging and Error Handling

• Event Handling