Details
VBA (Visual Basic for Applications) 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.
Upon successful completion of this 3-day hands-on training course, students will be able to:
- Record and edit macros
- Use the Visual Basic Editor
- Create sub and function procedures
- Understand objects, properties, methods and events
- Explore the Excel object hierarchy and use the Object Browser
- Work with variables and understand data types
- Use intrinsic functions
- Work with control-of-flow structures
- Design UserForms and work with controls
- Control PivotTables programmatically
- Use debugging tools
- Add error handling to code
Schedules
| Mon | 09:30 AM — 05:30 PM |
| No. of Days: | 3 |
| Total Hours: | 24 |
Inspizone provide corporate training for all Microsoft Office courses including excel, PowerPoint, Access, MS Project, Project Management, PMP, ITIL, Six Sigma, Customised IT Courses like .
Free Refresh Course: We provide best training centre with 100% Satisfactory Guarantee. Our objective is to upgrade your knowledge and teach you until you upgraded your knowledge thats why we allow you to come for refresh class unlimited times within 6 Month.
Inspizone have been dealing with Fortune 500 companies, Government agencies, SMEs and Big Enterprises in Singapore and Australia. We are growing fast to build our branches and franchises in all over the world, to best capitalize on IT investment and increase productivity.
Related Courses
