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: Data Validation
Status: Data Preprocessing
IntermediateCourse15 hours

Featured reviews

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.

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.

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 !!!!!!!

RA

5.0Reviewed Sep 7, 2020

Very well thought out course. Pace is good, examples are spot on, and instruction is great for someone just starting out in data analysis and needing a strong background in the fundamentals.

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 !!!!!!!

RA

5.0Reviewed Sep 1, 2022

Very well-organized and at a good pace. There were a few typos here and there that took some time for me to realize. Otherwise, I enjoyed the information. It was extremely beneficial to me.

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.

AD

5.0Reviewed Jan 3, 2022

Short and thorough course on sorting out data which also helps you to understand how to combine Tables and Named Ranges as well as using a combination of nested intermediate level formulas.

MY

5.0Reviewed Oct 13, 2022

The course is well structured and supported by extensive exercises. This leads to effective learning. Many thanks to the instructors Nicky Bull and Prashan Karunaratne for their valuable work!

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!

JF

5.0Reviewed Sep 20, 2022

V​ery 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

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.

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