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