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.
SK
Excellent course. I was familiar with a good amount of the content, but there was enough that was new that the course was really engaging and interesting. Well structured.
DP
Muy práctico y fácil de digerir, no te quedes con lo que ya sabes, ten la mente abierta para que aprendas nuevas formas de hacer las cosas de una forma rápida y práctica, optimizando tiempo.
MA
It was great helping me become more efficient in Excel. I am a basic user but now I feel confident leveraging the advanced Excel tools. I am super excited to learn more about Power BI
WC
Very informative. You will still need to reference other sites like Microsoft Knowledge Base and probably W3Schools. This is a solid foundation to peak your interest.
SG
Gave an overall understanding on excel which helped me a lot. I now feel more confident using functions, formulas, and tools like filters, conditional formatting, and charts.
SR
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.
SS
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!
SS
Coursera Course Design Process is good and Thanks Our Tutor also per module give you a more knowledge and till the course your learning is too much improve.
JL
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!
SE
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
JD
Estoy complementando mis conociimientos previos. Este proceso de análisis de datos mostrado en esrte curso se parece mucho a un proceso de un plan de auditoría.
GS
I'm so thankful Coursera for giving me this opportunity with option of Financial Aid which really helps me as student who is trying to gain experience and learning .
显示：20/1,096
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.
too basic. course is purely meant for someone who is using Excel for the first time.
Mid course. Macquarie University has much better course. With good tests and interesting practical exersices.
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
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.
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.
This course did not live up to my expectations.
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!
I found it really refreshing. With questions that provoked analytical thinking.
Kudos!!
Solid introduction to Excel. The videos were good. But the tests and quizzes are just bad, bad, bad.
Google courses are much better.
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.
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!
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.
The course is ideal for those interested in pursuing careers in data analysis. Thanks to Microsoft and Coursera.
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% :(
There are so many typo mistakes in course content and final assessment
There is too much talking and to little to actually practice. A lot of unnecessary quiz questions are more easily learned through actual practice.
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.
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.