Visual Basic for Applications (VBA) in Excel | Part 2
Short course
In Islington
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
Start date
Reviews
Subjects
- Excel
- Basic
- Visual Basic training
- IT
- Basic IT training
- Basic IT
- Visual Basic
- Programming
- MS Excel
Course programme
- 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