Free Online Courses
Paid certificateIntermediateCareer Skills

Excel Fundamentals for Data Analysis

Macquarie University's course on preparing and analysing data in Excel: text and date functions, named ranges, tables and lookups.

Taught byCoursera
Start free on Coursera

About this course

Part of Macquarie University's Excel skills series, this course focuses on getting data ready for analysis. You clean and manipulate text, work with numbers and dates, use defined names, automate with Excel tables and build logical and lookup formulas, finishing with a final assessment.

Best for: Office workers and aspiring analysts who already know Excel basics and want stronger data skills.

What you will be able to do

  • Clean and transform text data with Excel functions
  • Work accurately with numbers and dates
  • Use defined names and tables to simplify workbooks
  • Combine logical and lookup functions to analyse data

Syllabus and your progress

Tick modules off as you finish them on Coursera.

0 of 6 modules done

Plan your pace

At 4 hours a week you would finish in about 5 weeks, using the course time estimate above.

Progress is saved in this browser only. No account needed.

Cost and certificate

Paid certificate

On Coursera's enrol screen many courses offer a free 'Full Course, No Certificate' option; the certificate is paid (financial aid can be requested). Check the options before you start.

Before you start: Basic Excel experience

Coursera sets the terms and can change them. Check the course page before you commit serious time, and tell us if something changed.

Quick answers

Is Excel Fundamentals for Data Analysis really free?
Yes, the course material is free on Coursera. On Coursera's enrol screen many courses offer a free 'Full Course, No Certificate' option; the certificate is paid (financial aid can be requested). Check the options before you start.
How long does Excel Fundamentals for Data Analysis take?
Plan for about 20 hrs in total (Provider estimate: 2 weeks at 10 hours a week). It is self-paced, so you can go faster or slower.
Do I need experience before Excel Fundamentals for Data Analysis?
It helps to have: Basic Excel experience.

Topics

About Coursera

University and industry courses with optional paid certificates.

All free Coursera courses

Keep going on AltFTool

Excel Fundamentals for Data Analysis

Paid certificate

Start on Coursera