From the course: Excel for Marketers (2023)

Unlock the full course today

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

Building a performance dashboard

Building a performance dashboard - Microsoft Excel Tutorial

From the course: Excel for Marketers (2023)

Start my 1-month free trial Buy for my team

Building a performance dashboard

“

- [Instructor] It's important to track your performance against goals, and using Excel, you could build a performance dashboard that tracks your progress towards those goals. So the first one we want to see is the trend. And in this case we want to see the trend on conversions. How are we doing in terms of conversions against the spend that we're spending? The first one we want to do is just grab the cost and hit Insert, and then we want to show bar chart. In this case, we could also just show a line chart if we prefer. This is the bar chart and that's showing cost over time. We could also add in here the conversions over time as well. So we want to see, you know, how well are we doing against our conversion target, and sorry we're going to insert it in here. And then conversions. And we want to choose the axis label range to be the date. So they're both on the same X-axis and that's fine but we want them on…

Contents