About this Course

2,260 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. 17 hours to complete
English

Skills you will gain

Financial ModelingMicrosoft ExcelExcel Modelling
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. 17 hours to complete
English

Offered by

Placeholder

Delft University of Technology

Placeholder

Erasmus University Rotterdam

Syllabus - What you will learn from this course

Week
1

Week 1

5 hours to complete

A Foundation for Better Spreadsheets

5 hours to complete
5 videos (Total 19 min), 6 readings, 1 quiz
5 videos
Expert Video: Ingeborg Hawighorst - Is Excel the answer?4m
Expert Video: Importance of good input data, and how to check it4m
Expert Video: The importance of Formatting in Excel4m
Expert Video: Why is documentation important?4m
6 readings
Introduction20m
5 Excel Blunders that show how important safe Excel use is10m
Match the correct solution to the problem30m
Testing your input data30m
How to format consistently in Excel30m
The importance of documentation30m
1 practice exercise
A foundation for better spreadsheets1h
Week
2

Week 2

5 hours to complete

Good Use of Formulas and Functions

5 hours to complete
4 videos (Total 15 min), 3 readings, 1 quiz
4 videos
Expert Video: Pitfalls of commonly used Functions & Formulas4m
Expert Video: Functions and Formulas4m
Expert Video: Functions and Alternatives4m
3 readings
Find & Search Functions30m
Calculation Functions30m
Other Functions30m
Week
3

Week 3

3 hours to complete

Spreadsheet Structure and Logical Flow

3 hours to complete
4 videos (Total 15 min), 3 readings, 1 quiz
4 videos
Expert Video: Linear and logical spreadsheet flow3m
Expert Video: Keep it Simple4m
Expert Video: Protection and Hidden Information4m
3 readings
Linear and logical spreadsheet flow30m
Keep it Simple30m
Protection & Hidden Information30m
1 practice exercise
Spreadsheet Structure and Logical Flow30m
Week
4

Week 4

5 hours to complete

Finishing Touches

5 hours to complete
5 videos (Total 20 min), 3 readings, 1 quiz
5 videos
Charts, Pivot Tables, and Reporting (Gasper Kamensek)4m
Charts, Pivot Tables, and Reporting (Henk Vlootman)4m
Expert Video: Checking, Testing, and Validation4m
Expert Video: Finalization4m
3 readings
Charts and Reporting30m
Checking, Testing, and Validation30m
Finalization30m

Frequently Asked Questions

More questions? Visit the Learner Help Center.