Skip to main content

34 hours for Python Programming and Macro VBA courses

 

The last time I learned about programming was 16 years ago when I was still at university, learning about C++. This time, I was curious to learn more about computer programming and found the courses in Alfabank. I have taken two courses; the first one is Python programming, and the second one is Macro VBA for Excel.

Python was more accessible and consistent in terms of computer language; I was learning both in Alfabank and at home from YouTube. Using Python, we can automate things and create projects to calculate mathematical formulas and many other things faster. I enjoyed learning Python, and I can do a project to rename the files inside the directory just by double-clicking the Python file.

I finished the Python course in 20 hours. I was mostly learning about Basic syntax, Variable, Functions, Classes, Modules, Using PyQt5, Input and Output File, Database connection, and SQL Query.

Once the Python course was completed, I continued taking the Macro VBA course. The Macro VBA language was slightly more complicated than Python, but I still understood the pattern. In programming, most of the structure is about conditional and loop statements; it is just about the language being a bit different, but the programming knowledge is the same.

In Macro VBA, we can automate repetition and complicated tasks just by clicking one button, which will save the users a lot of time, and there is no need to do the same task repeatedly if it has the same pattern. Also, by using macro VBA, we can reduce the typo error.

The Macro VBA course was completed today, the total time is about 14 hours. Macro VBA learning focuses on writing macros, object-oriented programming, creating functions, working with cells and user forms, inputting and outputting files.

I was lucky because I completed the total course of 34 hours before joining the vessel onboard to improve my programming knowledge. My next target after I have made my trip onboard is to take PHP and MY SQL programming because I am excited to learn more about computer programming.


Comments