Chevron Left
Back to Excel Basics for Data Analysis

Learner Reviews & Feedback for Excel Basics for Data Analysis by IBM

4.8
stars
8,608 ratings

About the Course

Spreadsheet tools like Excel are an essential tool for working with data - whether for data analytics, business, marketing, or research. This course is designed to give you a basic working knowledge of Excel and how to use it for analyzing data. This course is suitable for those who are interested in pursuing a career in data analysis or data science, as well as anyone looking to use Excel for data analysis in their own domain. No prior experience with spreadsheets or coding is required - all you need is a device with a modern web browser and the ability to create a Microsoft account to access Excel online at no cost. If you have a desktop version of Excel, you can also easily follow along with the course. Throughout this course, you'll gain valuable experience working with data sets and spreadsheets. We'll start by introducing you to spreadsheets like Microsoft Excel and Google Sheets, and show you how to load data from multiple formats. From there, you'll learn how to perform basic data wrangling and cleansing tasks using functions, and expand your knowledge of data analysis through the use of filtering, sorting, and pivot tables. There is a strong focus on practice and applied learning in this course. With each lab, you'll have the opportunity to manipulate data and gain hands-on experience using Excel. You'll learn how to clean and format your data efficiently, and convert it into a pivot table to make it more organized and readable. The final project will allow you to showcase your newly acquired data analysis skills by working with real data sets and spreadsheets. By the end of this course, you'll have a solid foundation in using Excel for data analysis. You'll have worked with multiple data sets and spreadsheets, and will have the skills and knowledge needed to effectively clean and analyze data without having to learn any code. So let's get started!...

Top reviews

JR

Sep 26, 2022

Overall this was a refresher for me. I was able to reconnect with some of the Excel functions and can now apply those to my current job. The teachings and exercises I found useful and easy to follow.

FK

May 24, 2022

Wow, the practical (Hands on ) part is a boom! How did the course disigner/ instructor and the rest of the team involved manage to do that?

Also the review part....so well done and easy to follow!

Filter by:

26 - 50 of 1,749 Reviews for Excel Basics for Data Analysis

By Julieta C

•

Oct 4, 2020

Very basic; I didn't learn anything new.

By Amit K

•

Oct 24, 2020

This course is really well designed, one should must try this for basic learning of excel.

It's a wonderful experience to learn this course, it will definitely embrace my skills and going to help me to move forward in future.

By Gerlando T

•

Feb 24, 2022

el curso es bueno, te ayuda a como trabajar con datos sabiendo ediante atajos del teclado usando Excel, y no necesariamente debes trabajar con fuertes tecnologias. Me parecio util este curso

By Addo G

•

Aug 1, 2021

The course has really helped me become familiar with using Excel for data analysis. i recommend it for anyone who has no knowledge about how to use Excel and also for amateur Excel users.

By Abdullah A

•

Feb 14, 2021

Even though I have five years of experience in MS Excel, I have learned new tips and Infos from this course. I truly recommend it.

By Jeremiah L

•

May 20, 2023

Lots of broken links. The final project had a broken link to the dataset you're supposed to use, making it impossible to complete the course. I submitted something anyway, based on a different dataset, but with all the right steps taken, but my reviewer just gave me zeros on multiple steps that I clearly completed properly (no shock, since most people doing the reviews can't read English, and couldn't possibly have read my notes pointing out my reason for using a different dataset). The course content was fine, but if I'm being promised a certificate for doing the work, and you refuse to give it to me because of your stupid mistake and sloppy review system, then you're just scamming people. How this has almost 5 stars is beyond me.

By Rohan N K

•

Jan 30, 2021

Great Excel basic course provided by IBM. It made me learn many things about excel and its usage in various aspects of data analysis. Only thing I didn't enjoy is the computer sound used in all the videos. Because of the computer sound/artificial sound used, it lacked the personal touch one would enjoy. So I have only 2 suggestions to give :

1) Use a teacher/professor/expert who can teach us and take us through each and every aspect.

2) The assignments are sometimes difficult to complete because certain features are not available in certain excel versions

By Doug M

•

Nov 30, 2020

While fairly basic for people familiar with Excel, it ensures a good basis as one moves forward to have a solid foundation for data analysis. And there absolutely were a few tricks and shortcuts that I learned. Also very much appreciated that this was more hands-on than previous DA courses have been which is necessary to really gain understanding.

By Tori

•

Jun 2, 2021

Overly simplistic and takes a LONG time to explain the basics of Excel (3 of 5 weeks is devoted to "basic" functionality and familiarity with buttons). If this was a completely introductory course on Excel, sure, but this is for a professional certificate. I expect a little more substance and challenge. I learned a bit about PivotTables (much easier than older Excel versions), but nothing I didn't already know, and it didn't explain HOW they work and exactly WHAT they're used for and their specific benefits.

By Chase H

•

Dec 28, 2020

Overall, this is a very good basis excel course.

But, it doesn't provide enough hands-on projects. And students aren't able to verify the result of the projects.

Also, it only shows the short cut for windows excel, not for ios excel.

It still needs some improvement to make it better for the data analysts.

By Ifueko U O

•

Apr 4, 2021

I thoroughly enjoyed this course. The lessons are very easy to follow. I completed the hands-on labs and that further solidified the skills taught in the lessons. It's a fantastic course.

By Cathy W

•

Apr 9, 2021

Great overall course. While most of the Excel topics were things I was already using or familiar with, I did come away from the course with a few new skills in Excel.

By Omololu O

•

Oct 22, 2020

Great course. Really teaches you the basis. Only feedback is my name was spelled incorrectly on my certificate. But I'm sure that's an easy fix.

By Danielle O

•

Oct 14, 2020

Very detailed and easy to follow but could be improved by having a dummy excel sheets for the students to work and follow with the instructor.

By Affan A

•

Mar 17, 2021

I really liked this course - it was short, useful and to the point.

Thank you to all who contributed to such a great work.

By Elsa H

•

Jun 11, 2021

Very valueable class for basic excel skills.

By Palotás G A

•

Jan 10, 2024

I think the exercises are a bit backwards. Instead of starting with what the specific goal is when using a certain function or feature, they just list the steps that the student needs to follow without having to think and knowing why they are doing this. This decontextualized copying is not a very effective learning method, and it is not how we would you use Excel in real life either. First you have a problem, then you come up with the steps to solve it, not the other way around. For example, this is one of the exercises in Week 4: Task A: Use of VLOOKUP to look up data in a table organized vertically 1. Download the file indian_startup_funding_Lab6.xlsx. Upload and open it using Excel for the web. 2. In cell K2,L2,M2, type VLOOKUP, Startup Name, Amount in USD respectively. 3. Select and copy cells from C9 to C15 and paste in cell L3. 4. In cell M3, type =VLOOKUP(L3, C2:I113, 7, FALSE) and press Enter. 5. Formula: =VLOOKUP (value, table, col_index, [range_lookup]). 6. Hover over the bottom-right corner of cell M3, and drag the Fill Handle down to the cell M9. 7. Select cells from M3 to M9 and select Number Format>Currency. It could be easily transformed to be more engaging, interactive and effective, where students need to actually think and apply the skills they have just learned in practice, while they are also provided with hints and help along the way. For example: Task A: Preparation: 1.Download the file indian_startup_funding_Lab6.xlsx. 2.Upload and open it using Excel for the web. Instructions: You want to make a report about how much money the following startups managed to raise during their last fundraising: -Rein Games -CarDekho -Dhruva Space -Paytm -Aye Finance -Clumio -Digital Mall Asia Use the VLOOKUP function to retreive the necesseray data. (Here, a picture of the expected end result could also be shown, so students will have a point of reference to start, and they can also use it to check their solution. Just like in the original exercise, but without revealing the vlookup function. Let's not give away the solution straight away and let's let students experiment). (Hints: these could be all hidden and accessed through individual drop-down lists, so students will have autonomy to try on their own, but if they are stuck, they can just click on a 'Hint' button and get the help they need to move forward. If they are really stuck, they can reveal the solution by clicking on the "Solution" button.). Hint 1: First think about which columns you will need from the original data set. Then , you want to create a separate table for yourself where you can retieve the data. Name the columns of your new table accordingly. (This could, of course, be phrased with more suitable terminology, this is just an example). Solution 1: you will need the columns Startup Name and Amount in USD. In cell K2,L2,M2, type VLOOKUP, Startup Name, Amount in USD respectively. Hint 2: Then think about whether you need to narrow down the data in your columns. Solution 2: you only need the 7 startups mentioned above, so copy and past them to your new table. Select and copy cells from C9 to C15 and paste in cell L3. And so forth. This way you train students to be problem-solvers and to think like data analysts. And this is ultimately the goal of the course. Hope this helps!

By Jackie S

•

May 26, 2023

I strongly advise anyone using Coursera to ALWAYS double-check your peer-reviewed finals. Both peer-reviewed finals I have completed, on the first round of "peer-review" have been incorrectly graded. The only reason I know this is because I double-checked my grades and peer reviews. BOTH TIMES, the initial "peer-reviewer" has incorrectly graded my final, and the only recourse I could take is to re-submit my final, not knowing if the next :peer-reviewer" would actually grade correctly, according to the rubric. Just saying, double check your final grades, and fight for the grade you know you deserve.

By Evgeny T

•

Oct 29, 2020

very boring but practical

By Jennifer A

•

Aug 20, 2023

I wish the class was more interactive ....the pivot tables are new to me.

I rather have hands on practice when we are going through the chapters...less multiple choices.

I want motor-memory on my mouse and keyboard immediatley when learning something...

Tell me how to ride a bike on a visual....then the last chapter...here is your bike...hope you read the instructions good.....just idea for hands on learners...who are less words....

By Hon T

•

Mar 30, 2022

hello,

I am very mad with registering accounts ibm.

I paid 40$ each month. The course lasts 11 months, and I have only 1 month trial permission.

Do not mention promotion codes. I interupted when I used it.

Bad experiences.

By Anıl A

•

Jul 21, 2023

The people controlling the final project are incompetent. They misjudged even the simplest parts. Unbelievable!

By Alexia D

•

Dec 30, 2020

The course met my expectations, it gave me a glance at very important aspects and techniques of excel that even though I thought I knew, I didnt. I look forward to the future courses. I expect to feel like an expert by the time I finish the course. The theory explained and the practice tests are very advanced and right to the point.

By Maxyla B I P

•

Feb 22, 2023

Great course! The only drawback is the peer graded assignment. My assignment was graded blindly by someone that I reckon didn't even open my files. That kind of behaviour is pretty disheartening for someone who was really put all of their effort honestly.

By Melanie S

•

Mar 3, 2021

Fantastic course! So good to refresh some of my knowledge as well as learning new skills for cleaning, preparing and analysing data.