Expert
Excel lms

Excel VBA

Andries Andries
Overview
Curriculum
  • 10 Sections
  • 53 Lessons
  • 16h Duration
Collapse All
Section 1 - Introduction to VBA Programming
2 Lessons
  1. What is VBA
  2. Object Orientated Programming
Section 2 - Getting Started with Macros
3 Lessons
  1. Macros initial setup
  2. Recording a Macro
  3. Saving a Macro
Section 3 - Exploring the VBA Environment
7 Lessons
  1. Launching VBA
  2. VB Editor
  3. Custom Menu
  4. Naming Projects
  5. Modules
  6. Code Window
  7. Comments
Section 4 - Fundamentals of VBA Programming
14 Lessons
  1. VBA Fundamentals
  2. Variables
  3. Variable Exercise
  4. What are Procedures
  5. What are Procedures - Part Two
  6. What are Procedures - Part Three
  7. Message Boxes
  8. Input Box
  9. Input Box - Part Two
  10. Basic Navigation
  11. Sheets
  12. Cell Navigation
  13. Advanced Sheets
  14. Offset
Section 5 - Advanced VBA Programming Techniques
9 Lessons
  1. VBA Advanced 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
Section 6 – Error Handling
1 Lesson
  1. Debugging
Section 7 – User Defined Functions
1 Lesson
  1. UDF’s
Section 8 - Hands-On VBA Exercises
10 Lessons
  1. VBA Exercises Introduction
  2. Exercise 1 – Record a Macro
  3. Exercise 2 – Duplicating Data
  4. Exercise 3 – Generate a Report
  5. Exercise 3 – 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
Section 9 - Creating User Forms in Excel
5 Lessons
  1. Form Controls
  2. Building the Form
  3. Initialize the Form
  4. Command Buttons
  5. Command Buttons - Part Two
Section 10 - Excel VBA Conclusion
1 Lesson
  1. Excel VBA Conclusion

Welcome to our Excel VBA course! In this comprehensive training, you'll dive into the world of Visual Basic for Applications (VBA) and learn how to automate tasks, enhance functionality, and unlock the full potential of Microsoft Excel. Whether you're a beginner or an experienced user looking to expand your skills, this course will equip you with the knowledge and tools to become proficient in VBA programming. Get ready to streamline your workflow, boost productivity, and take your Excel skills to the next level!

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Related Courses

Advanced
Excel lms

Excel Advanced

Andries Andries

  • Advanced data analysis techniques

    • Solver for optimization problems

    What-If Scenarios for exploring possibilities

    8h
    34
    Buy Now
    Intermediate
    Excel lms

    Excel Intermediate

    Andries Andries

  • Conditional Formatting Mastery

    • Data Validation Techniques

    Advanced Formulas and Functions

    8h
    44
    Buy Now
    Intermediate
    Excel lms

    Excel Beginner

    Andries Andries

    User-Friendly Interface

  • Basic Formulas and Functions

    • Data Organization

    8h
    44
    Buy Now
    Scroll to Top