Loading...

Course Description

In this course, you will explore Excel automation techniques using Excel macros and Visual Basic for Applications (VBA) code. This practical course equips you with the knowledge to streamline repetitive tasks efficiently, whether you’re an Excel novice or you’re looking to enhance your existing Excel skills. Without any previous coding experience, you’ll be able to write and utilize VBA code to perform tasks in Excel.

You will discover how to record and run macros before delving into some of the limitations of recording macros. You’ll then begin to enhance Excel functionality with VBA, manipulate ranges, and engage in hands-on projects. By the end of this course, you’ll be well prepared with the basics of using Excel VBA to automate tasks, save time, and boost productivity.

Please note: This course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course.

Faculty Author

Reza Moghimi

Benefits to the Learner

  • Record and run Excel macros
  • Describe how to enhance Excel functionality with VBA
  • Modify and format ranges with VBA

Target Audience

  • Excel users looking to automate tasks
  • Business analysts
  • Office administrators and managers
  • IT and technical support professionals
  • Educators and trainers
  • Project managers
  • Small business owners
  • Individuals transitioning to data-driven roles
  • Anyone interested in learning a new programming language

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Type
2 week
Dates
May 28, 2025 to Jun 10, 2025
Total Number of Hours
20.0
Course Fee(s)
Regular Price $999.00
Section Notes

IMPORTANT COURSE INFORMATION

  • Please note that this course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course.
Type
2 week
Dates
Aug 20, 2025 to Sep 02, 2025
Total Number of Hours
20.0
Course Fee(s)
Regular Price $999.00
Section Notes

IMPORTANT COURSE INFORMATION

  • Please note that this course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course.
Type
2 week
Dates
Nov 12, 2025 to Nov 25, 2025
Total Number of Hours
20.0
Course Fee(s)
Regular Price $999.00
Section Notes

IMPORTANT COURSE INFORMATION

  • Please note that this course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course.
Required fields are indicated by .