Visual Basic for Applications (VBA) in Excel | Part 1
Short course
In Islington
Description
-
Type
Short course
-
Location
Islington
Using a step-by-step approach, this course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel. Students learn to write macros to accept user input, read to and write from cells and manipulate data. They also learn to write custom functions and create user forms. Useful examples of problems and their solutions are provided. Course Information Start DateStart TimeDurationCostCourse CodeApply Monday 3 October 2016 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Tuesday 4 October 2016 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Saturday 8 October 2016 10:30 - 16:30
(includes 1-hour break) 5 weekly classes £540.00 CS1595 Apply Now Monday 16 January 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Tuesday 17 January 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Saturday 21 January 2017 10:30 - 16:30
(Includes 1-hour break) 5 weekly classes £540.00 CS1595 Apply Now Monday 8 May 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Tuesday 2 May 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Saturday 6 May 2017 10:30 - 16:30
(Includes 1-hour break) 5...
Facilities
Location
Start date
Start date
Reviews
Subjects
- Excel
- Basic
- Visual Basic training
- IT
- Basic IT training
- Basic IT
- Visual Basic
- MS Excel
Course programme
- Recording and running macros
- Assigning macros to menus, toolbars and buttons
- The Visual Basic editor
- Input boxes and Message boxes
- Object-oriented concepts: objects, properties, methods and events
- Excel objects
- Variables and constants
- If statements
- Looping
- Conversion functions
- User-defined functions
- User forms and dialog boxes
- Error-handling and debugging
- Workbook and Worksheet events
By the end of the course, you will be able to:
- Record and run macros
- Use the Visual Basic environment to edit programs
- Write Visual Basic code, using variables, loops and if statements
- Understand Excel VBA functions and write their own functions
- Understand and apply object-oriented concepts
- Be acquainted with the most important Excel VBA objects and properties
- Understand events in Excel
- Debug (i.e. correct) errors.
Additional information
Teaching and Assessment
Informal assessment will take place through group discussion, class room activities, and questions and answers sessions as guided by your tutor.
Visual Basic for Applications (VBA) in Excel | Part 1