Macquarie University

Study Group: Excel Fundamentals for Data Analysis


Learn with Class Central. Join the study group to learn together with learners around the world with weekly live sessions and dedicated discussion forums. Learn more

Course overview

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.

View more details on course page

Schedule Jun 16, 2021 – Jul 20, 2021

  1. Week 1

    Wednesday, Jun 16 – Tuesday, Jun 22

    1. 1.1 Welcome and critical information
    2. 1.2 Cleaning and manipulating text
  2. Week 2

    Wednesday, Jun 23 – Tuesday, Jun 29

    1. 2.1 Working with numbers and dates
  3. Week 3

    Wednesday, Jun 30 – Tuesday, Jul 06

    1. 3.1 Defined Names for working more effectively with data
  4. Week 4

    Wednesday, Jul 07 – Tuesday, Jul 13

    1. 4.1 Tables for automating data manipulation
  5. Week 5

    Wednesday, Jul 14 – Tuesday, Jul 20

    1. 5.1 Logical and lookup functions
    2. 5.2 Final assessment

How to register

  1. 1

    Let's get started

    Sign up for the course on Coursera

    Follow the link above to go to the Excel Fundamentals for Data Analysis course. Once there, click on 'Enroll for Free'. Then, log into Coursera or create an account. Lastly, look for a link to Audit the course. If you audit, you won't earn a certificate or be able to access the graded assignments.

  2. 2

    Let's connect

    Sign up on

    The study group will live in our forum. Register by clicking Join Forum above. There, you will be able to ask questions about the course, share your comments with fellow learners, and discuss your impressions of the course material. We hope we’ll have a great time learning together.

  3. 3

    Let's get to know each other

    Introduce yourself!

    After signing up please read the code of conduct and introduce yourself to the learning community.

Never Stop Learning!

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

Sign up for free