DISCOVERING THE SECRETS OF MACRO AND VBA IN MICROSOFT EXCEL
By LIVE ONLINE PROGRAM
16 & 17 Feb 2022 (Every session 9am - 5pm)
Wed & Thus
MACRO AND VBA IN MICROSOFT EXCEL
Are you facing a repetitive clean up of fifty tables in Word? Do you want a particular document to prompt the user for input when it opens? Are you having difficulty figuring out how to get your contacts from Microsoft Outlook into a Microsoft Excel spreadsheet efficiently?
You can perform these tasks and accomplish a great deal more by using Visual Basic for Applications (VBA) for Office—a simple, but powerful programming language that you can use to extend Office applications.
Generally, MACRO AND VBA IN MICROSOFT EXCEL, Microsoft Excel is a spreadsheet application used to create lists, perform calculations, and analyse numbers. While the default features of Excel should be enough in most scenarios, in some cases you will want more complex functionality to perform advanced operations. To make this possible, Excel is accompanied by Microsoft Visual Basic, a programming environment that allows you to use the Visual Basic Application (VBA) language to enhance the usefulness and functionality of a spreadsheet.
VBA allows you to write code that can automatically perform actions on a document and its content. Besides as an end user, now you are a ‘programmer’ to use Excel as a development tool to design an information system.
This course is designed for working adults for the following objectives:
– To improve current spreadsheet (Microsoft Excel) solution skills.
– To use Visual Basic Application (VBA) language to automate daily tasks.
– To prepare students in designing an user-friendly interface in Excel
– To prepare students to train others.
At the end of the MACRO AND VBA IN MICROSOFT EXCEL course, students should be able to:
- Understand and apply VBA language commands in Excel
- Use VBA to control the internal calculation or formulas or data flow in the reports.
- Design custom user interfaces in Excel.
- Simplify and speed up the tasks using VBA/ Macro