Loading...

Course Description

Whether you’re a curious learner, a beginner data analyst, or a seasoned Excel user, this course provides a solid foundation for streamlining repetitive tasks effectively. Combining two key components of efficient data manipulation, you will use conditional statements and loops to solve complex business problems that mirror real-world scenarios.

Perhaps you’re tasked with optimizing inventory management, calculating shipping costs, or handling customer inquiries. You will examine how to develop algorithms to solve such problems and practice breaking down the problem logically by converting your decision-making steps into VBA code.

Now imagine that your task involves a vast dataset — rows upon rows of transaction records, inventory levels, or customer feedback. How do you process this data systematically? By using various loop structures that execute tasks automatically and allow you to iterate through data. You will discover how using conditional statements and loops together can give powerful results that will improve accuracy and efficiency in performing repetitive tasks in Excel.

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.

You are required to have completed the following course or have equivalent experience before taking this course:

  • Automating Processes With Macros and Excel VBA

Faculty Author

Reza Moghimi

Benefits to the Learner

  • Convert your decision process to VBA statements
  • Write loops with VBA code
  • Develop business solutions with if statements and loops

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
Dec 25, 2024 to Jan 07, 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
Mar 19, 2025 to Apr 01, 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
Jun 11, 2025 to Jun 24, 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
Sep 03, 2025 to Sep 16, 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 26, 2025 to Dec 09, 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 .