for Schools and LEAs

MICROSOFT® EXCEL® VBA FOR SCHOOL DATA (2-DAY COURSE)

Overview

Do you want to speed up manual and repetitive Excel tasks, in order to save vast amounts of time in your spreadsheet work? If the answer is yes, this is the course for you.

This course is aimed at current users of Excel who wish to learn how to automate spreadsheet tasks using Visual Basic for Applications (VBA). Delegates need no prior programming knowledge to benefit from the course and by the end of the course should be able to build customised applications within Excel.

Course Content

  • Course Introduction
  • Conditional Logic
  • What is VBA?
  • Using Loops
  • VBA Examples
  • Introduction to Objects
  • Recording Macros
  • Working with the Range Object
  • Controls
  • Creating Custom Userforms
  • Modules, Procedures, Variables
  • Debugging Code
  • The Visual Basic Editor
  • Error Handling
  • User Interaction
  • Course Summary

Booking Details

Please contact us if you need further information or to book a place on any of the courses we have on offer.

Back to Training

IntrepiData, Gear House, Saltmeadows Road, Gateshead, NE8 3AH, Tel 0191 478 2671, Email info@intrepidata.co.uk

© IntrepiData 2003 - 2009