Chevron Left
Back to Excel Basics for Data Analysis

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

4.8
stars
8,708 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

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!

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.

Filter by:

1426 - 1450 of 1,765 Reviews for Excel Basics for Data Analysis

By Stace S

•

Aug 6, 2024

The course is broadly good. However, some of the differences between expected behaviors between some basic Excel functions like the age old File>Save or Save As and some of the newer MS 365 "rename" vs the need to download your work from the cloud in order to then upload it again for grading can be less than intuitive. This problem is compounded by the fact that such differences are characterized as minor in the course lectures. While that might be the case, the differences between the modern MS 365 functionality is deviating rapidly enough from those of older, local Office installation versions shown for lecture examples that the course appears to need an overhaul to keep things consistent. I did learn quite a bit, particularly in the area of pivot tables which I had thought to be more complex than they actually are.

By Daniel J N C

•

Jul 27, 2021

An informative and practical course. I have enjoyed it. One big negative is the peer review as some people don't take the time to properly assess your work and you get marked down when you shouldn't. There are also a few flaws with the marking rubic examples which confuse people. I'd love the opportunity to discuss these with the course providers but I can't find any way of contacting them. If you come across the same problem, try resubmitting your work, it will be reviewed again by someone new and hopefully by someone who understands the marking scheme properly. It worked for me.

By Shreya D

•

Aug 11, 2023

I'm truly grateful for the "Excel Basics for Data Analysis" course, which significantly enhanced my skills despite my prior Excel knowledge. The well-structured content empowered me to understand new dimensions of Excel's functionalities, boosting my confidence in real-world applications. This course undeniably added substantial value to my Excel proficiency. The easily understandable content immensely improved my skills and insights, invaluable for my professional growth. I wholeheartedly recommend this course for those aiming to elevate their Excel expertise.

By Nkem A

•

Feb 26, 2021

Very good course however the lessons seemed less detailed towards the end when the topics equally got more complex. However the labs helps clarify a lot of things. Had a challenge with the final project because I should have had 100% based on the rubrics but the person who reviewed my work missed out some points. Though I still passed, it wasn't pleasant that there was no way to have this error corrected or reviewed without resubmitting my work and further delaying the completion of the course.

By B.K. W

•

Aug 27, 2022

GREAT refresher for those that have Excel under their belt and super course for those just starting out. Having never had to deal with Excel for the Web, myself, I found it a bit tricky flipping between the desktop version and the Web version.There are a few "huh?" moments in the course that really made me look for the answer myself as it wasn't really covered in the videos...but hey, I LOVE having my brain tested.

I'll likely come back to it, periodically, just to refresh my knowledge~

By Toyin B

•

Dec 5, 2022

Some of the videos had tiny fonts and very blurry in some of the videos. This slowed down the pace of learning had it being the fonts were bigger. Asides this, I really I am so fortunate to gather all the knowledge I need as a data analyst. The teachers were so good at teaching each modules and by far, this was my highest score and so far my most favorite course. I really enjoyed this course. This course is the bedrock of data analysis using excel. I look forward to the other courses

By Alexandria A

•

Jan 22, 2021

I liked learning about Excel through this course. The videos were very helpful in watching the processes happen in a sequential order. When it came time to do each module's hands-on lab, I found that to be somewhat difficult. The hands-on labs were kind of just random with not a lot of context and I did not feel like I was engaging with the material, at least in any realistic way. I think it would have been beneficial to work on the main objectives on the course more than once.

By Bahador S

•

Aug 9, 2024

The course is designed for people with almost no knowledge of MS Excel, so if you have previously worked with Excel you may skip forward the videos and just skip the lab assignments quite a lot. The final assignment also is a bit unclear and unfortunately, not all other learners (aka peers) take the course and reviewing assignments seriously, which can cause some issues as your course completion depends on it. Overall, not bad and I learned some new tips and tricks.

By Shermaine Y

•

May 2, 2023

Some of the answer guides in the peer-graded assignment are misleading. For example, the Part 2 assignment, where the first pivot table has to be sorted in descending order. The screenshot for the first pivot table creation was not sorted in descending order, hence our work will not be exactly the same as the screenshot. My grader has not given me the full 2 points for this, even though the first pivot table was created, and already sorted in descending order.

By Ananthoja M

•

Oct 11, 2022

Very good actually. The course is structured very well for beginners especially. I have given it 4 stars because the Lookup functions can be explained more clearly. I didn't understand the lookup function even after seeing it 2 times. So I had to rely on some other source like youtube to get a clear idea. So, Overall I can say it's a very good and well-structured course for beginners who want to get into data analysis or for anyone who wants to learn Excel.

By Mei-Yu H

•

Apr 21, 2023

This was great to start building basic and foundational skills in Excel! The provided learning materials were easy to understand and when there were more confusing things I could just rewatch and reread to grasp it better. Sometimes my mind wandered during the videos or I wasn't able to follow along with the labs but I just replayed them and kept trying until I got it down. Very good course for a beginner like me!

By May L

•

Nov 11, 2024

Generally good course that covers the main topics. Some of the instructions are not correct though and it means having to search through the forum for solutions, which is quite frustrating. More info on reviewing other learners' work would also be useful - it's seems pointless to have to answer every question when you have nothing to mark if the learner hasn't uploaded a file or hasn't done so correctly.

By Joye B

•

Jul 18, 2021

Overall, I do appreciate being able to learn how to apply Excel in Data Analysis. There are some things that could truly improve the course. On some of the videos, it was difficult to watch the screens to see the specific steps needed, and in at least one case, the spreadsheet we needed was available on the NEXT class. It would be helpful to have the files available within each week's classes.

By Joo N

•

Oct 21, 2021

Very informative, easy to follow, and covers a lot of information. My only complaint is that I feel it doesn't offer a whole lot of hands-on practice and application of the information. The labs provide very detailed information and step by step instruction, but I would prefer to achieve similar results based on my own understanding of the content rather than following the steps given.

By Margaret B

•

Mar 22, 2022

Occasionally, the instructions for the labs were difficult to follow and I think there were a couple times when they wanted me to do something that wasn't compatible with my version of the program. But overall it was a good amount of new topics covered while not being too advanced to follow. would recommend.

By Noy T

•

Feb 23, 2022

Very nice! but i think the excel part was a bit too basic. Also the IBM Cognos was too short because this looks like a very elaborate and effective platform. Morever, the IBM Cognos videos aren't clear and comprehensive as the rest of the course. But all in all, i'm satisfied :)

By Shahida R

•

Oct 2, 2023

The peer review portion for the final assignment is not the best. Given what the assignment was, it might've been better reviewed by instructors. Or, if not feasible, it should be easier to challenge grades, or reviewers should be made to explain their grading choices.

By sarya n

•

Jul 12, 2024

Course was well structured, videos were clear and informative, instructions for final project were very clear. I learned quite a lot and I think this is a great course for people with no experience in excel who want to grasp its capabilities for basic data analysis.

By Siddhanta R

•

Dec 24, 2022

While this curse has been great at helping me learn the basics and few advanced steps in excel, i truly believe that the course needs to be abit updated specially the quiz as a couple of the answer in quiz were different than the ones given by the mentors.

By DeejaiDJ

•

May 16, 2024

Good starting point and great labs and data for you to toy with. However, most of what we study is quite easy and can be easily found on Youtube, which is free. Still, the materials provided are much better than what you will find on a free platfrom.

By Val T

•

Jan 13, 2023

Videos were easy to follow and assignments were also a good test of our knowledge. Just wished the Excel templates used in the videos were shared with course participants ahead of time, so that we can practise along with the videos.

By Lasantha C

•

Feb 11, 2022

The peer review is the only one I am not happy with when the answer is correct the reviwer has marked it partially right. It looks like they havent gone through the review process properlly this is the second time this happened.

By Andrew K

•

Apr 18, 2022

It was very informative and helpful, but it was not Mac friendly. I had to look through several external resources to figure out what keyboard shortcuts could be used in place of the Windows shortcuts listed.

By Jessica C

•

Oct 27, 2022

I was pretty familiar with excel already, but this class definitely taught me some new tricks that I wasn't using. There was a breif lesson on Pivot, but I felt like that portion went really quick.

By Lim J

•

Sep 29, 2021

Great and easy to follow along. The final assignment works with a too simple and unrealistic data set. I would prefer the final assignment to be a bit more challenging and uses a real world data set.