The Excel VBA Programming Course - Beginner Level
Learn Excel Visual Basic for Applications (VBA), the Microsoft’s programming language for Excel and all the other Microsoft Office programs.
Course description
Take "The Excel VBA Programming Course" to learn Excel Visual Basic for Applications (VBA), the Microsoft’s programming language for Excel and all the other Microsoft Office programs:
Learn Object Orientated Programming
Record and save Macros
Work with the VBA Editor
Learn Variables and Procedures
Learn Loops and IF Statements
Learn Error Handling
Learn User Defined Functions
Create Forms
Practice with assignments
Who this course is for:
Students and Corporate employees wanting to improve their Excel skills
Course curriculum
-
2
Macros
-
Macros Initial Setup
-
Recording a Macro
-
Saving a Macro
-
-
3
VBA Editor
-
Launching VBA
-
VB Editor
-
Custom Menu
-
Naming Projects
-
Modules
-
Code Window
-
Comments
-
-
4
Variables and Procedures
-
Introduction
-
Vraibales
-
Variable Exercise
-
What are Procedures
-
What are Procedures - Part Two
-
What are Procedures - Part Three
-
Message Boxes
-
Input Box
-
Input Box - Part Two
-
Basic Navigation
-
Sheets
-
Cell Navigation
-
Advanced Sheets
-
Offset
-
-
5
Loops and IF Statements
-
Introduction
-
Operators
-
Using Variables
-
What is Automation
-
For Loop
-
Do Loops
-
IF Statements
-
IF Statements - Part Two
-
Select Case
-
-
6
Error Handling
-
Debugging
-
-
7
User Defined Functions
-
UDFs
-
-
8
Assignments
-
Introduction
-
Exercise 1 - Record a Macro
-
Exercise 2 - Duplicating Data
-
Exercise 3 - Generate a Report
-
Generate a Report - Part Two
-
Exercise 4 - Inner and Outer Loops
-
Inner and Outer Loops - Part Two
-
Inner and Outer Loops - Part Three
-
Inner and Outer Loops - Part Four
-
Inner and Outer Loops - Part Five
-
-
9
Creating Forms
-
Form Controls
-
Building the Form
-
Initialize the Form
-
Command Buttons
-
Command Buttons - Part Two
-
-
10
Work files
-
Work files
-
Meet your instructor!
Andries Nienaber
Office 365 - Engineer
Hi there, my name is Andries and I have been working with Excel for over 20 years. I have worked with major corporate companies such as Nespresso and various Banks.
I currently am one of the preferred in classroom trainers for Office and I am dedicated to helping you create outstanding tools and reports in Excel. Our courses are for those who want to learn Excel, accelerate your careers and achieve more in less time.
For over 20 years I have worked in the Finance and IT departments implementing reporting systems based on SQL and XML. All the while using Excel VBA to automate and improve processes.
Our courses include examples based on real-life experience as well as the consulting work I have done for many international companies.
I place great value on keeping my Excel courses not only informative but also engaging. For this reason, students will find enough challenges, exercises, and downloadable files to practice so they can maximize the value gained from each course.
Private Label Rights (PLR)
This course is available with Private Label Rights (PLR).
When you buy a course with private label rights on Uthena, the author of the course gives you permission to download the course and sell it as your own on your website according to the terms of the PLR license included.
If you would like to know more about the license terms, please visit this page.
After purchasing, you will have access to the course on Uthena and you will receive the PLR license with a download link and a special bonus.
See a sample of the PLR license.
You have the option to buy Master Resell Rights (MRR) to this course, which allows your customers to have the right to sell the course as well.
More courses
You may like these other courses by Andries Nienaber.
You can buy Private Label Rights (PLR) for this course and others, click here.
You can buy Master Resell Rights (MRR) for this course and others, click here.