Excel Fundamentals for Data Analysis

Macquarie University

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

with Heba Ledwon @heba

: Social Learning for Open Courses

1. Online Course

The course we’ll take. This will be found on an external provider site.
2. Discussion Forum

Where we support each other as we take the course.
3. Weekly Live Streams

Where we learn from instructors, experts, or each other.

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.

Meet your Peer Coordinator

Heba Ledwon

@heba

I am enthusiastic about the interplay of product value, data-driven business and experience-centered design and tech solutions. As I continue to learn, I grow in different roles and gain an overview on what helps to provide the most possible value for the Class Central community.

Schedule Jun 16th, 2021 – Jul 20th, 2021

Week 1W1 June 16th – June 22nd
- 1.1
  
  Welcome and critical information
- 1.2
  
  Cleaning and manipulating text
Week 2W2 June 23rd – June 29th
- 2.1
  
  Working with numbers and dates
Week 3W3 June 30th – July 6th
- 3.1
  
  Defined Names for working more effectively with data
Week 4W4 July 7th – July 13th
- 4.1
  
  Tables for automating data manipulation
Week 5W5 July 14th – July 20th
- 5.1
  
  Logical and lookup functions
- 5.2
  
  Final assessment

Heba Ledwon

Schedule Jun 16th, 2021 – Jul 20th, 2021

Week 1W1 June 16th – June 22nd

Week 2W2 June 23rd – June 29th

Week 3W3 June 30th – July 6th

Week 4W4 July 7th – July 13th

Week 5W5 July 14th – July 20th

Never Stop Learning.