Visual Basic for Applications (VBA) in Excel – Part 2 Short Courses
|Start Date||Start Time||Duration||Cost||Course Code||Apply|
|Wednesday 4 October 2017||18:30 - 20:30||10 weekly classes||£560.00||CS2565||Enrolment Closed|
|Wednesday 17 January 2018||18:30 - 20:30||10 weekly classes||£560.00||CS2565||Apply Now|
|Saturday 24 February 2018||10:30 - 16:30
with one hour lunch break
|5 weekly classes||£560.00||CS2565||Apply Now|
|Wednesday 2 May 2018||18:30 - 20:30||10 weekly classes||£560.00||CS2565||Apply Now|
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
* Complex data manipulation.
Software version: Office 2013
Sean Walsh has over 10 years’ experience of Excel and VBA. He was a member of the Support, Training and Documentation team within City University University’s IT department and has an MSc in Computing Science from Birkbeck. He has taught other evening classes for City University such as Oracle and SQL, XML, Excel and MS Office. He has also managed an academic programme within City University’s Continuing Education department.
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.
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.