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

City University London
Em Islington (Reino Unido)

Preço a consultar

Informação importante

  • Short course
  • Islington (Reino Unido)
  • Quando:
    à escolha
Descrição

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...

Informação importante
Instalações

Instalações e datas

Início Localização
à escolha
Islington
Northampton Square, EC1V 0HB , London, Reino Unido
Ver mapa

O que se aprende nesse curso?

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

Programa

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.

Informação 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.