Tired of doing repetitive, boring tasks? Learn how to automate them with Excel macros.
- [Lecturer] Now, chances are, you're going to be doing…a lot of repetitive work in Excel.…The good news is that anything you can do in Excel…can actually be automated with macros.…If you'd like to follow along, go to Exercise File 4.5,…Intro to Task Automation with Macros.…First we need to enable the Developer tab…in the ribbon bar.…So to do that, and this is going to be really different…depending on your version of Excel,…you can go up to Excel, Preferences,…and it might be in this part, right here,…Ribbon and Toolbar.…
Or, for me, it's in View.…I'm just going to go to Developer tab, here.…Now that we have the Developer tab, let's take a look.…So, the only thing we really need to cover here…is how to record a macro and, then, what a macro looks like.…So, let's try that.…I'm going to hit Record Macro,…give it a name.…Let's call it CleanUp.…Now, say this worksheet is the type…of report I get on a regular basis…and I go through some really repetitive tasks…to clean it up.…
So, let's go through those tasks.…I'm just going to select these top rows and delete them.…
Michael begins with the basics, showing how to work with marketing data sources and explaining basic formulas for analysis. Next, he walks through how to build a data-driven marketing plan, including mapping out your marketing funnel, reviewing volume vs. cost tradeoff, and running A/B testing. Michael shows how to analyze a campaign's performance, working with PivotTables, charts, and dashboards. Finally, he demonstrates how to set up marketing campaigns in bulk, including manipulating text for ad copy generation and automating the most boring, repetitive tasks with macros.
- Cleaning up data formatting
- Using formulas for analysis
- Building a data-driven marketing plan
- Top-down vs. bottom-up marketing plans
- Running A/B tests
- Analyzing campaign performance
- Plotting data visually
- Building report templates and dashboards
- Building bulksheets for bulk campaigns on AdWords and Facebook