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

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.

GG

5.0Reviewed Mar 26, 2022

T​hank you for this course! It was a lot of fun and easy to follow. I loved the assignements when not only that weeks knowledge was tested but also something randomly from previous weeks.

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.

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

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

PA

4.0Reviewed Feb 5, 2021

A very well structured course with easy to follow examples. I would give it a 4.5 because there is some error in the workbook and quizzes but apparently, it hasn't been changed despite to complaints

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.

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.

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.

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.

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.

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.

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