VBA in Excel, Building Applications Part 3
Program Overview
This advanced VBA in Excel course builds on previous knowledge, introducing advanced techniques like classes, add-ins, database manipulation, and web publishing. Participants will develop complex applications, culminating in a large-scale working project. The course is delivered online by an experienced instructor, and participants receive a certificate upon completion.
Program Outline
VBA in Excel, Building Applications Part 3: Short Course
Degree Overview:
This advanced short course builds on Visual Basic for Applications (VBA) in Excel Part 2, introducing a wider range of objects and applying previously learned programming constructs to more complex and robust programs. Participants will gain mastery over advanced VBA techniques such as classes and add-ins, database-enabled web publishing, integrating Excel VBA with functionalities from other applications, and Ribbon adaptation. They will write complex, structured programs, culminating in a large-scale working application.
Outline:
- Review: This section revisits the Excel API, loops, control structures, arrays, subroutines, and functions to ensure a strong foundation for the advanced topics.
- Interacting with other applications: Participants will learn to leverage VBA to communicate with other applications like MS Word and MS Access, enabling seamless data transfer and automation across various programs.
- Help documentation: Providing clear and concise help documentation for users of the spreadsheet application becomes paramount for user experience. Participants will learn how to implement comprehensive and intuitive help features within their VBA creations.
- Database manipulation: Working with databases in conjunction with VBA using ADO becomes an essential skill for data-driven applications. Participants will learn how to extract, manipulate, and analyze data from databases through VBA scripting.
- Parsing and publishing data: Integrating Excel VBA with web technologies allows for parsing and publishing data over the internet. Participants will learn how to leverage VBA to fetch data from the web, analyze it, and publish results in a user-friendly format.
- Class modules: This advanced topic introduces participants to the concept of classes in VBA, allowing them to create reusable and modular code components for more efficient and well-structured programming.
- Add-ins: Building custom Excel add-ins offers a powerful way to extend the functionality of Excel and personalize the user experience. Participants will learn how to develop add-ins with specific features and functionalities.
- Working with XML: Understanding how to handle and process XML data becomes increasingly important in the modern digital landscape. Participants will learn how to use VBA to parse, manipulate, and generate XML data.
- User Forms: Building intuitive and interactive user interfaces is crucial for user-friendly applications. Participants will learn how to design and implement custom user forms with various input elements and controls using VBA.
Assessment:
While no formal assessment is part of this short course, participants are encouraged to actively engage with the course material, apply their learnings through individual projects, and seek feedback from the instructor for continuous improvement.
Teaching:
The course is delivered by an experienced VBA specialist with a proven track record of teaching and practical application. Participants will benefit from a personalized learning environment within small group settings, ensuring ample opportunities for interaction and individualized guidance.
Careers:
Completion of this advanced VBA course equips participants with highly sought-after skills in the current job market. They can pursue careers as VBA developers, automation engineers, data analysts, and business intelligence specialists across various industries.
Other:
- The course is delivered in a flexible online format, allowing participants to learn at their own pace and convenience.
- Participants receive an official City, University of London certificate upon completion of the course, signifying their acquired skills and knowledge.
Conclusion
VBA in Excel, Building Applications Part 3 offers a comprehensive and in-depth learning experience for individuals seeking to master advanced VBA techniques and build complex applications. Through its rigorous curriculum, experienced instructor, and flexible delivery format, this short course equips participants with valuable skills for diverse career opportunities in the ever-evolving digital landscape.
City University of London
Overview:
City, University of London is a public research university located in London, England. It is known for its focus on business, practice, and the professions, offering a wide range of undergraduate and postgraduate programs. The university is renowned for its strong academic reputation and its commitment to providing students with a high-quality learning experience.
Services Offered:
City University of London provides a comprehensive range of services to its students, including:
Library Services:
Access to extensive library resources, including books, journals, databases, and online resources.Moodle:
An online learning platform for accessing course materials, submitting assignments, and communicating with instructors.Email:
A university-provided email account for official communication.Staff Directory:
A searchable directory of staff members and their contact information.Term Dates:
Information on the academic year and term dates.Room Booking:
A system for booking rooms on campus for meetings, events, and other purposes.Schools and Departments:
Information on the various schools and departments within the university.Student Life and Campus Experience:
City University of London offers a vibrant and diverse student experience, with a strong emphasis on:
London Experience:
The university's location in London provides students with access to a wide range of cultural, social, and professional opportunities.Sports:
A variety of sports clubs and facilities are available for students to participate in, both competitively and non-competitively.Social Activities and Groups:
Numerous student societies and groups cater to diverse interests, providing opportunities for social interaction and personal development.Student Wellbeing:
The university offers a range of support services to ensure students' health and wellbeing, including learning support, personal tutoring, and counseling.Career Development:
The university provides career guidance and support services to help students prepare for their future careers.Key Reasons to Study There:
Strong Academic Reputation:
City University of London is consistently ranked highly in national and international rankings.Focus on Business, Practice, and the Professions:
The university's programs are designed to provide students with the skills and knowledge they need to succeed in their chosen careers.Location in London:
The university's location in the heart of London provides students with access to a wealth of opportunities.Vibrant Student Life:
City University of London offers a diverse and engaging student experience.Excellent Career Support:
The university provides comprehensive career guidance and support services.Academic Programs:
City University of London offers a wide range of academic programs across various disciplines, including:
Business and Management:
Bayes Business School is renowned for its programs in finance, accounting, marketing, and entrepreneurship.Law:
The City Law School is a leading institution for legal education, offering programs in law, international law, and legal practice.Health and Psychological Sciences:
The School of Health & Psychological Sciences offers programs in nursing, midwifery, psychology, and other health-related fields.Science and Technology:
The School of Science & Technology offers programs in computer science, engineering, mathematics, and other STEM fields.Communication and Creativity:
The School of Communication & Creativity offers programs in journalism, media, performing arts, and language studies.Other:
Merger with St George's:
City University of London has merged with St George's, University of London, forming a new institution called City St George's, University of London.Awards and Accreditations:
The university has received numerous awards and accreditations for its teaching, research, and commitment to equality and diversity.Global City:
City University of London is a global institution with a strong international presence.University of London:
City University of London is a member of the University of London, a federation of 18 independent colleges and institutes.Entry Requirements:
- Students seeking admission to this programme must hold a valid undergraduate degree in any discipline from an approved higher level education institution in England, Wales or Northern Ireland.
Language Proficiency Requirements:
- For students with undergraduate qualifications that were not taught wholly in English the following English test is normally required for an IELTS test (Academic Module, taken within two years): IELTS 7 (overall score) and no less than 8 in Writing. The Writing score requirement may be waived if an undergraduate UK honours degree has already been obtained or, in the opinion of our English for Academic Studies (EAOS) assessors, it is clear, through discussion of previous study work, that such skills have already been established.
