Overview
What you will study
Using a step-by-step approach, this Visual Basic for Applications (VBA) in Excel course offered by City, University of London shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel.
You will learn to write macros to accept user input, read to and write from cells and manipulate data. You will also learn to write custom functions and create user forms. Useful examples of problems and their solutions are provided.
Programme Structure
The program focuses on:
- 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
Key information
Duration
- Part-time
- 2 months
Start dates & application deadlines
- Starting
- Apply before
-
- Starting
- Apply before
-
Language
Delivered
Disciplines
Information Technology (IT) View 73 other Short Courses in Information Technology (IT) in United KingdomAcademic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- You should have a strong working knowledge of MS Excel to enrol on this course.
- No programming knowledge is required.
- Applicants must be proficient in written and spoken English.
Tuition Fee
-
International
595 GBP/fullTuition FeeBased on the tuition of 595 GBP for the full programme during 2 months. -
National
595 GBP/fullTuition FeeBased on the tuition of 595 GBP for the full programme during 2 months.