Chevron Left
返回到 Spreadsheets for Beginners using Google Sheets

學生對 Coursera Project Network 提供的 Spreadsheets for Beginners using Google Sheets 的評價和反饋

4.7
1,064 個評分
250 條評論

課程概述

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....

熱門審閱

SK

Aug 10, 2020

If you are looking for basics of excel sheet then this course has it all. Trust my words and patiently attempt this guide with practically doing things parallel. it will help you understand better.

RS

Aug 03, 2020

It was an wonderful learning and hats off to the instructor. Thanks a lot for the detail step by step guidance and explanation which makes the project very easy to understand and complete.

篩選依據:

26 - Spreadsheets for Beginners using Google Sheets 的 50 個評論(共 253 個)

創建者 Amanda J

Jun 19, 2020

This has the potential to be an excellent course however several factors meant I was not able to fully participate.

It seemed that the version I was using via the module was different to the instructor, there were several things that was being shown that was not available to me.

There were also several times that it is suggested to complete tasks but the way to complete them had not been shown.

There was also no instruction in relation to using the split screen, I found if very difficult to navigate given the size available, even in full screen this stayed mid size

As such I would not suggest that this is a true beginner course.

However if could be excellent with some corrections and a little additional instruction.

創建者 SARA

Jul 30, 2020

It was just what I needed to get started. You will learn the basics and some advanced options that can make your life way easier. The whole split screen approach is great and allows you to work as the instructor works. I took notes which were essential for me to take the last assignment. And also your spreadsheet is saved on your drive in case you need to come back and review the process.

創建者 VISHNUMAHANTHY M

Jul 27, 2020

This course is absolutely perfect for beginners who want to learn and master the fundamentals of spreadsheets. The split screen approach really gives an edge to this course where we could actually practise without minimising the course window. Overall, the instructor and the course was really engaging and informative.

創建者 Kamilah N

Aug 09, 2020

The course was very detailed. I learned a lot from this exercise. I did not even know Google Sheets was capable of doing this much in terms of manipulating data and presenting it. I will definitely be practicing some of the formulas and formatting techniques going forward.

創建者 Pavan B B

Aug 02, 2020

It's designed so magnificent that it made he course much more simpler to understand and apply it. Kudos to the designer. The instructor is too good and have great knowledge on the course. Highly recommend to join the course for beginners.

創建者 Alycia E

Jul 05, 2020

Even if you already have a basic understanding of this Google sheets, this course will definitely teach you something you never knew, especially if you're curious about sorting through tables full of data! Highly recommend!

創建者 vipin y

Aug 07, 2020

Excellent course designed to learn basic of Spreadsheets. Very helpful for a professional irrespective of domain. Instructor skills is up to the mark. Recommended for everyone who want to gain knowledge about Spreadsheets.

創建者 Ayushi V

Aug 01, 2020

I think this was a good tool to learn just enough of spreadsheet knowledge you will need to carry out most of your tasks with efficiency. This a basic level course you can complete in one sitting. I highly recommend it :)

創建者 Siddharth K

Aug 10, 2020

If you are looking for basics of excel sheet then this course has it all. Trust my words and patiently attempt this guide with practically doing things parallel. it will help you understand better.

創建者 Rekha S

Aug 03, 2020

It was an wonderful learning and hats off to the instructor. Thanks a lot for the detail step by step guidance and explanation which makes the project very easy to understand and complete.

創建者 Abhishek V N

Jul 26, 2020

Thank You Sir. Now I can implement the knowledge that I got throughout the course to analyze my personal expenses. I am Fully Satisfied.

創建者 Sushant K

Jul 03, 2020

Its a wonderful course and default knowledge of excel will be added point. Thank you teacher for your simple style to explain.

創建者 Ashley B

Jul 05, 2020

Great way to learn Google Sheets/Excel. Awesome hands-on desktop tool lets you work along side the instructor as you learn.

創建者 POONCHARAT W

Jul 16, 2020

It's great! Easy to understand and not too long lesson. I can use the skill from this for sure. Thank for your video.

創建者 Noel G

Jul 04, 2020

It was very resourceful ,Can you please the sent video of lecture in ungraded external tool for reference

創建者 Jay S

Jun 03, 2020

I really enjoyed this project. I learned so many thing about google spreadsheet from this online project.

創建者 Shikhar s

May 19, 2020

Nice project only complain is that due to net speed, the cloud platform hindered with the work a lot.

創建者 Johnson A M

Apr 19, 2020

Alex Margos is a great instructor. His in-depth knowledge is admirable. Thank you Alex Margos.

創建者 Satyabrata D

Jun 04, 2020

very informative, easy way of explanation, and live real practical official handling project.

創建者 Amal V B

May 13, 2020

In Rhyme, the video was buffering several times and took more time to complete the course.

創建者 Romana S

Jul 31, 2020

This covers almost all necessary functions and features that we need to use . Thank you .

創建者 Bonifasius B S A

Apr 27, 2020

very helpful . but it requires some improvements, especially when using third-party tools

創建者 Ramya G R

Jun 08, 2020

I really enjoyed working with this project. Thank you so much for the valuable teaching.

創建者 Disha

Jul 03, 2020

I really enjoyed the sections and the course design was easy to learn and understand.

創建者 Sachin D M

Jul 13, 2020

This course is very useful. I learned to prepare spreadsheet by using google sheets.