About this Course

333,826 recent views
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 15 hours to complete
English
Subtitles: English

What you will learn

  • Use Excel tools and functions to clean and prepare data for analysis.

  • Use Named Ranges and Tables to automate your analysis.

  • Understand the different types of data in Excel and use appropriate functions to work with them.

  • Use logical and lookup functions to transform, link and categorise data.

Skills you will gain

Data AnalysisMicrosoft ExcelData Cleansing
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own schedule.
Flexible deadlines
Reset deadlines in accordance to your schedule.
Intermediate Level
Approx. 15 hours to complete
English
Subtitles: English

Offered by

Macquarie University logo

Macquarie University

Syllabus - What you will learn from this course

Content RatingThumbs Up97%(1,109 ratings)Info
Week
1

Week 1

1 hour to complete

Welcome and critical information

1 hour to complete
1 video (Total 3 min), 3 readings
1 video
3 readings
Welcome to Excel Fundamentals for Data Analysis15m
Course goals and weekly learning objectives10m
Important information about versions and regions10m
3 hours to complete

Cleaning and manipulating text

3 hours to complete
6 videos (Total 30 min), 4 readings, 6 quizzes
6 videos
Excel functions for combining text values6m
Functions that split text data3m
Combining text functions6m
Cleaning data and changing case4m
Removing and replacing text characters4m
4 readings
Read me before you start: Quizzes and Navigation10m
Download the Week 1 workbooks5m
Week 1 Practice Challenge20m
Week 1 Toolbox10m
6 practice exercises
Excel functions for combining text values10m
Functions that split text data10m
Combining text functions10m
Cleaning data and changing case10m
Removing and replacing text characters10m
Cleaning and manipulating text: Test your skills30m
Week
2

Week 2

3 hours to complete

Working with numbers and dates

3 hours to complete
6 videos (Total 37 min), 3 readings, 6 quizzes
6 videos
Converting Data with VALUE and TEXT6m
Understanding dates and basic date functions7m
Generating Valid Dates using the DATE function6m
Calculations with Dates and using DAYS, NETWORKDAYS and WORKDAY8m
More sophisticated date calculations with EOMONTH and EDATE5m
3 readings
Download the Week 2 workbooks10m
Week 2 Practice Challenge20m
Week 2 Toolbox10m
6 practice exercises
Converting Data with VALUE and TEXT10m
Understanding dates and basic date functions10m
Generating Valid Dates using the DATE function10m
Calculations with Dates and using DAYS, NETWORKDAYS and WORKDAY10m
More sophisticated date calculations with EOMONTH and EDATE10m
Working with numbers and dates: Test your skills30m
Week
3

Week 3

3 hours to complete

Defined Names for working more effectively with data

3 hours to complete
6 videos (Total 36 min), 3 readings, 6 quizzes
6 videos
Cell Referencing and Naming6m
Defined Names and Create from Selection4m
Managing Names5m
Calculations with Named Ranges6m
Automating Data Validation with Named Ranges6m
3 readings
Download the Week 3 workbooks10m
Week 3 Practice Challenge20m
Week 3 Toolbox10m
6 practice exercises
Cell Referencing and Naming10m
Defined Names and Create from Selection10m
Managing Names10m
Calculations with Named Ranges10m
Automating Data Validation with Named Ranges10m
Defined Names for working more effectively with data: Test your skills30m
Week
4

Week 4

3 hours to complete

Tables for automating data manipulation

3 hours to complete
6 videos (Total 42 min), 3 readings, 6 quizzes
6 videos
Introduction to Tables6m
Customising Tables 5m
Sorting and Filtering Tables8m
Table Calculations and Structured References9m
Automation with Tables7m
3 readings
Download the Week 4 workbooks10m
Week 4 Practice Challenge20m
Week 4 Toolbox10m
6 practice exercises
Introduction to Tables10m
Customising Tables10m
Sorting and Filtering Tables10m
Table Calculations and Structured References10m
Automation with Tables10m
Tables for automating data manipulation: Test your skills30m

Reviews

TOP REVIEWS FROM EXCEL FUNDAMENTALS FOR DATA ANALYSIS

View all reviews

Frequently Asked Questions

  • Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

    • The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
    • The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
  • When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

  • You will be eligible for a full refund until two weeks after your payment date, or (for courses that have just launched) until two weeks after the first session of the course begins, whichever is later. You cannot receive a refund once you’ve earned a Course Certificate, even if you complete the course within the two-week refund period. See our full refund policy.

  • Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You’ll be prompted to complete an application and will be notified if you are approved. Learn more.

More questions? Visit the Learner Help Center.