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

City University London
In Islington (Grossbritannien)

Preis auf Anfrage

Wichtige informationen

  • Short course
  • Islington (Grossbritannien)
  • Wann:
    Freie Auswahl
Beschreibung

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

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
Freie Auswahl
Islington
Northampton Square, EC1V 0HB , London, Grossbritannien
Plan ansehen

Was lernen Sie in diesem Kurs?

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

Themenkreis

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.