Visual Basic for Applications (VBA) in Excel | Part 1

City University London
En Islington (Inglaterra)

Precio a consultar

Información importante

  • Short course
  • Islington (Inglaterra)
  • Cuándo:
    A definir
Descripción

Using a step-by-step approach, this course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel. Students learn to write macros to accept user input, read to and write from cells and manipulate data. They also learn to write custom functions and create user forms. Useful examples of problems and their solutions are provided. Course Information Start DateStart TimeDurationCostCourse CodeApply Monday 3 October 2016 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Tuesday 4 October 2016 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Saturday 8 October 2016 10:30 - 16:30

(includes 1-hour break) 5 weekly classes £540.00 CS1595 Apply Now Monday 16 January 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Tuesday 17 January 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Saturday 21 January 2017 10:30 - 16:30

(Includes 1-hour break) 5 weekly classes £540.00 CS1595 Apply Now Monday 8 May 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Tuesday 2 May 2017 18:30 - 20:30 10 weekly classes £540.00 CS1595 Apply Now Saturday 6 May 2017 10:30 - 16:30

(Includes 1-hour break) 5...

Información importante
Instalaciones

¿Dónde se da y en qué fecha?

comienzo Ubicación
A definir
Islington
Northampton Square, EC1V 0HB , London, Inglaterra
Ver mapa

¿Qué aprendes en este curso?

Excel
Basic
Visual Basic training
IT
Basic IT training
Basic IT
Visual Basic
MS Excel

Temario

What will I learn?
  • Recording and running macros
  • Assigning macros to menus, toolbars and buttons
  • The Visual Basic editor
  • Input boxes and Message boxes
  • Object-oriented concepts: objects, properties, methods and events
  • Excel objects
  • Variables and constants
  • If statements
  • Looping
  • Conversion functions
  • User-defined functions
  • User forms and dialog boxes
  • Error-handling and debugging
  • Workbook and Worksheet events

By the end of the course, you will be able to:

  • Record and run macros
  • Use the Visual Basic environment to edit programs
  • Write Visual Basic code, using variables, loops and if statements
  • Understand Excel VBA functions and write their own functions
  • Understand and apply object-oriented concepts
  • Be acquainted with the most important Excel VBA objects and properties
  • Understand events in Excel
  • Debug (i.e. correct) errors.

Información adicional

Teaching and Assessment

Informal assessment will take place through group discussion, class room activities, and questions and answers sessions as guided by your tutor.