Programming with Excel VBA

Automate Calculations in Excel

4.9(91)3h 54m14 lectures2 sections

What you'll learn

  • Learn the basics of programming with Excel VBA.
  • Understand tools and events within Excel.
  • Create macros to simplify processes.
  • Understand algorithms to improve efficiency.
  • Apply codes to automate calculations.
  • Manage repetitive tasks effectively.

About this course

The Excel VBA programming course is ideal for users looking to enhance their Excel skills and learn how to automate various tasks within Excel using Visual Basic for Applications (VBA). This course covers many important topics, such as the fundamentals of Visual Basic, programming within Excel, creating and editing macros and custom functions, designing and modifying forms, controlling buttons and fields, as well as creating menus and dashboards. With VBA techniques, you will also handle data in advanced ways, including searching, sorting, filtering, and generating custom reports and charts.

Expected outcomes

  • Automate processes within Excel using VBA.
  • Create custom software solutions to meet business needs.
  • Enhance productivity by writing code and executing algorithms.
  • Develop programming skills to solve problems and increase efficiency.

Instructor

Dr. Eng. Mohamed Al-Khodour

Dr. Eng. Mohamed Al-Khodour

PhD in Communication Engineering with several published research papers in peer-reviewed journals. Lecturer and trainer in computer science.
2,214 students5 courses