Visual Basic for Applications (VBA) in Excel, Building Applications | Part 3 Short Courses
For students who have successfully completed Visual Basic for Applications (VBA) in Excel | Part 2 or have knowledge of subjects therein, the Visual Basic for Applications (VBA) in Excel, Building Applications Part 3 short course includes customisation features such as classes and Add-ins, database-enabled web publishing, and integrating Excel VBA with functionality from other applications. In the process, students write complex, structured programs leading up to a large-scale working application.
Software version: MS Office 2010, especially MS Excel 2010 (compatibility with other versions such as Excel 2003 will be covered).
Software version: MS Office 2010, especially MS Excel 2010 (compatibility with other versions such as Excel 2003 will be covered).
Course Information
| Start Date | Start Time | Duration | Cost | Course Code | Apply |
|---|---|---|---|---|---|
| Monday 1 October 2012 | 18:30 - 20:30 | 10 weekly classes | £460.00 | CE2566 | Course Cancelled |
| Monday 29 April 2013 | 18:30 - 20:30 | 10 weekly classes | £460.00 | CE2566 | Apply Now |
Tutor Info
Dionisis Dimakopoulos graduated from the department of Mechanical Engineering at the Technological Educational Institute at Patras, Greece. He holds an MSc on E-Commerce from the University of Essex and is currently completing his research as a computer scientist at Birkbeck, University of London. His research interests are personalisation of web content, usability, semantic web, artificial intelligence and fuzzy logic.
He has implemented numerous projects in Java throughout his career, including desktop, mobile and web applications. He has also worked as a consultant for a wide range of applications written in VBA for Excel; some examples being applications that combine the power of Java web services with the familiar interface of Excel for engineering or financial applications, or offer interoperability with other Office applications. As vice president of the Java Hellenic User Group, his role is to expand the use of Java among beginners, as an easy to use and learn programming language suitable for current development needs.
Eligibility
Successful completion of Visual Basic for Applications (VBA) in Excel Part 2 or knowledge of subjects therein.
English Requirements
Applicants must be proficient in written and spoken English.What will I learn?
- Review: the Excel API; loops; control structures; arrays; subroutines and functions
- Interacting with other applications such as MS Word and MS Access
- Providing Help documentation for the user of the spreadsheet application
- Manipulating data in conjunction with databases, using ADO
- Parsing and publishing data over the Internet
- Class modules
- Add-ins
- Working with XML
- User Forms
Recommended Reading
Excel 2010 Power Programming with VBA (Mr. Spreadsheets Bookshelf), John Walkenbach, For Dummies
Excel 2010 VBA Programmer's Reference (Programmer to Programmer), John Green, Stephen Bullen, Rob Bovey, and Michael Alexander, Wrox
Automated Data Analysis Using Excel, Brian D. Bissett, Chapman & Hall/CRC