We may earn an affiliate commission when you visit our partners.
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
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in Developing for Excel with VBA with these
activities:
Join a study group or online forum for VBA users
Show steps
Joining a study group or online forum will provide you with support and encouragement from other VBA users.
Show steps
-
Search for study groups or online forums dedicated to VBA.
-
Join a study group or online forum and participate in discussions.
-
Ask questions and share your knowledge with others.
Review Excel basics
Show steps
Refreshing your understanding of Excel basics will help you build a stronger foundation for learning VBA.
Browse courses on
Excel Basics
Show steps
-
Review the Excel help documentation on basic functions and formulas.
-
Create a simple spreadsheet and practice entering data, formatting cells, and using basic formulas.
Follow online tutorials on VBA
Show steps
Following online tutorials will provide you with hands-on practice and help you learn the basics of VBA.
Show steps
-
Search for online tutorials on VBA for Excel.
-
Choose a tutorial that covers the basics of VBA, such as creating macros and using variables.
-
Follow the steps in the tutorial and complete the exercises.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Create a VBA macro to automate a repetitive task
Show steps
Creating a VBA macro will help you apply your VBA skills to a practical problem and improve your understanding of VBA's capabilities.
Show steps
-
Identify a repetitive task that you perform in Excel.
-
Record a macro that performs the task.
-
Open the VBA editor and examine the recorded code.
-
Modify the code to customize the macro's behavior.
-
Run the macro and test its functionality.
Read VBA Programming for Excel
Show steps
Reading this book will supplement your understanding of VBA and provide additional examples and exercises.
View
Excel VBA Programming For Dummies 5th Edition...
on Amazon
Show steps
-
Read chapters 1-3 to get an overview of VBA.
-
Complete the exercises in chapters 1-3 to practice writing VBA code.
Build a user interface in Excel using VBA
Show steps
Building a user interface will help you develop your VBA skills and create more user-friendly Excel applications.
Show steps
-
Design the user interface, including the layout of buttons, menus, and other controls.
-
Create the VBA code to implement the user interface.
-
Test the user interface and make any necessary adjustments.
Create a complete VBA application for a specific business need
Show steps
Creating a complete VBA application will challenge you to apply all of your VBA skills and knowledge to a real-world problem.
Show steps
-
Identify a business need that can be addressed with a VBA application.
-
Design the application, including the user interface, data structures, and algorithms.
-
Develop the VBA code for the application.
-
Test the application and make any necessary adjustments.
-
Deploy the application to users.
Join a study group or online forum for VBA users
Show steps
Joining a study group or online forum will provide you with support and encouragement from other VBA users.
Show steps
Show steps
Show steps
- Search for study groups or online forums dedicated to VBA.
- Join a study group or online forum and participate in discussions.
- Ask questions and share your knowledge with others.
Review Excel basics
Show steps
Refreshing your understanding of Excel basics will help you build a stronger foundation for learning VBA.
Browse courses on
Excel Basics
Show steps
Show steps
Show steps
- Review the Excel help documentation on basic functions and formulas.
- Create a simple spreadsheet and practice entering data, formatting cells, and using basic formulas.
Follow online tutorials on VBA
Show steps
Following online tutorials will provide you with hands-on practice and help you learn the basics of VBA.
Show steps
Show steps
Show steps
- Search for online tutorials on VBA for Excel.
- Choose a tutorial that covers the basics of VBA, such as creating macros and using variables.
- Follow the steps in the tutorial and complete the exercises.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Create a VBA macro to automate a repetitive task
Show steps
Creating a VBA macro will help you apply your VBA skills to a practical problem and improve your understanding of VBA's capabilities.
Show steps
Show steps
Show steps
- Identify a repetitive task that you perform in Excel.
- Record a macro that performs the task.
- Open the VBA editor and examine the recorded code.
- Modify the code to customize the macro's behavior.
- Run the macro and test its functionality.
Read VBA Programming for Excel
Show steps
Reading this book will supplement your understanding of VBA and provide additional examples and exercises.
View
Excel VBA Programming For Dummies 5th Edition...
on Amazon
Show steps
Show steps
Show steps
- Read chapters 1-3 to get an overview of VBA.
- Complete the exercises in chapters 1-3 to practice writing VBA code.
Build a user interface in Excel using VBA
Show steps
Building a user interface will help you develop your VBA skills and create more user-friendly Excel applications.
Show steps
Show steps
Show steps
- Design the user interface, including the layout of buttons, menus, and other controls.
- Create the VBA code to implement the user interface.
- Test the user interface and make any necessary adjustments.
Create a complete VBA application for a specific business need
Show steps
Creating a complete VBA application will challenge you to apply all of your VBA skills and knowledge to a real-world problem.
Show steps
Show steps
Show steps
- Identify a business need that can be addressed with a VBA application.
- Design the application, including the user interface, data structures, and algorithms.
- Develop the VBA code for the application.
- Test the application and make any necessary adjustments.
- Deploy the application to users.
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