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.
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.
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 :)
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.
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
PM
There is nothing more fulfilled as meeting your expectations with actions of successful achievements.Continuous learning opens up your ability to relate with confidence.Keep learning
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
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.
SR
Was a really helpful one to understand the basics of an excel and would be highly recommended to the early-stage graduate who are looking out for the finance job role.
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.
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:)
AC
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.
FF
It´s a small bite-sized course that explain super important excel functions in an easy to follow way. Clear instructions and examples. Highly recommended!
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!