30
Jul 2019

Introduction of Excel VBA for Beginners

Course Information

Start Date 30 Jul 2019, Tuesday
End Date 30 Jul 2019, Tuesday
Time 09:00 am to 05:00 pm
Venue 100 Orchard Road, Concorde Hotel Singapore
Fee $680 (Excluding GST) Inclusive of hotel buffet lunch, light refreshments and course materials
Contact 6720 3333 (Ms Rina) training@aventisglobal.com
Register Now
Get Group Quote
Download Directory

Course Schedule

30 Jul 2019 (Tue) NEW

08 Oct 2019 (Tue)

16 Jan 2020 (Thu)

 

(Click on the dates above to register online)

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.

1 Day VBA Workshop for Excel Users

This beginner level training helps you learn the VBA language, and find practical ways to automate tasks and build a better workflow and automation in your work. It aims to help you automate routine tasks by recording, and writing/editing the Visual Basic For Applications (VBA Code) for Microsoft Excel since code runs much faster and save a huge amount of time for you. In this workshop you will learn the various programming nuances of VBA, work with Macros and how spreadsheets in Excel can be easily automated for various operations.

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

 

Pre-Requisite: Those who have basic knowledge of Excel can attend the training.

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).

This workshop  is also suitable for people who use Microsoft Excel in their day-to-day work, and know the basics of Excel pretty well, and would like to extend their knowledge of the more advanced features & functions of Excel to become more productive and make the most of Microsoft Excel.

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

 

Practical Hands-on Training

This workshop will provide you with step-by-step instructions that illustrate each aspect of Visual Basic. You need have no previous knowledge of any programming language so it’s ideal if you’re a newcomer to Windows programming.

MS Excel and Data Analytics Expert: Mr Pranjal Dubey Double Masters’ in MBA Business Analytics and Data Science from the National University of Singapore

Pranjal is a strong business professional having experience in various domains including Retail, Products, Finance and Education. Truly committed to making things happen, he puts a lot of effort into the initiatives he is involved in. He thrives on challenges and constantly sets goals for himself, and always looking for an opportunity to do better and achieve efficiency.

Pranjal has a Masters Degree in Data Science from National University of Singapore and an MBA in Business Analytics.

He is highly inclined towards the education industry and is currently spearheading the business development for couple of firms across various verticals. He co-founded ‘Xaltius Pte. Ltd.’ in Singapore which is a technology driven company focusing on building products and delivering trainings across SEA regions. He is also Founder of ‘Code For India’ which help students in India to get equipped with latest technologies and skills needed for industry. Along with these, he is involved in mentorship at ‘The Sparks Foundation’, an NGO working towards improvement of functional literacy and promoting skills development in India and Singapore.

Program Outline

Session 1: Introduction to VBA Macros

  • Displaying the Developer Tab
  • About Macro Security
  • Saving Workbook that contain Macros

 

Session 2: Types of VBA Macros

  • Creating VBA Macros
  • Recording Macros

 

Session 3: Writing VBA Code

  • Introduction to Variables
  • Controlling Execution
  • Flow of Control commands (IF, SELECT, FOR, DO, WHILE etc.)
  • Overview of VBA Functions / User-defined Functions
  • Using Functions in a Worksheet
  • Function Procedures
  • Executing Functions Procedures
  • Working with Ranges
  • Selecting a Row or Columns
  • Moving a Range

 

Session 4: Working with Workbooks

  • In this section all the VBA knowledge will be applied to automate workbooks
  • Conclusion, sharing and reflection of learning.

WordPress Lightbox Plugin