'Comment: You can use MS Excel 2010 and above for this course.
Now the fun stuff!!!
Why THIS course?
- You have been wanting to tip your toes into learning VBA, but not sure where to start! - You are in the right place.
I assume you know absolutely nothing, and willing to learn. I bring a very simplified lecture and a thorough explanation., and you bring your eagerness and willingness to learn. You leave with a thorough understanding of how VBA in Excel Works.
What will I learn from course? (The non-technical stuff)
1. A simplified business case, early in the course, to convince you that learning VBA in 2022 is still worth it!
2. A simplified background of VBA, and how it functions on a basic level. It's not just code, but a lot more.
3. How day-to-day operations you do in Excel can be done in the back-end with VBA. (Sum, count, average, etc.)
4. Put the end user in mind first when designing a VBA tool. Whether it is yourself or for others. Many tips and tricks from industry experience that makes not only your work standout, but more importantly YOU.
5. When to use and when to NOT use VBA - Yes! I'm going to steer you away from becoming a person that stretches their Excel muscles.
6. And lastly, the WHOLE SELLING point of this course: REAL life examples that I personally applied in Industry! You're not just learning how to code, more importantly you are learning how to SOLVE PROBLEMS!
What will I learn from course? (The technical stuff)
1. Core VBA functions that include message box, input box, copying and pasting, arithmetic, and MANY more.
2. Variables, how to use them in code, and make debugging your code a lot quicker. Quicker coding and debugging = Faster turnaround on your deliverables ?
3. ‘FOR’ Loops, the basis of any VBA coder – the simplest and most applicable loop of all.
4. ‘IF’ Statements in VBA, how to write them, when to use then…and when NOT to.
5. ‘Select Case’ in VBA, the more flexible ‘IF’ Statement and multiple different examples of its application. Examples are REAL, and PRACTICAL.
6. Adding and naming new worksheets and asking the user to provide a desired name.
7. Looping through objects (worksheets in the entire workbook) and execute commands.
8. Created an automated event log of operations, grab the username of the file opener, keep track of who did what and when.
9. Code optimization, making your macros run as much as 300% faster!
10. How to ‘Record a Macro’ and when to NOT rely on it.
11. How to make your code dynamic, smarter and flexible if the size of your incoming data changes.
12. All resources are downloadable for you take, practice and reference for your use.
Multiple examples from INDUSTRY, in different departments, performing different functions and providing thought-provoking scenarios and questions. This course is a must – whether its for VBA or to get more experience in solving industry challenges.
Strategically placed assignments and quizzes that will strengthen your understanding and enhance your thought process when approaching a new VBA project. Plus, you get the GRAND Assignment at the very end of the course – I called it the FINISHER – with a video recording of the solution.
MOST Importantly, this is a beginning to a journey. The first step, a foundation to get you going, and an introduction to the upcoming PART II and PART III of the ‘Apply Excel VBA in Industry’ Series. Examples get tougher as you go along, and so do I. I CONSTANTLY CHALLENGE you throughout the course – you would think I’m your gym coach.
Finally, my priority is to pass on VALUABLE Knowledge to YOU. To ensure you get your money’s worth! I made sure throughout the course to provide you with material that will ADD to your knowledge, and nothing that you will hit the ‘Next’ button on!
Happy Coding and Learning!
