Chevron Left
Back to Preparing Data for Analysis with Microsoft Excel

Learner Reviews & Feedback for Preparing Data for Analysis with Microsoft Excel by Microsoft

4.7
stars
5,086 ratings

About the Course

This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. No prior skills are needed to be successful in this course. In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis.  Specifically, this course will help you gain knowledge and skills for preparing data for analysis using Microsoft Excel and take you one step closer to becoming a Microsoft Power BI Analyst.  After completing this course, you’ll be able to:  • Create data in Microsoft Excel and prepare it for data analysis.  • Make use of common formulas and functions in a worksheet.  • Prepare Excel data for analysis in Power BI using functions. ...

Top reviews

FA

Nov 8, 2024

A comprehensive and engaging course that transformed my Excel skills, equipping me with practical tools for efficient data analysis and problem-solving.

SR

Jul 24, 2024

Very useful to learn and understand how to look the data's in worksheet and how to solve any mistakes or errors by formatting and declaring the functions and editing in excel.

Filter by:

1 - 25 of 996 Reviews for Preparing Data for Analysis with Microsoft Excel

By Nikolaos G K

•

Aug 29, 2023

A real waste of time...While it was supposed to be preparation for Power BI, the course was focused on very basic principles of Excel. The worst interaction regarding the exercises as you had to descriptively describe the steps you would follow in excel. I hope the next courses will be more interesting and have more useful exercises and tests.

By Nitin P

•

Oct 6, 2023

too basic. course is purely meant for someone who is using Excel for the first time.

By Oleksii S

•

Sep 4, 2023

Mid course. Macquarie University has much better course. With good tests and interesting practical exersices.

By SUZANNE E

•

Aug 29, 2024

if you have experience with basic function with Excel you may find this for beginners, but this is good foundation for people who don't have a solid ground with Excel Function

By Santhosh R

•

Jul 25, 2024

Very useful to learn and understand how to look the data's in worksheet and how to solve any mistakes or errors by formatting and declaring the functions and editing in excel.

By Saloria S

•

Sep 24, 2023

This was pretty good, pretty good. I'm glad Microsoft came out with this certifications, especially the many changes in technology. And also, the instruction was great!

By Greg O

•

Sep 1, 2023

I found it really refreshing. With questions that provoked analytical thinking.

Kudos!!

By Chris d

•

Sep 11, 2023

Solid introduction to Excel. The videos were good. But the tests and quizzes are just bad, bad, bad.

By Philipp B R O

•

Sep 11, 2023

Extremely basic stuff. At the same time often not the right tools for the job. Some errors in test questions. Focused on US-American localization.

By Jay

•

Sep 16, 2023

This course did not live up to my expectations.

By Travis S

•

Aug 31, 2023

Google courses are much better.

By Derrick W

•

Sep 12, 2023

Coursera has better and easier to understand instruction than any other learning platform that I have used, which have been a few.

The plain language video teaching examples combined with the exercises, quizzes, and assessments helps to re-enforce the knowledge gained.

To all of the people that make this possible: thank you. I feel that I am on the way to change.

To all of the learners: your courage is calling you and your discipline will be your destiny.

By Joe L

•

Oct 11, 2023

I enjoyed how efficiently the course moved along. The course allows for you to grasp the material/skills with relevant exercises and quizzes. On to the next one!

By Faithful O

•

Sep 6, 2023

The course is very systematic and understandable. As a learner, I wish there was a pdf document of all the things taught in this course.

By Sriram N

•

Sep 16, 2023

The course is ideal for those interested in pursuing careers in data analysis. Thanks to Microsoft and Coursera.

By Usama

•

Sep 3, 2023

There are so many typo mistakes in course content and final assessment

By Marko B

•

Sep 11, 2023

There is too much talking and to little to actually practice. A lot of unnecessary quiz questions are more easily learned through actual practice.

By Abubakar I

•

Dec 7, 2023

This course is amazing specially for the absolute beginners. The video lectures gives you brief intro about the topic and after that assignment helps you to understand the concept better. Almost every topic covered in the course have an assignment activity which makes the course more interactive and you'll not get bored.

By Zean L

•

Sep 1, 2024

This course highlight the technical skills as well as non-technical that need to be a data analyst and introduce the Microsoft Excel as the very first tools for a data analyst.

By Mayon W

•

May 22, 2024

When starting this course I thought I know these functions and the things but when doing I realized I only new 60% of the programs and some function went it deep good one

By Berke F

•

Sep 24, 2023

I think the course structure is good and the lessons are very clear, but there were a couple of things that caused inconvenience. Firstly, the difference of software (Microsoft 365 Excel) between the live version and the version in the video caused a lot of issues. I had to guess some questions because it is an outdated version. And secondly, some questions were too specific. There was a question about the maximum number of rows in Excel. True or False for "There are one million." It is unclear from the question whether it is an approximation or whether they are asking for the actual value, 1,048,576. Replacing the number in the question with an unambiguous number such as "two million" or "one billion" could be better. This is the only mistake I had in the final exam and now my grade is not 100% :(

By Dishant J

•

Oct 20, 2025

some items are still locked it says it will be unlock when the schedule begins and its been about a month they are still locked

By Brent B

•

Jul 25, 2024

I just need to learn about Power BI and manipulating data for reporting and visualisation. I don't need to learn Excel basics.

By Muhammad A

•

Jan 17, 2025

Initial lectures related AI was great however excel understanding was so basic

By Omar A

•

Feb 6, 2024

I recently completed the 'Preparing Data for Analysis with Microsoft Excel' course, and I must say it was an incredibly enriching experience. As someone relatively new to data analysis, I found the course to be exceptionally well-structured and comprehensive. The instructors did an excellent job of breaking down complex concepts into easily digestible chunks, making them accessible even for beginners like myself. From understanding the basics of Excel to mastering advanced functions and formulas, every module was thoughtfully designed to build upon the previous one, ensuring a solid understanding of the material. One aspect that stood out to me was the practical approach taken throughout the course. Instead of just learning theoretical concepts, we were given real-world examples and hands-on exercises to apply what we learned. This not only reinforced our understanding but also gave us the confidence to tackle data analysis tasks in our own work. Furthermore, the course provided valuable insights into best practices for data cleaning, standardisation, and visualisation, which are essential skills for anyone working with data. I particularly appreciated the tips and tricks shared by the instructors, which I can now apply to streamline my own workflow. Overall, I can confidently say that the 'Preparing Data for Analysis with Microsoft Excel' course has significantly enhanced my data analysis skills and equipped me with the tools and knowledge needed to excel in my professional endeavours. I would highly recommend this course to anyone looking to sharpen their Excel skills and dive deeper into the world of data analysis.