fbpx

Download Training Directory (2021) Download Now

8
Jul 2021

Excel VBA Programming for Beginners

Course Information

Start Date8 Jul 2021, Thursday
End Date9 Jul 2021, Friday
Time09:00 am to 05:00 pm
VenueConcorde Hotel OR Holiday Inn Orchard City Centre
Fee$1,100 (Excluding GST)
Contact6720 3333 (Ms Rina) training.aventis@gmail.com
Register Now
Get Group Quote
LIVE Stream

Course Schedule

12 & 13 Apr 2021 Confirmed Run

08 & 09 Jul 2021

11 & 12 Oct 2021

INTRODUCTION

Become an Effective Microsoft Excel VBA Developer

One of the World’s Most Productive Software

Visual Basic for Applications (VBA) is the programming language of Microsoft Excel and other Office applications. Repetitive tasks can be automated using VBA through macros. VBA, when combined with Microsoft Excel, is probably the most powerful tool available to you. All over the world, millions of Excel users are harnessing the powerful capabilities of VBA by implementing automated solutions for their day-to-day data processing tasks.

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 more popularly employed in automating workflows in Microsoft Excel in the form of macros. Macros are essentially VBA code statements that are written or recorded to perform repetitive spreadsheet tasks.

Leveraging on their own Excel knowledge and experience, participants will learn the techniques of writing macros with VBA and Excel objects from scratch. VBA’s integrated development environment (IDE) with its Intellisense feature will assist learners in becoming familiar with VBA syntax and object-oriented programming (OOP) concepts.

This workshop takes the participants on a journey of discovery by exploring automation options of Excel’s spreadsheet tasks from the perspective of VBA programming. While being introduced to various concepts of programming, participants will be able to appreciate how macros are applied through hands-on demonstration and coding exercises involving common spreadsheet data processing scenarios.

Training Methodology

This workshop leverages the learner’s Excel knowledge of various features by associating VBA code and OOP concepts with those features. Through this association, the learner quickly becomes familiar with the techniques of writing macros to automate repetitive spreadsheet tasks. This approach shortens the learning curve of VBA. The learner will also be exposed to automating tasks in various common spreadsheet scenarios to gain an understanding of VBA and its application.

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 a working understanding of Excel VBA’s capabilities
  • Master Excel objects manipulation as a key towards effective spreadsheet automation
  • Record and run macros easily
  • Gain knowledge on writing dynamic VBA code to deal with dynamic datasets
Who Should Attend?

This course is ideal for Excel users who want to take their skillset to the next level. No programming experience is required. If you are seeking to expand, optimize, and increase the efficiency of your Excel spreadsheet skills using VBA automation, then this course is for you. As a minimum prerequisite, learners should have a usage experience of creating an Excel spreadsheet with simple formula and functions and applying basic cell-related formatting options.

Note: Participants are required to bring their own Windows-based laptop installed with MS Excel version 2010, or higher, with access to the internet. Users of Office 365 need to install their Excel application locally in their laptops prior to attending the course as VBA code cannot be executed when Excel workbooks are opened from the Office 365 online portal. This course is NOT designed for Microsoft Excel installed on Apple MacBooks or iOS devices.

Programming Coach: Zaid Ismail

Zaid Ismail is an independent IT trainer and consultant. He has been in the IT training industry for more than 20 years. He specializes in advanced level training of Microsoft Excel and Access, involving the use of VBA as an automation tool. In his capacity as a Microsoft Certified Trainer, Zaid conducts systems courses covering Microsoft SQL Server database administration and SQL scripting. Earlier in his IT career, Zaid has undertaken the responsibility of Assistant IS Manager in a local training firm and led a group of developers to design and implement in-house training management and enrolment system. These days, where his schedule permits, he provides consultancy in designing and implementing IT solutions for clients.

Course Outline
  • Setup Excel application environment for VBA programming
  • Use Macro Recorder
  • Make macros accessible to end users through buttons and shortcut
  • Manipulate Excel objects
  • Manipulate the many useful methods of Range object in data processing
  • Build automatic invoice generator with Sheets object
  • Write dynamic code with variables
  • Apply commonly-used VBA functions for data processing
  • Implement VBA decision control structures and code looping for complex data processing scenarios
  • Manage and manipulate data from multiple workbooks with VBA
  • Troubleshoot macros using built-in debugging tools