Introduction to Data Analysis Using Google Spreadsheet

4.4
stars
58 ratings
Offered By
Coursera Project Network
1,862 already enrolled
In this Free Guided Project, you will:

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

Showcase this hands-on experience in an interview

Clock1 hour 40 minutes
BeginnerBeginner-friendly
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

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.

Requirements

No experience needed

Skills you will develop

Business IntelligenceData Analysis

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  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

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Instructor

Reviews

TOP REVIEWS FROM INTRODUCTION TO DATA ANALYSIS USING GOOGLE SPREADSHEET

View all reviews

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.