Excel for Marketers

As a Marketer, it’s incredibly important to have up-to-date, clean data. In this lesson we apply some common edits to unusable data to clean it up for use.

This lesson will show you COUNTIF and COUNTIFS that will allow you to quickly gather insights from your data based on the frequency of information.

XLOOKUP and VLOOKUP enable you to merge data to add greater context to the data.

If you have a large dataset, it’s easy to get overwhelmed with too much information. Sorting and filtering help you reduce large amounts of data so that you can focus on only the relevant data.

You often need to make sense of data using a variety of reports and stats. Pivot tables help you do just that.

In our quest to visually represent data, a chart is indispensable.

Having a macro-level - or a birds-eye view - of your marketing efforts is essential. It allows you to see trends, make better business decisions, and point out areas to investigate.

Power Query automates the process of getting data into a table and performing routine edits.