Get yourself trained on A beginners and with this Online Training A beginners and intermediate guide to VBA programming.
Online Training A beginners and intermediate guide to VBA programming
Have you ever felt frustrated using Microsoft Excel to perform mundane and often repetitive tasks? Have you ever felt that there has to be an easier and faster way to perform to do something? Well, using Microsoft Visual Basic for Application (VBA) programming language allows you to automate manual tasks within Excel and allows you to be more effective and efficient with your time. Not only does it provide you access to a rich library of additional tools and capabilities, over and above what a standard user may have access to, it can also be used to integrate with some of the Microsoft other Office applications such as Outlook, Word and MS Access. So, who should take this course? Anyone who wants to learn how to be a proficient VBA programming Anyone who wants to learn how to effectively utilize the tool to solve and automated manual tasks In this course you will learn some of the fundamental concepts of the VBA programming language. Not only does this course include a review of the basic concepts and key functionality available within this rich programming language such as the IF, Select Case and Loop Statements, you will also learn how to design and develop your own custom objects using the concepts of object orientated programming through the use of class modules. This course starts off with a brief refresher on the basic concepts of the VBA programming language and a review of the VBA Editor, the development environment that we will use during this course. This program also includes a number of practical examples, to help demonstrate how to effectively utilize the concepts that you have covered during this course. This course includes the key concepts and practical examples of the following VBA statements and functionality: IF Statements Loop Statements (For Next, Do While, Do Until) Exit Statements Goto Statements Select Case Statements Enumeration Data Types The DoEvents Statement Macros Arrays (declaring, re-initializing, auto populating and deleting arrays) Error Handling Standard Excel Objects Functions and Procedures Passing Values To Functions By Value Passing Variables to Functions By Reference Advance String Manipulation using the Trim, LTrim, RTrim, Left, Right, Instr and InstrRev Statements User forms Classes / Custom Objects Variable Declaration And Scope We finish the training course by reviewing additional practical examples of how to apply the key concepts that we have reviewed during this course. In total, this course provides approximately 9 hours of course videos, including practical files and examples to help you become a proficient and effective programming.
Udemy helps organizations of all kinds prepare for the ever-evolving future of work. Our curated collection of top-rated business and technical courses gives companies, governments, and nonprofits the power to develop in-house expertise and satisfy employees’ hunger for learning and development.
Learn on your schedule with Udemy
Investing in yourself through Learning
As a society, we spend hundreds of billions of dollars measuring the return on our financial assets. Yet, at the same time, we still haven’t found convincing ways of measuring the return on our investments in developing people.
And I get it: If my bank account pays me 1% a year, I can measure it to the penny. We’ve been collectively trained to expect neat and precise ROI calculations on everything, so when it’s applied to something as seemingly squishy as how effectively people are learning in the workplace, the natural inclination is to throw up our hands and say it can’t be done. But we need to figure this out. In a world where skills beat capital, the winners and losers of the next 30 years will be determined by their ability to attract and develop great talent.
Fortunately, corporate learning & development (L&D), like most business functions, is evolving quickly. We can embrace some level of ambiguity and have rigor when measuring the ROI of learning. It just might look a little different than an M.B.A. would expect to see in an Excel model.