What is the course about?
In this course, you will develop computer programming skills using Microsoft Excel and the Visual Basic for Applications (VBA) language. These programming skills can be used to tackle a wide range of real-world problems.
What will we cover?
Topic 1: Introduction to the VBA Environment
Topic 2: Data types & built-in functions in VBA
Topic 3: Modular programming I – Sub procedures
Topic 4: Modular programming II – Function procedures
Topic 5: Selective execution – If structures and Select Case structures
Topic 6: Repetitive execution – Loops
Topic 7: Arrays
Topic 8: Putting it all together.
What will I achieve?
By the end of this course you should be able to...
• Students will be able to input data and perform basic mathematical calculations within Excel spreadsheets.
• Students will be able to utilize fundamental programming concepts such as variables, modular programming, decision structures, repetitive structures, and arrays to develop VBA programs that manipulate Excel spreadsheets and perform basic calculations.
• Students will be able to comprehend the purpose and logic behind simple ready-made VBA programs, and will be able to predict the output of such programs.
What level is the course and do I need any particular skills?
- You should be at an Intermediate level in Excel
- No experience in computer programming required.
You should also be able to follow spoken and written instructions and be comfortable carrying out mathematical calculations.
How will I be taught, and will there be any work outside the class?
Each student has their own computer. Lectures will take place in the classroom, then exercises will be given to be completed as homework. We ll provide the solutions in the following class and tackle any challenging concepts.
Are there any other costs? Is there anything I need to bring?
When I've finished, what course can I do next?
Another Microsoft application course ie, Excel: financial modelling, Excel: analysing data.
General information and advice on courses at Build is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00.
See the course guide for term dates and further details