Learn shortcuts for moving around a large data set quickly, as well as filtering and highlighting to make the sheet more readable.
- [Instructor] When you're dealing with…small amounts of data,…it's pretty easy to navigate in Excel…just by scrolling.…When you have lots of rows of data,…it's a different story.…We'll cover some tips and tricks for coping…with lots of data without wasting time…and loosely scrolling…This export of Google Analytics page report…has over 4,000 rows.…We can actually check this without scrolling…all the way down, by clicking into one of the cells…hitting command and then down arrow.…There you go, 4,700 cells.…To get back up to the top, we can hit command again…and then up arrow, and we're all the way back up to the top…straightaway without scrolling at all.…
You can also use right arrow and left arrow…with the command key to navigate…anywhere you want on the data sheet.…Another cool thing is you can select…all of the data if you hit command A.…Another cool thing is if you hit command and shift…and then one of the arrows, you can select…everything you move past.…This also works if you hit the down arrow,…you can select almost all the data there.…
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