About this Course

252,207 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

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

Offered by

Placeholder

Macquarie University

Syllabus - What you will learn from this course

Content RatingThumbs Up97%(2,500 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

More questions? Visit the Learner Help Center.