Programming with Excel VBA
Automate Calculations in Excel
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.
Course content
1Programming with Excel VBA
12 lectures
- Introduction and Course Overview3:14
- Icebreaker and Writing the First Program18:38
- Events and Tools in VBA15:55
- Understanding Tools and Their Properties20:35
- Excel Objects and Conditional Statements24:25
- Variables and Message Box Programming17:44
- Adding Tools to Excel Worksheets20:51
- How VBA Handles Excel Cells19:29
- Understanding Algorithms and Building a Code Writing Plan27:32
- Understanding the Concept of Iterative Loops23:25
- Best Supplier Identification Program22:57
- Macro Units19:38
2Attachments
2 attachments
- Uploading the Work File
- Downloading Applications
Instructor
Dr. Eng. Mohamed Al-Khodour
5,510 students5 courses
