MS Excel – Macros

Course description

A 10 week course covering the fundamentals of programming with Excel VBA.  Since its release, Excel has come with a complete programming language and development suite installed with it. And with this programming we can build programs (Macros)  that can automate the most simplest of tasks. These programs can be attached to a button on a form, spreadsheet or even the tool bar and run on command.  Hours of work can be recorded and converted into a single button push.

We will discuss and examine the how to structure your program for ease of debugging and some basic fault finding techniques. Examples will be supplied showing some of these techniques.

We will look at programming security, protecting your code and how excel treats these “macro” programs

How to open other files , copy and paste into another file, sort and manipulate data, close and save files.

Note: Please supply your own laptop with excel installed

Course Day & Time:  Tuesday evening 7.30 – 9.30pm                                                                                                                                                                                                                                                                                        Start Date: Not Running in Autumn 24 but will be back in our Spring 25 term starting 28/01/25

Cost: €110

Course Format: In class with tutor. Maximum of 12  students

Duration: 10 weeks

Enrolment: will open online through our website www.malahidecsadulted.ie early December. You can enrol online then by clicking on the Enrol Here Easy Payments Plus button

Tutor: David McLaughlin

Note: Please bring your laptop  with excel installed to class.