Back to Excel Fundamentals for Data Analysis
Macquarie University

Excel Fundamentals for Data Analysis

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.

Status: Spreadsheet Software
Status: Microsoft Excel
IntermediateCourse15 hours

Featured reviews

NK

5.0Reviewed Oct 5, 2022

Very comprehensive and clearly laid out course with loads of content. Great videos, well explained and loads of practice exercises. I feel as if I've learned a great deal, Very Valuable, thank you .

QP

5.0Reviewed 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.

KW

4.0Reviewed Aug 4, 2020

I enjoyed the course, but since I do not use excel on a regular basis I found it very hard.I will use the leaned functions as much as I can apply to my excel projects.Thanks for an interesting time.

HH

5.0Reviewed Dec 4, 2021

Super fun and and intellectual course. Real need of hour to excel in Excel :) . This course helped a lot, in improving skills in excel analytics.special thanks to both the instructors !!!!!!!

ST

4.0Reviewed Apr 28, 2022

This excellent course for learnig Excel fundamentals like Text, Date, Lookup functions and Tables.It will be useful for people handling large amoun tof data and its manipulation in computer.

SM

5.0Reviewed Dec 29, 2023

Excellent insights into the world of excel and how complex functions can be used to simplify our data analysis tasks. All the assignments really made me work hard and were fun to complete.

JM

4.0Reviewed Jul 14, 2023

OVERALL COURSE WAS WELL WORTH IT! HAD A FEW AREAS WHERE THEY DIDN'T TEACH EVERYTHING YOU NEEDED TO KNOW, AND SOME OF THE QUIZ ANSWERS WERE INCORRECT. BUT OVERALL VERY PLEASED WITH THE COURSE.

AV

5.0Reviewed Jul 10, 2020

Super fun and and intellectual course. Real need of hour to excel in Excel :) . This course helped a lot, in improving skills in excel analytics.special thanks to both the instructors !!!!!!!

FV

5.0Reviewed Jul 17, 2020

Well done. A small thing, though: in the quizzes, the grading could be made more fault-tolerant. Example: an answer such as AND(y,x) instead of AND(x,y) is deemed wrong, which borders on the nasty.

AM

5.0Reviewed Jun 22, 2023

A well-structured course that offers plenty of practice. It also provides lots of great tools and ideas for those who work analytically with Excel. I will definitely use what I've learned.

DA

5.0Reviewed Aug 25, 2021

Name of the course is Excel Fundamentals for Data Analysis but I don't think it's fundamental. I learn a lot and very satisfied with the pace, the quiz, the 'reading' material. Thank you!

MC

5.0Reviewed Sep 24, 2022

I​t 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% .

All reviews

Showing: 20 of 1,103

Ulvi Khalilov
1.0
Reviewed Aug 16, 2020
Jaime Russ
3.0
Reviewed Jun 21, 2020
Fred Vacelet
5.0
Reviewed Jul 18, 2020
hope molina
3.0
Reviewed Nov 9, 2020
Maruthi C
5.0
Reviewed Sep 25, 2022
Richard Anderson
5.0
Reviewed Sep 8, 2020
Humaira Maqbool
4.0
Reviewed Jul 13, 2020
Apoorv Vaishampayan
5.0
Reviewed Jul 11, 2020
angeli rose palma
1.0
Reviewed May 8, 2022
Lauren Sutherland
5.0
Reviewed Jul 10, 2020
Mario Ottaviano
1.0
Reviewed Jul 31, 2020
Himanshu
5.0
Reviewed Dec 5, 2021
Dipesh Chavda
5.0
Reviewed Jul 10, 2020
Damien Desmond
1.0
Reviewed May 19, 2023
Ka Ka Claudia Chau
5.0
Reviewed Jul 9, 2021
Vaishnavi Seenuvasan
5.0
Reviewed Aug 21, 2020
Jane Fletcher
5.0
Reviewed Sep 21, 2022
Paul J Burke
5.0
Reviewed May 26, 2021
Isabelle Ribeiro Rodrigues
5.0
Reviewed Aug 10, 2021
Nur Syafiqah Mohd Haris
5.0
Reviewed Nov 4, 2020