Excel Tricks for Marketers
Posted: February 10, 2015
Microsoft Excel is a pretty common program used by many professionals. Marketers may not think they have any use for Excel, but nothing is further from the truth. These ten tricks can help make everyday marketing tasks a breeze.
Justin Pavoni, writer for Hubspot, shares how to use Excel in marketing.
Excel is a useful tool for a number of marketing tasks. The two most important uses that I have for Excel on a weekly basis is first, as a research tool while writing (e.g. to get original statistics for a blog), and perhaps more obvious and more common, for data analysis and reporting.
With that in mind, here are ten tricks to help you get more proficient at Excel.
1) How to Summarize Data with a Pivot Table
What is a pivot table? A “Pivot Table” is a spreadsheet functionality that allows you to arrange and categorize tabular data.
Why are pivot tables important? Data is useful only if you can summarize and extrapolate meaningful trends from it. Pivot Tables help you do exactly that.
Read the entire article
10 Excel Tricks Every Marketer Should Know on
Hubspot.
**Note - Where the article mentions the CMD key - used on Apple devices - you can use the CTRL key on Windows devices with the same result.