Visual Basic for Applications (VBA) in Excel – Part 2 Short Courses
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
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.
|Start Date||Start Time||Duration||Cost||Course Code||Apply|
|Wednesday 4 October 2017||18:30 - 20:30||10 weekly classes||£560.00||CS2565||Apply Now|
|Wednesday 17 January 2018||18:30 - 20:30||10 weekly classes||£560.00||CS2565||Apply Now|
|Wednesday 2 May 2018||18:30 - 20:30||10 weekly classes||£560.00||CS2565||Apply Now|
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.