Excel Macro Course — Build Professional GUI Apps Using Excel VBA Macro Ultimate Class
What you will learn:
- Build professional graphical applications with VBA Excel.
- Learn VBA programming concepts to create dynamic and reusable code.
- Directly apply the provided Excel VBA scripts for your projects.
- Learn concepts through short presentations, then practice with exercises.
- Learn how to connect Excel with databases using VBA ODBC.
- Easily customize VBA code you find to suit your projects.
- You will be able to work as a freelance VBA developer
- Explore the power of using VBA solutions.
- Real-life project scripts are provided as supplementary material.
Requirements
- Excel installed on your desktop.
- Some prior knowledge of object-oriented programming will help, but is not required.
- A Mac or PC with internet access
- You should take notes
- Enthusiasm is all you need!
- You will be provided with various real-world project codes!
What you can expect in this course:
- Understand how to use proper syntax in VBA
- Clear and engaging concept presentations; clear syntax.
- All scripts are verified and provided, regarding presentation just copy & paste it in the VBA editor.
- Useful Excel VBA code that you can directly use for your work with comments.
- Working with Visual Basic Editor
- Error handling.
- Different methods for accessing ranges and cell properties.
- Different options for loops and conditions.
- How to work with data types
- Basically all the knowledge you need to automate tasks in Excel.
- As a supplement, you will be given lessons on creating databases (using phpmyadmin) and accessing databases such as mysql (with ODBC). Also, you will be given scripts for handling images in VBA.
Who this course is for:
- For anyone with a desire to learn.
- If you want to create graphical programs with forms and buttons (GUI), this course is for you!
- Anyone who wants to improve their development skills
- Anyone who wants to learn object-oriented programming knowledge.
- You do not need any prior programming experience at all! Anyone can learn VBA.
Learning Method at Cerdas Inovasi Digital
Live online classes via Zoom with experienced instructors, hands-on practice with real case studies, and session recordings that can be played back. In-house training packages are also available for corporate needs throughout Indonesia.
