Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Developing for Excel with VBA

via Pluralsight

Overview

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.

Syllabus

  • Course Overview 1min
  • Introducing VBA 22mins
  • Connecting Excel to a Database 25mins
  • Building a VBA Application in Excel 24mins
  • Enhancing and Debugging a VBA Application 34mins
  • Sending Data to Different Workbooks with VBA 48mins

Taught by

Mike McQuillan

Reviews

4.5 rating at Pluralsight based on 12 ratings

Start your review of Developing for Excel with VBA

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.