Overview
What you will learn
By the end of this Microsoft Excel VBA course offered by University of Sydney , you should be able to:
- discuss the elements of human logic manifest in Excel’s user interface, and some of the ways those elements manifest in Excel VBA
- implement those elements in VBA functions and VBA macros for Excel
- describe the Microsoft Excel Object Model and VBA concepts
- begin to catch errors with basic debugging
Programme Structure
The program focuses on:
- Gain an overview of the knowledge required to program in Excel VBA
- Understand the Six Requirements of Human Problem Solving
- Learn the Arithmetic Operators and their precedence in VBA
- Learn when to use the primitive/value types (variable data types) in VBA, including Variants
- Design algorithms with sequence and iteration
Key information
Duration
- Full-time
- 1 days
- Part-time
- 2 days
Start dates & application deadlines
- StartingApply anytime.
- StartingApply anytime.
Language
Delivered
Disciplines
Information Technology (IT) View 45 other Short Courses in Information Technology (IT) in AustraliaAcademic 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.
Student insurance
Make sure to cover your health, travel, and stay while studying abroad. Even global coverages can miss important items, so make sure your student insurance ticks all the following:
- Additional medical costs (i.e. dental)
- Repatriation, if something happens to you or your family
- Liability
- Home contents and baggage
- Accidents
- Legal aid
We partnered with Aon to provide you with the best affordable student insurance, for a carefree experience away from home.
Get your student insurance nowStarting from €0.53/day, free cancellation any time.
Remember, countries and universities may have specific insurance requirements. To learn more about how student insurance work at University of Sydney and/or in Australia, please visit Student Insurance Portal.
Other requirements
General requirements
- CRICOS Number: 0026A
- This course is designed for the beginner VBA user.
- You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers.
Tuition Fee
-
International
450 AUD/fullTuition FeeBased on the tuition of 450 AUD for the full programme during 1 days. -
National
450 AUD/fullTuition FeeBased on the tuition of 450 AUD for the full programme during 1 days.
- Face-to-face: $450.00
- Online: $420.00
Living costs for Sydney
The living costs include the total expenses per month, covering accommodation, public transportation, utilities (electricity, internet), books and groceries.