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

Short course

In Islington

Price on request

Description

  • Type

    Short course

  • Location

    Islington

This course builds on Visual Basic for Applications (VBA) in Excel Part 1, introducing a wider range of objects and applying previously learnt programming constructs to more complex and robust programmes.



Applications covered include:



*   Importing data into Excel

*   Manipulating pivot tables

*   Reporting

*   Complex data manipulation.



Software version: Office 2013

VBA short course tutor Joe Wilkinson recaps on his experiences, talks about passion and commitment necessary to complete the course and give a boost to your career. Course Information Start DateStart TimeDurationCostCourse CodeApply Wednesday 5 October 2016 18:30 - 20:30 10 weekly classes £540.00 CS2565 Apply Now Wednesday 18 January 2017 18:30 - 20:30 10 weekly classes £540.00 CS2565 Apply Now Wednesday 3 May 2017 18:30 - 20:30 10 weekly classes £540.00 CS2565 Apply Now Tutor Info Joe Wilkinson graduated from the University of Sheffield with a degree in Economics. He is now a senior director at one of the world's leading research and insight consultancies, measuring the effectiveness of marketing-related activities for numerous household brands. An enthusiastic learner, Joe has acquired a broad range of programming skills and languages, including: Python, C#, Javascript and VBA allowing him to automate data processing tasks, speed up business processes and visualise complicated data sets. Eligibility As the Visual Basic for Applications (VBA) in Excel Part 2 short course is a more advanced course, successful completion of Visual Basic for Applications (VBA) in Excel Part 1 is required. Knowledge of subjects therein will also provide...

Facilities

Location

Start date

Islington (London)
See map
Northampton Square, EC1V 0HB

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

  • Excel
  • Basic
  • Visual Basic training
  • IT
  • Basic IT training
  • Basic IT
  • Visual Basic
  • Programming
  • MS Excel

Course programme

What will I learn?
  • Review: the Excel API, especially range objects; basic programming constructs: variables and variable types, if, for each, input and output in conjunction with type conversion techniques
  • Looping structures: review of for-each; while loops; for-next loops
  • More programming techniques: using a consistent programming style; Arrays
  • Manipulating charts
  • Workbooks: opening, saving, File search
  • Manipulating pivot tables
  • Complex applications: structuring programs using separate macros for separate tasks
  • Error-checking and debugging: step into; step over; step out; on error resume; print debug; display alerts
  • Workbook and worksheet events in detail

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

  • Be fully confident in the use of basic programming constructs
  • Gain a thorough knowledge of key features of the Excel API: namely concerning ranges, workbooks and worksheets
  • Write structured programs which integrate a number of separately defined tasks.

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

Price on request