Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Excel Fundamentals for Data Analysis

Macquarie University via Coursera


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.

Taught by

Dr Prashan S. M. Karunaratne, FHEA

Related Courses


4.8 rating, based on 4 reviews

Start your review of Excel Fundamentals for Data Analysis

  • I did this course as part of a internal study group at Class Central. We were four people in four different countries: India, United States, Australia, and China. As a programmer for almost a decade, this course wasn't too difficult, yet informative....
  • I really enjoyed this course, spent ~3 hours a week for 5 weeks and found it to be easy. Positive things I found in the course: - In the beginning of the course, both the instructors used to talk about the week syllabus and high level overview. - Every...
  • This is the first course I learned in a study group with other three members from Class Central. Memories about our happy biweekly virtual meetings, anxiety of quizzes and assignments, excitement of receiving the certificate are still vivid in my mind....
  • Quite a challenging course, but very useful for learning about some of the many features of Excel. I took longer than the "recommended" 15 hours/5 weeks and I reset my deadlines without penalty. This course helped me create a household budget spreadsheet (as a personal project).

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free