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

City University London
Course summary
10 weeks
560 GBP
Part time
Open / Scheduled
Next available date: 25/01/2020 - London
Course Dates
25/01/2020   (English)
560 GBP
29/04/2020   (English)
560 GBP
Visual Basic for Applications (VBA) in Excel - Part 2

Course description

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

City is one of the very few universities in London offering this short course, which teaches you how to automate Excel so that even very complex functions can be achieved quickly and simply

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.

Suitability - Who should attend?

Prerequisite knowledge

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 you with eligibility for the VBA in Excel Part 2 course.

Training Course Content

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

Get Inspired! Watch the Video

A short course is an excellent way to gain new expertise, advance skills or simply follow a passion. With courses in business, computing, writing, creative industries, languages and law there is something for everyone. Glimpse inside our short course community: hear from our industry-expert tutors and listen to students as they reflect on their learning experience.

About provider

City University London

City University London

City, University of London is a special place. With skill and dedication, we have been using education, research and enterprise to transform the lives of our students, our community and the world for a hundred years. We are proud of...

Read more and show all courses with this provider

Contact info

City University London

Northampton Square
EC1V 0HB London

 Show phone number

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here