Introduction to VBA

Course Dates: 27/10/18 - 03/11/18
Time: 10:00 - 17:00
Location: KS - Keeley Street
Tutor: Andrew Chu

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.

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.

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?

No.

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

Reviews

Book your place

Course Code: CEX25

Please choose a course date 

Sat, day, 27 Oct - 03 Nov '18

Duration: 2 sessions (over 2 weeks)

Full fee: £199.00
Senior fee: £159.00
Concession: £100.00
Add to Basket

Or call to enrol: 222-66-889-99

Download form & post

Any questions? [email protected]
or call 020 7492 2515

Add to my wishlist

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

www.chemtest.com.ua

https://pharmacy24.com.ua

kls-agency.com.ua