Log in
Finance Courses

The Excel VBA Programming Course – Beginner Level

See licenses and prices Sign in
  1. Course content1 lesson
    1. Resources
  2. Introduction2 lessons
    1. What is VBA
    2. Object Orientated Programming
  3. Macros3 lessons
    1. Macros Initial Setup
    2. Recording a Macro
    3. Saving a Macro
  4. VBA Editor7 lessons
    1. Launching VBA
    2. VB Editor
    3. Custom Menu
    4. Naming Projects
    5. Modules
    6. Code Window
    7. Comments
  5. Variables and Procedures14 lessons
    1. Introduction
    2. Vraibales
    3. Variable Exercise
    4. What are Procedures
    5. What are Procedures – Part Two
    6. What are Procedures – Part Thre
    7. Message Boxes
    8. Input Box
    9. Input Box – Part Two
    10. Basic Navigation
    11. Sheets
    12. Cell Navigation
    13. Advanced Sheets
    14. Offset
  6. Loops and IF Statements9 lessons
    1. Introduction
    2. Operators
    3. Using Variables
    4. What is Automation
    5. For Loop
    6. Do Loops
    7. IF Statements
    8. IF Statements – Part Two
    9. Select Case
  7. Error Handling1 lesson
    1. Debugging
  8. User Defined Functions1 lesson
    1. UDFs
  9. Assignments10 lessons
    1. Introduction
    2. Exercise 1 – Record a Macro
    3. Exercise 2 – Duplicating Data
    4. Exercise 3 – Generate a Report
    5. Generate a Report – Part Two
    6. Exercise 4 – Inner and Outer Loops
    7. Inner and Outer Loops – Part Two
    8. Inner and Outer Loops – Part Three
    9. Inner and Outer Loops – Part Four
    10. Inner and Outer Loops – Part Five
  10. Creating Forms5 lessons
    1. Form Controls
    2. Building the Form
    3. Initialize the Form
    4. Command Buttons
    5. Command Buttons – Part Two
  11. Promo Video1 lesson
    1. VBA Promo Video
  12. Workfiles1 lesson
    1. Resources

Unlock the power of Excel with The Excel VBA Programming Course – Beginner Level. This comprehensive course is designed for anyone looking to enhance their Excel proficiency through the use of Visual Basic for Applications (VBA), the programming language that drives automation within Microsoft Office applications. Whether you’re a student or a corporate employee aiming to streamline your workflow, this course provides the essential skills to take your Excel abilities to the next level.

Course Highlights:

  • Learn the fundamentals of Object Oriented Programming.
  • Record and save Macros for efficient task automation.
  • Navigate the VBA Editor with ease.
  • Understand Variables and Procedures to manipulate data effectively.
  • Master Loops and IF Statements for conditional logic.
  • Implement Error Handling techniques to create robust applications.
  • Create User Defined Functions tailored to your needs.
  • Design interactive Forms to enhance user experience.
  • Engage with practical assignments to solidify your understanding.

Who Should Enroll?

This course is perfect for students and corporate employees eager to improve their Excel skills and learn how to automate repetitive tasks. With The Excel VBA Programming Course – Beginner Level, you’ll gain the confidence to tackle advanced Excel functionalities and increase your productivity.

Why Choose This Course?

By enrolling in The Excel VBA Programming Course – Beginner Level, you not only learn valuable programming skills but also enhance your professional profile, making you a more competitive candidate in today’s job market. Start your journey towards becoming an Excel expert today!