From the course: Excel Copilot: Building and Maintaining VBA Macros
Join today to access over 24,900 courses taught by industry experts.
Challenge: Using prompts effectively for VBA
From the course: Excel Copilot: Building and Maintaining VBA Macros
Challenge: Using prompts effectively for VBA
(bright music) - [Instructor] All right. Time to put your VBA Copilot skills to the test with your first challenge. You'll be working on this exercise file named effective_prompts_challenge.xlsm, which contains a data set of customer support tickets. Your job is to build a macro that handles a couple of tasks your team regularly needs. First off, some previous coworkers had a nasty habit of hiding rows and columns, so your macro should unhide everything in the worksheet. Second, your team wants clear and visual conditional formatting applied to highlight any ticket older than seven days, I'm intentionally leaving some room here for you to experiment. Think about how your data is structured and whether Copilot can easily understand it. If your data isn't already in an Excel table, this could be a perfect chance to convert it. Tables often help Copilot grasp and handle data more effectively. If you hit a snag getting…
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.