From the course: Excel Copilot: Building and Maintaining VBA Macros
Join today to access over 24,900 courses taught by industry experts.
Automating complex data tasks with VBA and Copilot
From the course: Excel Copilot: Building and Maintaining VBA Macros
Automating complex data tasks with VBA and Copilot
- [Instructor] Now that we understand the loops in conditional logic in VBA, let's explore a realistic scenario where VBA uniquely handles complex and dynamic data management tasks supported by Copilot. To follow along with the scenario, open up the complex-data workbook. The workbook includes initially clean data on a preliminary master table and validation rules on a reference table. Our goal is to use VBA and Copilot to automate detailed data validations, clearly log errors, and apply precise pricing adjustments, making complex granular data tasks efficient, accurate, and user-friendly. So we'll fire up Copilot and we'll start with a data validation prompt here. So we'll go through the rows in the preliminary master worksheet. We're going to look for product IDs. We only want numeric values here. And if you know Excel, you'll see that some of these actually are not numeric values. We want to see that category…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.