Chevron Left
Back to Excel Basics for Data Analysis

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

4.8
stars
7,234 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:

101 - 125 of 1,497 Reviews for Excel Basics for Data Analysis

By Nattamon S

Feb 8, 2021

Very Helpful

By Darrell P

Mar 5, 2021

Good Course

By Koumba K

Jan 17, 2021

It was nice

By Niroshan G

Mar 4, 2021

Very Good!

By Pentti L

Oct 2, 2020

Very good.

By kasichana m

Dec 30, 2020

Excellent

By Anderson J d S

Feb 19, 2021

Excelent

By Paul-Alexandre M

Feb 17, 2021

Great!

By Paul A

Feb 1, 2021

Good

By Vaishnavi G

Jan 30, 2021

Can I get credit for the IBM courses I completed.

I scored 97% grade for Excel basics for Data Analytics and 89% grade in Introduction to Data Analytics but it is mentioned as a non-credit course.

I have paid the fees for the courses and I need credit to be mentioned for the interview.

By Ángel M

Jan 12, 2021

Muy bueno aunque le he tenido que reportar un fallo en relación a cómo hacer un ejercicio (descripción incorrecta).

By Christian

Dec 20, 2020

Starts off a little slow but some useful bits as the weeks progress.

By Victoria M

Dec 10, 2020

Course could have gone into more in depth intricacies of Excel

By Hans A E

Nov 8, 2020

Very good and well presented with assessments and assignments

By Suraj G (

Nov 3, 2020

no focus on graph and visualisation

By John O

Oct 28, 2020

Just what I wanted!

By Louie D

Oct 5, 2020

A great course!

By Deleted A

Jan 11, 2021

good course

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 Aubrey A

Feb 26, 2023

It looks like some of the MS Excel for Web options have changed/been updated since this course was created, therefore some of the tasks (like converting CSV files to XLSX) are now automatically done. There are also minor discrepancies in the naming items in Excel vs. the course because of this change. Pivot tables are very important to Data Analysts I would like to have seen this lesson divided up further so not to inundate the learner with so much information. I think it should be noted that this course does not replace learning Excel in more detail.

By Ian M S

Feb 9, 2021

I like how the course is structured into easily identifiable parts and in sync with the data analysis process. It would be nice to have this information in a pdf too to make the information available to be read more easily which makes it easier to refer back to. There are also quite a few issues in some of the instructions/labs/assignments which I have flagged and I think should be fixed to make this a five star course.

By Shreesha Y N

Dec 22, 2022

Some of the important topics like pivot tables were not explained properly. The whole course needs improvement with regards to teaching style, like.... this course needed in-depth teaching from scratch for beginners like us. The video quality and audio quality should have been better. Learned a lot about excel from youtube in an easy way than this IBM excel course.

By Abi K

Dec 3, 2020

It would be great if this was an elective. I would like to receive the Data Analytics certificate and the assumption was made that people taking this series don't have basic excel skills. it would have been great to be able to opt out of this and still get the certificate as a finance professional who has been using excel for many years.

By Leonardo S

Feb 27, 2023

In Task 7 Part 2 I couldn't upload the complete project simply because both Excel online and Excel desktop have changed its layout so I couldn't find the right tabs, tools, and panes to complete the tasks as described.

Very frustrating. Will not recommend.

By Claire J

Sep 10, 2021

A lot of inconsistencies between the hands-on work instructions and the grading rubric, making it very easy to fail the labs and become confused on what you are suppose to be doing and if you are doing it right. This needs to be fixed in this course. Otherwise, it discourages people from even finishing the course at all. I got marked off on my final project during peer review solely based on a rubric that was completely different than the spreadsheet I was given for the project. I lost almost 1/3 of the points because my answers (which were right) were graded against a rubric that did not even correspond to the spreadsheet project. I understand that IBM wants to change the spreadsheets regularyl to deter cheating, but they also have to change the lab instructions to correspond with whatever version of excel is publicly available and change their grading rubric to match the new spreadsheet that they provide as well.