From the course: Excel Copilot: Building and Maintaining VBA Macros
Join today to access over 24,900 courses taught by industry experts.
Automating PivotTables and charts with VBA and Copilot
From the course: Excel Copilot: Building and Maintaining VBA Macros
Automating PivotTables and charts with VBA and Copilot
- [Instructor] Let's explore how Copilot can assist us in using VBA to generate helpful summary pivot tables and charts, making it easier for our end users to understand and interpret the data. Please note that in this chapter, we'll be picking up right where we left off from video to video. That means for this video and the next one, you can keep working right in the same exercise file from the previous video and build upon your progress. But if you'd rather start fresh, I've also provided a new starter file for each video, which matches the completed state from the previous video. Either way, you'll be set up for success. So, let's start with the exercise file called pivottables-charts. We're going to pick up right where we left off with our formatted sales dataset. I am using the solution file that I had on file before, so it looks like before, the conditional formatting was red and now it's yellow, but the macro…
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)
-
-
-
-