21
Nov 2019

Introduction of Excel VBA for Beginners

Course Information

Start Date21 Nov 2019, Thursday
End Date22 Nov 2019, Friday
Time09:00 am to 05:00 pm
Venue100 Orchard Road, Concorde Hotel Singapore
Fee$1,100 (Excluding GST) Inclusive of lunch, light refreshments and course materials
Contact6720 3333 (Ms Rina) training@aventisglobal.com
Register Now
Get Group Quote
Download Directory

INTRODUCTION

Become an Effective MS Excel VBA User

One of the World’s Most Productive Software

Visual Basic for Applications (VBA) is the programming language of Excel (and other Office programs), which specifically allow you to automate your repetitive tasks in Excel by writing so called macros. VBA combined with Microsoft Excel is probably the most powerful tool available to you. VBA is sitting on the desktops of 500 million users of Microsoft Office, and most have never figured out how to harness the power of VBA in Excel. Using VBA, you can speed the production of any task in Excel. If you regularly use Excel to produce a series of monthly charts, you can have VBA do the same task for you in a matter of seconds.

2-Day VBA Workshop for Excel Users

VBA is a programming language built to extend Microsoft Office applications. While it can be used in many Office applications, it is typically used to automate workflows in Microsoft Excel.

VBA’s syntax and relatively poorer debugging tools makes it very difficult as a first programming language to learn.
Instead of going through chapter by chapter, this course will teach only the necessary parts of VBA to enable a student to immediately apply what they have learnt to automate basic data analytics and basic automation of the Internet Explorer.

Participants will be given a scenario for hands-on practice in the context of an e-commerce company and the department’s role is to provide reports to the management. However, the team has always been generating these reports manually.
While fulfilling the syallabus, participants will see the immediate link VBA can use to automate reports. The ecommerce scenario is merely a parallel for the industries that the participants are working in.

Employees in companies are used to dealing with in-house built systems that have a very poor user experience for the end user. This creates a lot of inefficiencies during work. Another use case for VBA is to automate the Internet Explorer. In this segment, participants will quickly learn basic HTML and use VBA to get scrape data from internet pages.

Key Takeaways: Gain Mastery, Confidence and Improve Productivity

You will have gained a sound understanding of Visual Basic programming. By the end of this workshop, you will:

  • Gain professional skills on Excel VBA
  • Learn how to automate excel workbooks effectively for various operations
  • Record and Run Macros Easily
  • Gain knowledge on how to write macro programming in Excel
  • Code more efficiently in VBA
Who Should Attend?

This workshop is ideal for learners who are seeking to expand, optimize, and increase the efficiency of their Excel spreadsheet skills using powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).

Note:
This workshop is only for Windows version Microsoft Excel users. Participants are required to bring a laptop equipped with Windows version Microsoft Excel 2012 and above with access to internet

 

Teaching Methodology - Keep the end goal in mind & Passion before mastery

Traditional courses are usually taught chapter by chapter. Participants get bored and lost in a very lengthy learning process. By teaching only relevant concepts to achieve an end-product, we keep participants engaged throughout our course. More importantly, everyone walks away with a minimum viable product they can show.

Programming Coach: Brandon Ong

Programming Coach: Brandon Ong currently works as a technological consultant for companies in the wholesale trade sector, a sector that contribute 9% of Singapore’s GDP. This ranges from the b2b trading companies to freight forwarders and brokers. Brandon helps companies in this sector implement automated and AI-powered solutions to their current workflows. He is also developing a Robotic Process Automation tool (AI task robots in computers) to help wholesalers in their day-to-day operations.

Prior to this, Brandon served as the Chief Technology Officer of The Pawmeal Group. Beyond the front-end development of the website, Brandon is also developing machine learning algorithms for use cases such as product recommendation to increase the basket size before checkout. Coupled with his knowledge from his undergraduate study of Business Analytics, he was able to provide customised technical solutions that integrated well with the business strategies and goals.

Course Outline