Mastering VBA in Excel

Fitch Learning

Course

In New York (USA) and London

£ 1,295 + VAT

The best Financial Analysis courses

See all

See all

Description

  • Duration

    2 Days

The purpose of this two day hands-on course is to gain an understanding of how Excel VBA can save you time through automation of repetitive Excel tasks. Day one is a core skills day, delivered with tutor-led mini exercises, designed to build up programming confidence. Here we spend a good amount of time on language structure and syntax. Day two applies the concepts to a real-life business problem, where delegates are given freedom to design a solution with tutor guidance.

Facilities

Location

Start date

London
See map

Start date

On request
New York (USA)
See map

Start date

On request

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • MS Excel
  • Excel

Course programme

Introduction to Macros: Recording absolute and relative macros (sub procedures), Running Macros with Form Controls, Shapes, Shortcut Keys Tour of the Visual Basic Editor (VBE) : Location and uses of the VBE windows, Customising the look and feel of the VBE, including window docking Editing and writing code: Language Structure: Objects, Properties and Methods (and Optional Parameters), Using the Intellisense List (CTRL+SPACE), Testing code with the Immediate Window, including Debug.Print Using Variables and data types: Declaring and assigning values to variables and constants, Data Types E.g. Integer, Double, String, Boolean

See related categories

Mastering VBA in Excel

£ 1,295 + VAT

The best Financial Analysis courses

See all

See all