MICROSOFT

Introduction to Visual Basic Training

Introduction to Visual Basic

The course provides participants with a thorough introduction to Visual Basic for Excel. Participants learn how to record macros and subsequently tidy the code, as well as how to write simple macros directly in the Visual Basic Editor. Also covered are loops and IF statements, creating message boxes, debugging, error handling and best practice recommendations. By attending the course, participants will gain an appreciation of when using macros is beneficial and how we can work with them in a safer and more user-friendly manner.

Training at a glance

Level

Introduction

Duration

1 Day

Experience

1 year: Excel

Average Salary

$65,358

Labs

Yes

Level

Introduction

Duration

1 Day

Experience

1 year: Excel

Average Salary

$65,358

Labs

Yes

Training Details

The course is designed to cover the following key objectives:
  • Understand the types of actions that VBA can be used for
  • Learn how to record a macro and tidy the code
  • Become familiar with different parts of the VBA Editor
  • Understand the language of Visual Basic to a beginners level
  • Know what objects, methods and properties are and how we work with them
  • Be able to code simple macros comprising of IF statements and Loops
  • See different methods of debugging i.e., checking for and fixing errors in the code
  • Obtain guidance on best practice approaches when working with VBA

During the course, the following areas will be covered: 

Introduction to VBA 

What VBA can be used for, the types of actions that can be performed and example uses of macros in financial models. 

Debugging 

Techniques that can be used to test for and ix errors in the code. 

Recording macros 

How to record them and subsequently tidy up the code.

Best practice rules for when working with macros 

Guidelines that should be followed such as using direct referencing, commenting the code and applying range names. 

The key building blocks of Visual Basic 

The various windows in the Visual Basic Editor and working with objects, properties, and methods.

Variables 

Declaring variables and using them to store values. 

Logical statements 

Working with ‘If’ and ’Select case’ statements. 

Loops 

Working with ‘For … Next’, ‘For each … Next’, ‘Do while’ and ‘Do until’ loops. 

Message boxes 

Setting them up and the benefits they can bring. 

Other VBA features 

Such as ‘Auto open’ macros, changing Excel’s calculation mode and updating the status bar.

The course is aimed at those who use Excel frequently but have had limited experience to date of working with and creating macros.

A good understanding of Excel and some experience of financial modelling is required. Participants are not expected to have a background in programming or to have used VBA before.

Upcoming Classes

We Offer More Than Just Microsoft Training

Our successful training results keep our corporate and military clients returning. That’s because we provide everything you need to succeed. This is true for all of our courses.

Strategic Planning & Project Management

From Lean Six Sigma to Project Management Institute Project Management Professional, Agile and SCRUM, we offer the best-in-class strategic planning and project management training available. Work closely with our seasoned multi-decade project managers.

IT & Cybersecurity

ATA is the leading OffSec and Hack the Box US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best offensive and defensive cyber training to keep your team ahead of the technology skills curve.

Leadership & Management

Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others and build a culture that values communication, authenticity, and community.

From Lean Six Sigma to Project Management Institute Project Management Professional, Agile and SCRUM, we offer the best-in-class strategic planning and project management training available. Work closely with our seasoned multi-decade project managers.
ATA is the leading OffSec and Hack the Box US training provider, and a CompTIA and EC-Council award-winning training partner. We offer the best offensive and defensive cyber training to keep your team ahead of the technology skills curve.
Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership. Empower your team to play to each others’ strengths, inspire others and build a culture that values communication, authenticity, and community.