Introduction to VBA

Course Dates: 19/10/20 - 16/11/20
Time: 19:00 - 21:00
Location: Online
Tutors:
Anis Mokadem

Build on your advanced Excel skills and learn how to use the Visual Basic Editor (VBE) to create VBA procedures (macros) and user forms. You will then be able to modify and test these components easily step by step in the VBE.

This course will be delivered online. For more information please see our guide to online learning.

Description

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.

This is a live online course. For more information please see our guide to online learning.
We will contact you with joining instructions before your course starts.

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...

• Input data and perform basic mathematical calculations within Excel spreadsheets.
• 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.
• 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?



This course will be delivered online, and will involve tutor presentation and class discussion. Student preparation and homework outside class times is strongly encouraged. To fully participate in this online class you will need:
- An email address
- A reliable internet connection
- A computer/laptop/tablet with a fully updated browser (preferably google chrome). Your device will need a microphone, and preferably a camera.

Are there any other costs? Is there anything I need to bring?

There are no additional costs.

When I've finished, what course can I do next?

Another Microsoft application course: Excel: advanced, Excel: expert, Excel for financial modelling, Excel: analysing data Stage(1&2).

Reviews

Customer Reviews 1 item(s)

Write a review

Reviews below are by students who have attended this course, regardless of the course teacher. Please be aware you may not be booking onto a course with the same teacher.

Good VBA starter course
Course Rating
Review by Anonymous / (Posted on 03/11/2018)
Tutor Biographies
We’re sorry. We don’t have a bio ready for the tutor of this class at the moment, but we’re working on it! Watch this space.

Book your place

Course Code: CEX25

Mon, eve, 19 Oct - 16 Nov '20

Duration: 5 sessions (over 5 weeks)

Full fee: £199.00
Senior fee: £159.00
Concession: £121.00

Or call to enrol: 020 7831 7831

Any questions? computing@citylit.ac.uk
or call 020 7492 2515

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online Help Center. You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.