From the course: Excel Copilot: Building and Maintaining VBA Macros
Join today to access over 24,900 courses taught by industry experts.
Challenge: Automate reports with VBA and Copilot
From the course: Excel Copilot: Building and Maintaining VBA Macros
Challenge: Automate reports with VBA and Copilot
(bright music) - [Instructor] Now it's time for a challenge. Here's what I want you to do. Open the starter file called Report Automation Challenge, and follow along closely step by step. You've just received this month's sales data worksheet. Your director asks you to automate three specific tasks using VBA macros, and you'll use Copilot to help you write each one separately. Start by building a macro that formats your workbook data into a clean professional Excel table. Have it automatically resize the columns for a polished look, and then sort the table so that sales appear from highest to lowest. Next, you'll create an analysis macro to automatically highlight any salespeople who didn't meet their quotas. Have your macro bulldoze rows, and change the font color to red. Additionally, your director wants a simple column chart visualizing sales by salesperson, clearly visualizing employee performance. Finally, you'll…
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.
Contents
-
-
-
-
(Locked)
Automating report formatting with VBA and Copilot3m 59s
-
(Locked)
Automating PivotTables and charts with VBA and Copilot6m 25s
-
(Locked)
Automating report distribution with VBA and Copilot5m 26s
-
(Locked)
Challenge: Automate reports with VBA and Copilot1m 15s
-
(Locked)
Solution: Build polished report macros with VBA and Copilot5m 35s
-
(Locked)
-
-
-
-