From the course: Excel for Marketers

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Challenge: Excel skill roundup: Marketing data preparation

Challenge: Excel skill roundup: Marketing data preparation - Microsoft Excel Tutorial

From the course: Excel for Marketers

Start my 1-month free trial Buy for my team

Challenge: Excel skill roundup: Marketing data preparation

“

(upbeat music) - [Instructor] Congratulations, you've made it to your first challenge. This is your opportunity to test what you've learned so far about preparing marketing data in Excel. I'm going to walk you through five multiple choice questions. Feel free to pause and consider your response before moving on to the next one. We'll review the answers in the following video. Question one. Which of the following is the most important first step when reviewing marketing data sources? A, deleting unnecessary rows and columns immediately. B, identifying the purpose and context of each data source. C. Renaming all fields to match a standard naming convention. D. Sorting the data alphabetically by campaign name. Question number two, You are working with marketing data that includes fields for cost, clicks, and impressions. What is the best practice to ensure these fields are ready for analysis? A. Convert all numeric fields to text format for consistency. B. Filter out any rows with zero…

Contents