This example-based, hands-on course introduces delegates to the fundamentals of writing Excel macros. You will learn how to create procedures to automate your work, remove the risk of inconsistencies and errors in repetitive tasks and above all, to save time. You will learn to write and edit macros for Excel, using Visual Basic for Applications and the Integrated Development Environment.
This course assumes a sound grasp of Excel, including writing worksheet formulae such as SUM, MAX, MIN, AVERAGE etc and formatting data. Any experience of recording and stepping through macros will be beneficial, but is not a pre-requisite for attendance.
A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.
This course is available as a private or customised course.
Contact us for further information and to customise this course to your exact requirements:
Phone us: 0208 269 4260Book Now
"Informative, useful, relaxed - Excellent! Will certainly use Transmedia again."
Tate & Lyle
"I just wanted to say a big thank you for yesterday. I really enjoyed the training and we got a lot done. The database looks really amazing, specially with the starter page and the logo. Thanks to Megan & Debra for sorting out the admin side and looking after me. "
"Informative, educational and well delivered."
Ernst & Young