In this project, you will learn the foundation of data analysis with Microsoft Excel using sales data from a sample company. You will learn how to use sorting and filtering tools to reorganize your data and access specific information about your data. You will also learn about the use of functions like IF and VLOOKUP functions to create new data and relate data from different tables. Finally, you will learn how to create PivotTables to summarize and look at comparisons within your data. These skills will help you efficiently perform data analysis on many different types of data and give you the foundation to expand your toolbox as you explore other strategies for data analysis.
PW
A little difficult to follow at the beginning, especially on a smaller laptop screen. However, I did refresh the skills that I was looking to revisit having not used them recently.
EO
This guided project has helped me to develop a self interest in the in analyzing data, it has also help me to know the use of pivot table when working with excel
AZ
The presenter gave clear and easy-to-understand instructions, the media used was also simple, and each task was directed from easy to difficult levels. Thanks :)
KB
Difficult to get worksheet screen and instruction screen properly displayed for easy viewing and manipulation between them. Great course, helpful, plainly spoken instructions in excellent English.
FL
Great Intro for Beginners. It supported me in affirming I should definitely take the Google Data Analytics. So I am :) Appreciating the journey so far.
OA
The trainer took the course step by step with adequate training materials. A template should have been provided for students to practice with. Thank you coursera for the opportunuty
SS
This course is crisp and brief, and the explanation is accessible. I really enjoyed doing this one. I also found the functions I learnt in this course useful.
BM
This is one of the best learnings I have ever done in Coursera. Very detail-oriented, very clear, the tutor is clear and the video is easy to follow.
AA
This course is suitable for those who want to start data analysis using excel. It is not too complex and understandable. This course use simple features including IF and VLOOKUP function.
HS
very nicely prepared and well verse with day to day function used in excel. Best part was the Quiz in question tricky if studied well then you answer easily else it's like all option are familiar:)
AA
A great learning tool. in order to increase skill, an assignment could be given for submission at a later date so that learners could work on it on their own
DW
Great for a beginner in excel who wants to learn more about the VLOOKUP and IF Functions in particular, and applying those to real world applications.
Showing: 20 of 736
Not working - no link to one drive files for the analyzed data
My name was not written on the certificate. It said courser learner, cannot be used as proof.
After completion of the course even after paying money, you will not get the certificate of your name so according to me this is not acceptable at all
I expected and wanted my Name in Completion Certificate. Please provide me a completion certificate with my name on it.
In the certificate I didn't have my name.
The instructor gets 5 stars. She speaks clearly and at a good pace. Coursera should have her teach a full course on Data Analysis.
Microsoft or Coursera...The constant interruptions from the left pane of Microsoft 0 stars. Not sure if that's MS or Coursera technical issue.
There should be an option to pin the instructor's screen side of the screen. I logged on to my MS account and downloaded the excersise files. I'm using my own MS account to follow along using excel on a second monitor.
I tried expanding the right side by using the icon at the top right. It'll stay in a full screen position for a few minutes and then it goes back to a split screen. This happened constantly during the presentation. Also, happened in other guided project tutorials.
I tried logging out of the MS side screen by clicking on the 3. and choosing exit.
i cannot find the file the guided project is at
It can't be more perfectly explained! Thank you so much for this course, I wish I found this before wasting many weeks on the google data analytics certificate, this could have saved me so much time. Anyways, kindly make more projects like this, it was amazing keep it up!
This course was very interesting to attend, it was super quick, but it was quite fun, and I got to sharpen my skills in some data analysis tasks.
I would not mind it at all if another guided project came along, a bit more complex ehehe
Great for beginners
The assessment test needs to be more practical! Multiple choice questions don't test the learners skillset optimally. A case study with pragmatic business questions should be used to test the knowledge stick of students using Excel and not some simple objective questions.
Short and to the point. Its definitely a great way to refresh your memory if you haven't used excel in a while. I love that you can follow along all in one window. I LOVED the format.
Excellent teaching methods explaining very detailed very step of the way and she also provides useful tips to be more productive while doing data analysis of a database.
Great introductory course to Data Mining and Data Analysis. Basic functions like Filter, IF, VLOOKUP and Pivot Tables are included.
Easy and fun explanation
highly satisfied
Good for excel newbie.
Didn't give certificate
Instructor was clear, had a pleasant voice, easy to follow instruction, and had a steady pace that was good. My experience, so far, with some Coursera instructors has been that some go at a pace that is so fast one has to continually rewind the video. This instructor's pace was perfect.
My only suggestion would be to have several sample exercises after each task, rather than the one. This would ingrain that task so when it comes time to utilize this skill in real-world situations, it has been cemented in memory.
By the end of the course, I felt much more confident using Excel for data analysis. I can now create meaningful reports, automate repetitive tasks, and draw insights from large datasets with ease. I highly recommend this course to anyone looking to enhance their Excel skills for data analysis. It’s well-structured, practical, and a fantastic investment in your professional development. Whether you’re analyzing data for business, research, or personal projects, this course is a game-changer!