In light of continuing Government advice regarding the spread of coronavirus (Covid-19) and social distancing, the majority of our face to face courses remain cancelled. Alternatively, we are pleased to offer an increasing range of online and virtual courses. Please see individual courses for details.
This course is for you if you are familiar with entering formulas and analysing data in Excel and want to write code to automate Excel tasks, such as formatting a report and performing operations which can not be done using conventional Excel commands.
The course assumes that delegates are familiar with:
carrying out basic operations such as data entry and copy and paste
entering formulas in Excel and using functions including VLOOKUP and IF
performing data analysis such as sorting and filtering
Please note - Writing macros involves inputting lines of sometimes complex program code, so the course involves considerably more typing than other Excel training.
By the end of the course you will:
be familiar with the VBA Editor and will be able to record a macro or create a macro in the code window
know how to use variables
know how to display messages and ask for simple user input
know how to use IF to decide which lines of code to run
"An extremely useful course which has enabled me to automate many repetitive tasks, both for myself and other team members."
(evaluation comment from a recent delegate)
A handout covering the main course topics will be provided.