This course introduces simple programming in the visual basic programming language (macros) to automate your Excel spreadsheets. It is aimed at people who have completed the Excel Intermediate course (or equivalent) and have no programming experience.
By the end of the course you'll be able to: Enable your Excel spreadsheets run visual basic macros Write a simple visual basic macro to make changes to your Excel spreadsheet, for example o Change the data in your spreadsheet o Use dialogue boxes to interact with the user
Your tutor will provide a booklet with explanations and exercises for you to complete in class and take away. There will be a blend of computer-based exercises, theory, discussions, group and pair work. You are invited to ask questions at any time.
Completion of the South Thames Intermediate Excel course. Or, you will need to be familiar with Excel fundamentals, formulae and functions.
More advanced Excel courses at other colleges
All courses run subject to demand and the content listed here should be used as a guide only. Course content may vary according to a range of factors such as course duration, campus, teaching staff and requirements from awarding bodies. Check our course and fee guidelines for further details.
Apply for this course
Computing and IT