About this Course

607,105 recent views

Learner Career Outcomes

42%

started a new career after completing these courses

38%

got a tangible career benefit from this course

32%

got a pay increase or promotion
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. 25 hours to complete
English

Skills you will gain

Dashboard (Business)Financial ModelingMicrosoft ExcelData Cleansing

Learner Career Outcomes

42%

started a new career after completing these courses

38%

got a tangible career benefit from this course

32%

got a pay increase or promotion
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. 25 hours to complete
English

Offered by

Placeholder

Macquarie University

Syllabus - What you will learn from this course

Content RatingThumbs Up95%(10,241 ratings)Info
Week
1

Week 1

6 hours to complete

Spreadsheet Design and Documentation

6 hours to complete
7 videos (Total 69 min), 7 readings, 5 quizzes
7 videos
Week 1 Discussion4m
Practice Video: Spreadsheet Design Principles12m
Practice Video: Calculations14m
Practice Video: Formatting11m
Practice Video: Documentation10m
Practice Video: Interface and Navigation12m
7 readings
Welcome10m
Course Structure & Assessments10m
Course goals and weekly learning objectives10m
Read me before you start: Quizzes and navigation10m
Read me before you start: Versions and regions10m
Download the Week 1 workbooks5m
Keyboard Shortcuts, Terminology, and Ninja Tips20m
5 practice exercises
Spreadsheet Design Principles30m
Calculations30m
Formatting30m
Documentation30m
Week 1 Final Assignment1h
Week
2

Week 2

4 hours to complete

Advanced Formula Techniques

4 hours to complete
7 videos (Total 41 min), 2 readings, 5 quizzes
7 videos
Week 2 Discussion4m
Practice Video: Tables and Structured Referencing9m
Practice Video: Using Functions to Sort Data8m
Practice Video: Introduction to Array Formulas5m
Practice Video: Working with an Array Function (TRANSPOSE)4m
Practice Video: Solving Problems with Array Formulas4m
2 readings
Download the Week 2 workbooks5m
Keyboard Shortcuts, Terminology, and Ninja Tips25m
5 practice exercises
Tables and Structured Referencing30m
Using Functions to Sort Data30m
Introduction to Array Formulas30m
Week 2 Practice Challenge45m
Week 2 Final Assignment1h
Week
3

Week 3

5 hours to complete

Data Cleaning and Preparation

5 hours to complete
7 videos (Total 37 min), 2 readings, 7 quizzes
7 videos
Week 3 Discussion4m
Practice Video: Replace blanks with repeating values5m
Practice Video: Fix Dates (DATE, MONTH, YEAR, DAY, TEXT)6m
Practice Video: Remove Unwanted Spaces (TRIM, CLEAN)4m
Practice Video: Diagnostic Tools (ISNUMBER, LEN, CODE)7m
Practice Video: Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)6m
2 readings
Download the Week 3 workbooks5m
Keyboard Shortcuts, Terminology, and Ninja Tips25m
7 practice exercises
Replace blanks with repeating values30m
Fix Dates (DATE, MONTH, YEAR, DAY, TEXT)30m
Remove Unwanted Spaces (TRIM, CLEAN)30m
Diagnostic Tools (ISNUMBER, LEN, CODE)30m
Remove Unwanted Characters (SUBSTITUTE, CHAR, VALUE)30m
Week 3 Practice Challenge45m
Week 3 Final Assignment1h
Week
4

Week 4

3 hours to complete

Financial Functions and Working with Dates

3 hours to complete
7 videos (Total 48 min), 2 readings, 6 quizzes
7 videos
Week 4 Discussion6m
Practice Video: Working with Dates (EOMONTH, EDATE, WORKDAY.INTL)5m
Practice Video: Financial Functions (FV, PV, PMT)8m
Practice Video: Loan Schedule (PMT, EDATE)10m
Practice Video: Net Present Value and Internal Rate of Return (NPV, IRR)7m
Practice Video: Depreciation Functions (SLN, SYD, DDB)6m
2 readings
Download the Week 4 workbooks5m
Keyboard Shortcuts, Excel Terminology, and Ninja Tips40m
6 practice exercises
Working with Dates (EOMONTH, EDATE, WORKDAY.INTL)10m
Financial Functions (FV, PV, PMT)10m
Loan Schedule (PMT, EDATE)12m
Net Present Value and Internal Rate of Return (NPV, IRR)10m
Depreciation Functions (SLN, SYD, DDB)10m
Week 4 Final Assignment1h

Reviews

TOP REVIEWS FROM EXCEL SKILLS FOR BUSINESS: ADVANCED

View all reviews

About the Excel Skills for Business Specialization

Excel Skills for Business

Frequently Asked Questions

More questions? Visit the Learner Help Center.