Introduction to Data Analysis Using Google Spreadsheet

4.5
96 个评分
提供方
Coursera Project Network
3,857 人已注册
在此免费的指导 项目中,您将:

Create a Google account and a google spreadsheet, read data into google sheets using various formats, understand formulas using references

Write formulas and functions quickly and easily with the point and click method, sort and use the paste special

Use the COUNT, COUNTA and ROUND functions, work with cell referencing to create a multiplication table and use the filter tool for easy shopping

在面试中展现此实践经验

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

In this 1-hour 40 minutes long project-based course, you will learn the basics like how to create a Google spreadsheet, how to read data into google sheets using various formats, understand formulas using references, how to write formulas and functions quickly and easily with the point and click method, paste special,, how to sort, filter, rounding functions and cell referencing. 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.

必备条件

No experience needed

您要培养的技能

Business IntelligenceData Analysis

分步进行学习

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

  1. Learn how to create a Google spreadsheet

  2. Learn how to read data into google sheets using various formats, understand formulas using references

  3. Learn how to write formulas and functions quickly and easily with the point and click method and paste special

  4. Learn how to sort and use the paste special

  5. Learn how to use the COUNT, COUNTA and ROUND functions

  6. Learn how to work with Cell referencing

  7. Learn how to work with the filter tool

指导项目工作原理

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

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

讲师

审阅

来自INTRODUCTION TO DATA ANALYSIS USING GOOGLE SPREADSHEET的热门评论

查看所有评论

常见问题

常见问题

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