Chevron Left
Back to Excel Basics for Data Analysis

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

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

LJ

Invalid date

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.

TH

Invalid date

Great course, even for those people that are using Excel every day, this course shows quite a few different ways to improve your abilities to present the data and best practices for cleaning dat.

Filter by:

1326 - 1350 of 1,669 Reviews for Excel Basics for Data Analysis

By عمر ا

•

Nov 17, 2023

yes

By Abdirisak M G

•

Sep 17, 2023

Top

By Nguyen V T F

•

Jul 22, 2023

Goo

By John O

•

Mar 11, 2023

HI

By JAVIER M A B

•

Nov 14, 2022

ok

By Jaka P

•

Nov 14, 2022

ok

By ashveen k a

•

Jul 3, 2022

..

By Rohit S

•

Apr 12, 2022

no

By Rúben D M S

•

Nov 20, 2021

w

By Abdullah - S

•

Aug 23, 2023

o

By Anita S

•

Aug 23, 2023

By Thomas P

•

Jun 23, 2023

✕

By Archana R

•

May 11, 2023

5

By Suleman M A

•

Jan 11, 2023

n

By JORGE V N A

•

Nov 5, 2022

.

By Tareq A

•

Sep 28, 2022

m

By Theerthesha

•

Aug 27, 2022

C

By vanam c b

•

Jun 6, 2022

.

By Taher E

•

Mar 9, 2022

By ghaith a

•

Nov 8, 2021

♥

By Evelyn S

•

Aug 27, 2021

.

By Kenny D

•

Jun 16, 2021

By Jill F

•

Mar 3, 2023

I'm an experienced Excel user, but this course introduced me to some new tricks, such as the use of Flash Fill and the SUMIF function that will be helpful. If you're relatively new to Excel, you should find this course very satisfying.

A few things such as VLOOKUP are touched on too briefly. The pivot table segment is a good intro, but more detail is needed to explain WHY you might want to construct your table in a particular way. Complementary reference materials would be helpful.

The course is oriented toward data analysis in the business sector. Wish there was more consideration of Excel use in research contexts.

The lab activities allow you to try out the features covered in the course, and help familiarize you with concepts, but more depth would be needed to develop proficiency.

I'd love to see this course provide examples of how to document the "data cleaning and wrangling" steps in Excel. This seems like an important omission to address.

The assignments and grading process are straightforward and relatively easy to complete. It would be great to offer optional assignments for folks like me who are eager for more advanced exercises.

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.