Back to Spreadsheets for Beginners using Google Sheets
Coursera

Spreadsheets for Beginners using Google Sheets

This 2-hour long project-based course is an introduction to spreadsheets. We’ll be using Google Sheets in this project, which is the free spreadsheet program offered by Google. With that said, most of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as Microsoft Excel. We will cover the following concepts in a hands-on manner: - Basic data entry, formatting and calculations - Relative and absolute cell references - Basic functions: concatenate, split, sum, average, median, min, max, count, counta - Advanced functions: vlookup, if, and, or, iferror, countif, countifs, averageif, averageifs, sumif, sumifs - Dealing with error messages - Conditional formatting - Filtering and sorting - Basic charts to visualize our data We will end the project by applying these concepts and create a basic spreadsheet model that helps us analyze household expenses. Note: If you don't have a Google account, you will need to create one to be able to complete the content.

Status: Excel Formulas
Status: Microsoft Excel
BeginnerGuided Project3 hours

Featured reviews

SP

5.0Reviewed Feb 25, 2022

The project gives great insights into the massive possibilities that spreadsheet offers. I recommend this course to every beginner who wishes to develop a skill in spreadsheets.

MA

5.0Reviewed Oct 19, 2020

So Excellent Nice 1st like and comment yesss n view stay connected always. Nice vedio big like👍🔔🔔🔔Done I hope you come back,#MyTv786,👍👍👍👍❤️ 💙💛🌸🌸🌺🌺💜💖🌹🍃💞💝🌱🌷💐💕https://bit.ly/2PBEung

BS

5.0Reviewed Aug 29, 2020

The Course is too good for beginners just try it ones' you will learn very good basic things about Excel. A good approach by the instructor It's a unique way to study the project in Excel.

TM

5.0Reviewed Sep 30, 2020

This has been a wonderful experience learning the core of using excel and google sheets in details, understanding the use of every function and formulas and their application in real world problems

D

5.0Reviewed Jun 2, 2020

This project was great. I always wanted to upgrade my Spreadsheet skills as I was proficient in Docs and Slides. Coursera is a wonderful platform for enhancing skills from home.

AS

4.0Reviewed May 27, 2020

The Guided project is insightful. The best aspect is the side-by-side practise and implementation. It starts with the basics and tends to cover all aspects associated.

MM

4.0Reviewed Oct 27, 2020

I don't know if it was my computer or my internet connection that made my workspace so slow to the extent that it would not respond. Other than that it was a nice learning experience.

AO

5.0Reviewed Jun 11, 2020

Recommended for beginners who are willing to take some time out of their daily schedule for some extra practice. Some concepts are very fast-paced but all are explained with examples.

FK

4.0Reviewed Sep 19, 2020

Overall it's good course, with good instructor, but for me i don't really do well with the cloud desktop, so i prefer to watch the video, and do the project on my own desktop

CC

4.0Reviewed Jan 4, 2021

I really enjoyed the knowledge shared on this course. My only complaint is the workspace screen was really laggy, which made the experience a bit frustrating at times.

MM

5.0Reviewed May 26, 2020

The explanation is good and practical . If you are interests in knowledge in the flied you can it . It will help you to understands about google sheet and usage of it.

RC

5.0Reviewed Oct 27, 2020

I have learned a lot that I didn't know that there were still a lot of functions that are very beneficial and very useful especially in doing the daily tasks about excel and spreadsheets.

All reviews

Showing: 20 of 533

Amanda J
3.0
Reviewed Jun 19, 2020
Mehraj K M
5.0
Reviewed May 9, 2020
Cleotilde T. Francisco
5.0
Reviewed Jun 2, 2020
Eve Famutimi
5.0
Reviewed Jun 11, 2020
Javier Barragán
5.0
Reviewed May 1, 2020
Mario A Chamorro
5.0
Reviewed Apr 4, 2020
Alok Upadhyay
5.0
Reviewed Jun 17, 2020
Hector Cruz
5.0
Reviewed Jul 18, 2020
Franklyn O'neal John Van Sichem
5.0
Reviewed Jun 3, 2020
Charice Burillo Ursos
5.0
Reviewed Jun 16, 2020
Arvindh Ramanna K (M\C Building )
3.0
Reviewed Jul 25, 2020
Preethi Evelyn Sadanandan
5.0
Reviewed Sep 19, 2020
Kashish Gupta
5.0
Reviewed Jun 15, 2020
Muhammad Murad Siddiqui
5.0
Reviewed Sep 18, 2022
Muhammad Usman Farooq
5.0
Reviewed May 28, 2020
Themba Mcira
5.0
Reviewed Oct 1, 2020
Siddharth Kombe
5.0
Reviewed Aug 10, 2020
Adelly Josefina González Ortiz
5.0
Reviewed Jun 12, 2020
Deleted Account
5.0
Reviewed Jun 3, 2020
Dr. U. Fathima Farzana
5.0
Reviewed Jun 3, 2020