We may earn an affiliate commission when you visit our partners.
Developing for Excel with VBA
Mike McQuillan
Mike McQuillan
You’re an Excel power user. You can filter data and write formulas with the
best of them, But can you use VBA? If not, you’re not making the most of
Excel. Watch this course and learn how to build custom user applications
in Microsoft Excel.
Read more
You’re an Excel power user. You can filter data and write formulas with the best of them, But can you use VBA? If not, you’re not making the most of Excel. Watch this course and learn how to build custom user applications in Microsoft Excel.
Read more
You’re an Excel power user. You can filter data and write formulas with the best of them, But can you use VBA? If not, you’re not making the most of Excel. Watch this course and learn how to build custom user applications in Microsoft Excel.
Microsoft Excel is one of the most popular and used applications in the world, especially in business. Most people use it to manage data and run simple calculations. But did you know Excel has a programming language built into it, and it can do so much more? No? Then this is the course for you! In this course, Developing for Excel with VBA, you’ll gain the ability to create user applications in Excel using the Visual Basic for Applications language built directly into Excel. First, you’ll explore how to hook Excel up to a database, as well as how to manipulate that data using VBA. Next, you’ll discover how to build a user interface in Excel with VBA. Finally, you’ll learn how to make different Excel spreadsheets communicate with each other, and even how to generate PDFs straight from your Excel files. When you’re finished with this course, you’ll have the skills and knowledge of Excel VBA needed to create comprehensive and useful applications directly inside Excel.
Register for this course and see more details by visiting:
OpenCourser.com/course/4dddo0/developing
What's inside
Syllabus
Course Overview
Introducing VBA
Connecting Excel to a Database
Building a VBA Application in Excel
Read more
Syllabus
Course Overview
Introducing VBA
Connecting Excel to a Database
Building a VBA Application in Excel
Read more
Enhancing and Debugging a VBA Application
Sending Data to Different Workbooks with VBA
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Develops skills sought after by industry, which include the ability to build custom applications in Microsoft Excel
Taught by Mike McQuillan, who are experts in using Microsoft Excel
Suitable for intermediate learners who are familiar with data management and basic Excel formulas
Covers foundational concepts such as connecting Excel to a database and manipulating data using VBA
Provides practical guidance on building user interfaces in Excel with VBA
Students will learn how to share data between Excel spreadsheets and generate PDFs from Excel files directly
Save this course
Save Developing for Excel with VBA to your list so you can find it easily later:
Save
Save
Activities
Coming soon
We're preparing activities for
Developing for Excel with VBA.
These are activities you can do either before, during, or after a course.
Career center
Learners who complete Developing for Excel with VBA will develop knowledge and skills
that may be useful to these careers:
Business Analyst
Business Analyst
Business Analysts are responsible for gathering business needs from stakeholders and translating those needs into quantifiable technical requirements that programmers can use to build business systems. This course, Developing for Excel with VBA, can help you develop the skills necessary to become a successful Business Analyst. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Data Analyst
Data Analyst
Data Analysts use their skills in mathematics, statistics, and computer programming to extract meaningful insights from data. This course, Developing for Excel with VBA, can help you develop the skills necessary to become a Data Analyst. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Financial Analyst
Financial Analyst
Financial Analysts use their skills in mathematics, statistics, and computer programming to analyze financial data and make investment recommendations. This course, Developing for Excel with VBA, can help you develop the skills necessary to become a Financial Analyst. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Management Consultant
Management Consultant
Management Consultants help businesses improve their performance by providing advice on strategy, operations, and technology. This course, Developing for Excel with VBA, can help you develop the skills necessary to become a Management Consultant. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Operations Research Analyst
Operations Research Analyst
Operations Research Analysts use their skills in mathematics, statistics, and computer programming to solve complex business problems. This course, Developing for Excel with VBA, can help you develop the skills necessary to become an Operations Research Analyst. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain computer software. This course, Developing for Excel with VBA, can help you develop the skills necessary to become a Software Engineer. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Systems Analyst
Systems Analyst
Systems Analysts use their skills in mathematics, statistics, and computer programming to design and implement computer systems. This course, Developing for Excel with VBA, can help you develop the skills necessary to become a Systems Analyst. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Accountant
Accountant
Accountants use their skills in mathematics, statistics, and computer programming to prepare and analyze financial statements. This course, Developing for Excel with VBA, can help you develop the skills necessary to become an Accountant. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Auditor
Auditor
Auditors use their skills in mathematics, statistics, and computer programming to examine financial records and ensure that they are accurate and complete. This course, Developing for Excel with VBA, can help you develop the skills necessary to become an Auditor. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Budget Analyst
Budget Analyst
Budget Analysts use their skills in mathematics, statistics, and computer programming to develop and manage budgets. This course, Developing for Excel with VBA, can help you develop the skills necessary to become a Budget Analyst. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Credit Analyst
Credit Analyst
Credit Analysts use their skills in mathematics, statistics, and computer programming to assess the creditworthiness of borrowers. This course, Developing for Excel with VBA, can help you develop the skills necessary to become a Credit Analyst. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Financial Planner
Financial Planner
Financial Planners use their skills in mathematics, statistics, and computer programming to help clients achieve their financial goals. This course, Developing for Excel with VBA, can help you develop the skills necessary to become a Financial Planner. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Insurance Analyst
Insurance Analyst
Insurance Analysts use their skills in mathematics, statistics, and computer programming to analyze insurance risks and set insurance rates. This course, Developing for Excel with VBA, can help you develop the skills necessary to become an Insurance Analyst. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Investment Analyst
Investment Analyst
Investment Analysts use their skills in mathematics, statistics, and computer programming to analyze investment opportunities and make investment recommendations. This course, Developing for Excel with VBA, can help you develop the skills necessary to become an Investment Analyst. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
Quantitative Analyst
Quantitative Analyst
Quantitative Analysts use their skills in mathematics, statistics, and computer programming to develop and implement quantitative models for use in financial analysis and trading. This course, Developing for Excel with VBA, can help you develop the skills necessary to become a Quantitative Analyst. You will learn how to use VBA to automate tasks in Excel, which can save you valuable time and improve your efficiency.
For more career information including salaries, visit:
OpenCourser.com/course/4dddo0/developing
Reading list
We've selected six books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
Developing for Excel with VBA.
Save
A large book defining the ins-and-outs of everthing VBA and Excel can do together. Good to use as a reference guide, but may be difficult for those new to programming.
A comprehensive guide to VBA and Excel for more advanced users, this book is useful both as a reference text and for its more in-depth coverage of topics.
A book focused on the general principles of VBA as a programming language and software development. This good supplemental book for people learning object-oriented programming in VBA for Excel.
Introduces the very basics of VBA, and provides a reference for experienced VBA developers. Useful as a reference guide and to provide background to beginners.
Presents VBA from the perspective of solving common business problems. Useful as a collection of pre-built solutions in VBA that can be used as templates.
Collection of VBA code examples for Excel 2019. It covers a wide range of topics, from data manipulation to user interface design.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/4dddo0/developing
Share
Similar courses
Here are nine courses similar to
Developing for Excel with VBA.
Building Your First VBA Module
OpenCourser.com/course/sv0wsb/building
Building Your First VBA Module
Most relevant
Master Microsoft Excel Macros and Excel VBA
OpenCourser.com/course/xbx5em/master
Master Microsoft Excel Macros and Excel VBA
Most relevant
Excel/VBA for Creative Problem Solving, Part 2
OpenCourser.com/course/9u5bia/excel
Excel/VBA for Creative Problem Solving, Part 2
Most relevant
Excel/VBA for Creative Problem Solving, Part 1
OpenCourser.com/course/dsj8hv/excel
Excel/VBA for Creative Problem Solving, Part 1
Most relevant
Excel with Microsoft Excel VBA User Forms
OpenCourser.com/course/r4o68n/excel
Excel with Microsoft Excel VBA User Forms
Most relevant
Building Excel Online Automation with Office Scripts
OpenCourser.com/course/li6sgz/building
Building Excel Online Automation with Office Scripts
Most relevant
Essential VBA Training for Excel - Automate Repetitive Tasks
OpenCourser.com/course/dqoxpm/essential
Essential VBA Training for Excel - Automate Repetitive...
Most relevant
Microsoft Excel VBA and Macros
OpenCourser.com/course/uxfjmc/microsoft
Microsoft Excel VBA and Macros
Most relevant
Unlock Excel VBA and Excel Macros
OpenCourser.com/course/zavzrv/unlock
Unlock Excel VBA and Excel Macros
Most relevant
Time
157 hours
Level
Introductory
Via
Pluralsight
Instructor
Mike McQuillan
Language
English
Good to know
Develops skills sought after by industry, which include the ability to build custom applications in Microsoft Excel
Taught by Mike McQuillan, who are experts in using Microsoft Excel
Suitable for intermediate learners who are familiar with data management and basic Excel formulas
Covers foundational concepts such as connecting Excel to a database and manipulating data using VBA
Provides practical guidance on building user interfaces in Excel with VBA
Students will learn how to share data between Excel spreadsheets and generate PDFs from Excel files directly
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser