Accounting Professionals and Business Managers with intermediate working knowledge in Excel can take their skills to a whole new level by learning to use VBA macros to enhance and speed up their work. It is natural for some Excel users to feel comfortable with the basics, and shy away from the more sophisticated art of trying a hand in writing macros. However, a highly effective and efficient way to accomplish routine tasks is actually the use of VBA macros in Excel. The use of Excel Macros and VBA is actually a “hidden gem” underutilized and overlooked by many Excel users.
Many Excel users may feel that programming is too complicated, difficult to understand or set-up properly. This hands-on workshop will seek to demystify these, and allay any unnecessary fear of using Excel Macros & VBA. The workshop will include extensive explanations and examples on how each of these areas could be applied to real-world situations in Management Reporting and typical Accounting/Finance tasks. Participants are assumed to have little or no prior programming experience.
By the end of the workshop, you will :
Introduction to Macros & VBA
An introduction to all the building blocks required to write macros in Excel’s VBA
An introduction to programming concepts and writing code
Best practices to make your VBA easier to read, quicker to run, and more robust
How to make your macros run as fast as possible
Interacting with Excel
How to link your macros to buttons and other controls
How to use VBA’s tools to quickly find problems and errors then resolve them
How to create new Excel files within VBA
How to open existing Excel files via VBA
How to save Excel files using VBA
How to work with multiple Excel files and copy or move data between them
This is a 2-days intensive programme where participants will get to apply their knowledge with hands-on exercises, guided by the Trainer. Participants are required to bring along their laptops , equipped with Excel 2010 and above full installations.
Participants are expected to have good or intermediate Excel skills and understand key concepts of spreadsheets or equivalent. It is not necessary to have prior programming knowledge. VBA Macro programming concepts will be taught from the very basic level. You should be an experienced Excel user who wish to automate repetitive tasks or simplify more complex tasks using Excel Macros and Visual Basic for Applications (VBA) programming language.
Dr Lim Thou Tin
Dr Lim is a business graduate from the NUS. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling. He is also a certified business intelligence professional with specialisation in business analytics.
Dr Lim’s work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives / projects over a span of more than 15 years in the Asia-Pacific region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia and Thailand.
Dr Lim continues to be involved in senior management education at local tertiary institutions, teaching information and accounting topics at degree and postgraduate level with research and publishing interests in knowledge management and business intelligence.