Chevron Left
Back to Excel Fundamentals for Data Analysis

Learner Reviews & Feedback for Excel Fundamentals for Data Analysis by Macquarie University

4.8
stars
3,598 ratings

About the Course

As data becomes the modern currency, so the ability to analyse the data quickly and accurately has become of paramount importance. Excel with its extraordinarily broad range of features and capabilities is one of the most widely used programs for doing this. In the first course of our Excel Skills for Data Analysis and Visualization Specialization, you will learn the fundamentals of Excel for data analysis. When you have completed the course, you will be able to use a range of Excel tools and functions to clean and prepare data for analysis; automate data analysis with the help of Named Ranges and Tables; and use logical and lookup functions to transform, link and categorise data. This course will enable you to build a strong foundation in the fundamentals, helping you to be more efficient in your day-to-day and developing the necessary skills to work with the more advanced techniques used in later courses. To make the content easy to relate to and to personalize the learning experience, we are going to follow Zara's journey through the course. Who is Zara? Well, she is no-one and everyone. You will find that Zara's trials and tribulations sound familiar, and together with Zara, you will develop your Excel skills along the way — and, importantly, have some fun doing it. The Excel Skills for Data Analytics and Visualization courses are the sequel to one of most successful specializations on Coursera, Excel Skills for Business, which has attracted hundreds of thousands of learners and top ratings. Transform your skills, your confidence, and your opportunities by adding this new set of skills to your repertoire....

Top reviews

QP

Dec 3, 2023

This is the best course I have seen in excel fundamentals on any platform. Easy to follow, many practice tests, spreadsheets and useful cheatsheets. Kudos to the instructors and Macquarie University.

MC

Sep 24, 2022

It was an excellent experience to learn in these type of flatform. This is course give me a tremoundous learning oppurtunity . iam studied all studied materila, attended all quizes with 80 t0 95% .

Filter by:

26 - 50 of 957 Reviews for Excel Fundamentals for Data Analysis

By FRANCIS J G

Jul 22, 2020

The assessments are quite random at times, with the questions outright stating the formulas to be used without giving much of a challenge for us. The last question in the course assessment was also worded incorrectly, the answer 41 is the retail average of those WITH the bonus, not without.

By Bennet P

Apr 6, 2023

Really disappointed in this course so far. Some of the content and materials are helpful but I think they do a terrible job of making sure the content as it is presented in the course matches the skills that are expected to be demonstrated in assignments and assessments. Several times an assessment or skills challenge required the user to be aware of certain formatting standards that were not covered or mentioned at all. Some of the skills needing to be demonstrated aren't even covered in the videos and aren't brought to the user's attention at all; if it wasn't for the solutions that are provided the user would have no idea why they aren't able to complete a task. It really feels like there is a serious disconnect between whoever is responsible for providing the content for the videos and who is developing the skills challenges and quizzes/tests. They need to get on the same page if they want to deliver a good course.

By Damien D

May 19, 2023

After taking many Coursera courses from MacQuarie, and learning quite a bit, I have some criticisms of this course due to the frame of reference. This course was very much not worth my time. Mainly, there was very little in this course that was not available in the Excel Skills for Business Specialization courses, and so in terms of new knowledge, it was lacking. Furthermore, on the topic of data analysis, I did not find what was available to really be that relevant in the first place. More than anything, this course just consisted of basic Excel skills, not for data analysis as such. The Excel Skills for Data Analytics and Visualization Specialization would have been much better leveraging a course from Excel Skills for Business; alternatively, this course in particular would need some considerable rework to make it relevant and worthwhile to the specialization in which it sits. As the cherry on top, the Final Assessment was an absolute slog from the student perspective (a shared sentiment that can easily be found in the discussion forum), since so many of the questions and answers were inaccurate, by which I mean that either the questions are misleading/unclear or simply do not cohere with the details in the provided workbook, or that the answers provided do not match the answers found. The course instructors need to do some UX research on this course and revise, at the very least, the Final Assessment so that it doesn't feel like pedagogical gaslighting. Overall, this course was very disappointing.

By Victor A

Mar 22, 2022

I wish I could grade this course with more detail, I'd rate it 4.5 stars.

Overall, it seems to be one of the best resources on Coursera regarding Excel skills and almost up to date with the latest version of Excel and its more useful formulas for Data Analysis. There are some formulas not included in the videos but with a brief explanation in the weekly toolboxes; these are really useful formulas and even needed to answer some questions in the weekly graded assignments, but don't worry, with what's covered in the videos you can handle those extra formulas confidently.

The practice challenges are great, but there is a problem with the final asessment (25% of your final grade), don't know if there were previous versions or inconsistency in the file containing the data for it, but it is hard to get the suposedly right answers for the last 4 questions or so, at least I could not get any of the available options to answer; nonetheless, I considered I got a good grap of the necessary concepts and did not focus on getting a perfect grade. I mention this because it also seems there is lack of feedback or support on the forums from the teaching staff, I sugest reading the corresponding weekly posts to see if some other learners have found a solution or workaround with any trouble you may have.

Also, be aware of your regional settings when handling currency and date and time formats, they can cause errors in your formulas that you will need to address individually or with the help of other learners.

VBA and macros are not covered in this course, maybe they are covered in further courses of the specialization. Macquarie University also offers some other specializations focused on different applications, look for them to see if you find what you might be interested in.

By Tanzeel U R

Feb 3, 2023

I recently completed the Excel Fundamentals for Data Analysis course on Coursera and found it to be an extremely helpful and well-structured program. The course covered all the basics of Excel software, including spreadsheet formatting, data manipulation, and analysis tools. The instructor was knowledgeable and made the subject matter easy to understand.

I appreciated the hands-on approach to learning, with weekly practice assignments that allowed me to apply what I had learned. The discussions with fellow learners were also a valuable aspect of the course, as they allowed me to expand my understanding and share my experiences with others.

I would highly recommend this course to anyone looking to improve their Excel skills, whether for personal or professional use. The course was well-paced and the certificate of completion is a great way to demonstrate my knowledge and skills in Excel. Overall, I found this course to be a great investment in my professional development.

By Jennel G B

Jul 4, 2022

Q: If you want to create a Table, you need to click somewhere in the data before creating it. My Answer: This is FALSE. You can start anywhere in the workbook, then click in the "Table" under the Insert Menu, and then select the range you want to apply the Table. Q: On the Attendees sheet is a table showing people who will be attending our next event. We wish to include a welcome pack for people who are relatively new. In K7 create a calculation to check if the Start Date is on or after the date shown in U14, if it is put the text New in the column, otherwise leave it blank (do not put space or FALSE). Because it is a table your calculation automatically copies down. What is the number of new people as shown in W14? My comment: It should be: "What is the number of new people as shown in V14?"

By Sara C

Mar 14, 2022

A very useful course, even in period when I was taking it I had lots of use of the learnings so far, and I can immediately use this on my daily work.

My excel installation has a different regional format than the course providers and I had some problems with data in some of the work sheets. For instance, my formatting uses a comma as a decimal divider, while the course material uses a full stop for the same, and excel cannot interpret the difference. I also separate arguments in formulas with semicolon rather than a comma, as a consequence of this, so it was not possible for me to copy-paste formulas into the response field in the quizzes. I still made do, but it was a bit of a hassle to have to make manual adjustments for these differences all the time.

By Alexander H

Jul 25, 2023

This course's teaching approach is extremely effective, if interacted with honestly. The concepts are broken down into digestible chunks, making seemingly complex topics easy to learn and apply. I feel like this method of teaching is really great for retaining the knowledge you learn. For example, I took a 2 week break away from the course, on week 4, and when I came back and test my knowledge with the final assignment on week 5 I was quite surprised by how much I had remember! Really impressed with this course, could not recommend it enough.

P.S. I can tell a lot of thought was put into all the questions in this course, they test you to make sure you have a deep understanding of each topic. Love it!

By Jason O

Jan 28, 2023

Some of the assessment questions need to be reviewed for correct grammar, missing words, or punctuation. Also, there were discrepancies in instructions vs. the intended Workbook Output. (Ex. The final assessment has a question which states clients with a balance of 300 - 11999.99 receive a 5% discount; the Assessment work book lists Discount Percentage by Balance but the balance list values are 0, 300, 1200, 3000 and the discount is 3%, 5%, 8%, 12%. So the correct interpretation would be "clients with a balance of 300 - 1199.99 receive a 5% discount.) These errors cause confusion and frustration which is exacerbated by the nature of online assessments.

Great course, great practice, learned a lot.

By Ridwan ( A M

Jan 11, 2022

This is my first course ever to be successfully completed on Coursera. Instructors are engaging and the videos make you feel comfortable in actually learning Excel. All the little tips and tricks that the instructors showed in the videos and then reinforced with real-world examples have made me more confident in using Excel. The part of the course focusing on working with dates was extremely helpful since this is not something that I had much experience with. This course has given me a great bag of tools that I can immediately apply to work projects that require the use of Excel. I am very thankful to the instructors and anyone else who helped to put together this wonderful course!

By W.M.M.Sewwandi

Jan 1, 2021

Tbh I didn't even know that I didn't know how to use excel properly before I started this course, it was very exciting to follow a course where the study materials are perfect and also the quizzes after every single lesson were really helpful, cause sometimes after having a lesson we falsely believe we know everything now but those quizzes really show you "well you need more practising, stop overestimating" the entire course was very fun and very informative, so thank you very much for the month of knowledge, I enjoyed being Zara quite a lot. I still believe I need more practising, and so I'm going to redo all the downloaded materials, to make sure. Thank you very much.

By Sahil k

Mar 17, 2022

This course is designed in the exact same way as I wanted. Practice tests after each session made me analyze where I was lagging so that I can practice again. I found weekly practice assignment very helpful and challenging as it comprises of all the learning material they had taught in a week. Before weekly assesment test these assignments worked as a charm for me. I want to thank to both the great teachers for enriching my learning experience.

Apart from this, complex topics in week 5 could have been more elaborated else everything was great.

By Rony R

Apr 5, 2022

It is important to set goals for yourself that keep you motivated and push forward Even though I only just managed to squeeze it in between all my weekends good to have achieved certification in "Excel Fundamentals for Data Analysis" Now to start planning my learning and certification roadmap for 2022. I am currently leaning towards rounding out my functional level (Data Analysis) certifications. If I can manage that, I will probably set a stretch goal to achieve one of the professional certifications or perhaps another speciality.

By Peter B

Jul 20, 2023

An excellent course in my opinion. Although I had picked some of the lessons on my own this goes through it in Excel tools in a much more systematic and logical way and so I feel I have ended up with a much better understanding of how to get the best out of it. The practice sessions are good at testing understanding so I would not recommend skipping these. The course lecturers were very clear in their presentation of information which I appreciated. I would recommend this course,

By Kelvin C

Aug 21, 2023

This was an excellent course! I have been working on several coursera courses, and this one is the best so far. They have tests after every lesson to ensure you understand the material and the questions ACTUALLy require understanding o the course material. The final test is actually very comprehensive and it whopped me the first time I took it because it test you on all the course concepts and if you have a gap, you will struggle to figure out questions after a missed one.

By Carlos M N M

Feb 7, 2022

Le voy a dar 5, porque el contenido es excelente, además, los profesores explican superbien, pero hay un detalle que deben corregir: hay Bug en Varias preguntas, lo que no permite llegar al 100% de la nota en algunos casos. Por favor, corregir. Por lo demás, todo excelente. Uno llega creyendo que sabe mucho de Excel y se da cuenta que mas bien, mucho es lo que hay que aprender, las pruebas son duras, pero quedé enamorado de este curso y voy por más. Muchas gracias.

By Judith I S

Feb 3, 2023

I think the course provides a good foundation to clean data and a good range of knowledge about functions that can be used to operate with data en different formats. Exercises and challenges are great for practicing.

I would however encourage the teaching team to provide the solution sheets for the weekly final assessments and the final assessment once the course is completed because you might get stack with some operations and would like to see how to resolve them

By Chi N

Jul 23, 2021

(+)A good one to introduce tools and fomulas for a daily analysis.

Content: Concise and easily comprehensive, homeworks are aligned with what is tauhttps://www.coursera.org/learn/excel-data-analysis-fundamentals/home/welcome?ght.

Tests generally are designed well, not difficult but required your comprehension on these knowledge.

(-) Im using Excel 2010 whilst the course uses 2016, so some functions are not available. Then I would not recommend use excel below 2010.

By Ravi V C

Aug 9, 2021

This course is just amazing for the efforts that has gone into making it self-explanatory for those who are ready to put in those hours. Kudos to both Nicky and Prashan, for the lucid choice of words and, succint verbiage. My sincere gratitude for all the efforts the entire team has put in, to make this available to me.

I am highly motivated to take up remainder of the courses and, look to complete within a much shorter time frame. Appreciate the help and, support.

By Nguyễn M

Nov 15, 2021

This is absolutely awesome! I have learned various helpful and practical Excel skills. All lessons are discussed in details, step by step, which makes them much easier to follow. The assignments at the end of every week are of great difficulty that allows you to test your understanding and practice. I will definitely recommend this course for my friends and colleagues. I would also like to thank to Coursera and MacQuarie University for introducing this course!

By Linh V H

Aug 25, 2021

I have just finished the course with a 100% Grade. This course is very well-designed and it offers plenty of exercises for you to practice the skills. I like how the quizzes show up after every practice video. It helps me check my understanding of the lessons, and reminded me of the points I had failed to catch up. The Excel functions this course introduces are also pretty handy. I would recommend this course to those who want to leverage their Excel skills.

By William E

May 26, 2023

This course was extremely well presented, with clear, concise instruction and practical examples for the topics presented. Although I already had experience with many of the functions and techniques presented in the course, I still learned quite a lot. Over all, I would recommend this course to anyone looking to further their Excel skills, and have a better conceptual basis for both using formulas to solve problems in Excel, and text/data cleaning.

By Ahmet G

Mar 16, 2023

It's like I can truly say that I learned Excel from scratch. I've used excel for years, but I've only done addition and subtraction. Thanks to you, I had the opportunity to experience and learn many functional features. The narration is great, the scenero is great! I felt as if I was working in that company, the scenario based on real events, repetitions and practices reinforce learning. Thanks Macquarie University and Coursera.

By Rubicel G H

May 29, 2022

Es un curso interactivo, con ejemplos muy bien explicados pero con un nivel avanzado.

Es una herramienta muy util en el campo de aplicación (de la Ingeniería). En lo personal, aprendí a utilizar muchas herramientas que no conocía, pero que me son de mucha utilidad en mi campo profesional.

Doy las gracias a los instructores por hacernos llegar este conocimiento de una manera muy practica.

Mil gracias

Rubicel Gordillo Hernández

By John N D

Nov 14, 2020

I have really learned a lot in this course. I have been using Excel since college and also from my work, but I was surprised as to what I didn't know in Excel. That is why this course is very perfect for users who are only self-taught like me. The instructors are also very articulate in explaining the topics. I love their conversations with each other in the Introduction videos, which makes you really want to learn more.