Programming with VBA (Visual Basic for Application) in Microsoft Excel
Designed for non VBA practitioners to solve real business problems with VBA programming & Excel macros.
Duration: 3 days
What is VBA Programming in Microsoft Excel
Microsoft Excel is a powerful tool that you can use to manipulate, analyze, and present data. Built within Excel is a computer programming language called VBA (Visual Basic for Applications). The idea is by writing a VBA computer program, you can instruct Microsoft Excel to perform complex, repetitive and even mundane tasks on your behalf. Used properly on suitable problems, a VBA program working within Excel can have wide ranging automation benefits that can increase a department’s productivity. As machine automation begins to take over many human tasks, learning how to code has been said to be an attractive employability skill for the future.
What this is about
Designed for non VBA computer programmers. This is a short & easy-to-follow workshop to develop a practical knowledge of VBA (Visual Basic for Applications) with Microsoft Excel. This 3-days workshop is suitable for users of Excel 2002 through Excel 2016. The participant will learn how to build VBA programs from scratch that can automate Microsoft Excel to perform work. Throughout the course of the workshop, our facilitator incorporates VBA codes which address real life business problems.
What problems it solve
Traditional Excel VBA training overwhelms the non-practitioner with too many programming concepts. Consequently, the learner grasps the theory but not the practical experience to produce VBA codes for solving basic spreadsheet problems.
Structured for a gentle learning curve
We have designed a course structure that is relevant for business use. This is a hands-on learning experience which is more instructive than textbook classes by other centers.
* Using the Visual Basic Editor
* The VBA programming workflow from code to execution
* Useful tips and tricks from real world situations
* VBA coding from scratch
* Developing with Excel Macros
* Processing massive records & Excel rows with VBA programming
* Create an automated report application with VBA
* Create an automated stock trading program with VBA
This workshop aims to train anyone with no programming experience to be proficient with the VBA programming language within Excel. By solving various challenging problems and doing guided projects, the participant will learn to perform a wide variety of automation tasks to improve Excel productivity and embark on interesting office automation projects.
Create a full featured automated business reporting app in our workshop.
Create a full interfaced VBA application in our workshop
Who should Attend
For Excel users who wish to expand their skill set to engage greater analyst roles. Participants are expected to have a good working knowledge of Excel as a pre-requisite.
Why Aeternus Training
VBA is a deep computer language. Like learning any language, instructor quality determines how much you get out of the classroom. Learn from real practitioners with over 15 years of development & consulting experience. Unlike other centers, we keep our classes small so that there are real discussions about real problems.
About the Trainer
Derek Leong is a fellow Consultant at Aeternus. He has a broad background in marketing, business analysis & software development. When he conducts Excel and other courses, he combines technical expertise and business experience with a creative bent.
Individuals We have Helped
Owen Sim, Database Administrator, Siemens
“I have attended other VBA classes, but I found that I couldn’t apply what I had learnt. Derek showed lots of examples I can definitely use!
Andrew Fong, Financial Analyst, Ministry of Finance
“By the way, the environment was great (quaint, lovely and all) and the course structure/pace etc were superb.
Matthew Phan, Economist Analyst, A Credit Research firm
“hi Derek, just wanted to say – this week I spent a couple days working on the VBA and managed to automate pretty much all of the processes that I asked for help with (the charts, tables, etc), using reference to your lastrow solution and other hacks from the classes and online. Thanks so much again for the classes – really enjoyed them…
Wilson Remot, Account Manager, VISA Inc.
“I must say that this is one of the best workshops that I have attended. Eventhough the course is for Basic VBA, I see that some advance tips were shared during the class. A lot of best pratices were shared by Derek which helps solve problems encountered at work. Derek as instructor is really exceptional. He was very lively from morning to afternoon. He was knowledgeable in the subject matter and was patient with his students. He was even willing to help out in my current project! Plus points for the classroom setting. It was very conducive for learning. And you can have all the coffee that you want-what more can I say! Aeternus consulting should be the premiere center for all your MS Office needs. Two thumbs up!
Ask us about Microsoft Excel Training Courses in Singapore