About this Course

314,706 recent views
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own 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
Flexible deadlines
Reset deadlines in accordance to your schedule.
Shareable Certificate
Earn a Certificate upon completion
100% online
Start instantly and learn at your own 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%(6,322 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
3 hours to complete

Cleaning and manipulating text

3 hours to complete
6 videos (Total 30 min), 4 readings, 6 quizzes
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
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
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

Reviews

TOP REVIEWS FROM EXCEL FUNDAMENTALS FOR DATA ANALYSIS

View all reviews

About the Excel Skills for Data Analytics and Visualization Specialization

Excel Skills for Data Analytics and Visualization

Frequently Asked Questions

More questions? Visit the Learner Help Center.