Create a Marketing Analysis dashboard using G-Spreadsheets

提供方
Coursera Project Network
在此指导项目中,您将:

Enter any data set on google sheets, organize and format your rows and columns and create drop down lists.

Create basic query formulas related to the data set and translate formulas into dashboard and charts to help you better visualize your analysis.

Clock1 hour
Beginner初级
Cloud无需下载
Video分屏视频
Comment Dots英语(English)
Laptop仅限桌面

In this 1-hour long project-based course, you will learn how to enter any data set on google sheets, organize and format your rows and columns, create drop down lists, create basic query formulas related to the data set and finally translate those formulas into dashboard and charts to help you better visualize your analysis. This will help beginner market analysts to prepare reports and dashboards to present it to their managers. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

您要培养的技能

  • Google Spreadsheets
  • Charts
  • Marketing Strategy
  • Query formulas
  • Tables

分步进行学习

在与您的工作区一起在分屏中播放的视频中,您的授课教师将指导您完成每个步骤:

  1. Access google sheets and enter your data.

  2. Create drop down lists.

  3. Differentiate dissimilar data by color.

  4. Compose query formulas to create “Count” tables.

  5. Create Pie and Bar charts to present your data.

指导项目工作原理

您的工作空间就是浏览器中的云桌面,无需下载

在分屏视频中,您的授课教师会为您提供分步指导

常见问题

常见问题

还有其他问题吗?请访问 学生帮助中心