Excel Modeling for Professionals: Best Practices & Pitfalls
Intermediate
Online
3 Weeks
Free Quick Facts
| Medium Of Instructions | Mode Of Learning | Mode Of Delivery |
|---|---|---|
| English | Self Study | Video and Text Based |
Courses and Certificate Fees
| Fees Informations | Certificate Availability | Certificate Providing Authority |
|---|---|---|
| INR 2436 | yes | Coursera |
The Syllabus
Videos
- Introduction: Excel Course for Professionals
- Expert Video: Ingeborg Hawighorst - Is Excel the answer?
- Expert Video: Importance of good input data, and how to check it
- Expert Video: The importance of Formatting in Excel
- Expert Video: Why is documentation important?
Readings
- Introduction
- 5 Excel Blunders that show how important safe Excel use is
- Match the correct solution to the problem
- Testing your input data
- How to format consistently in Excel
- The importance of documentation
Practice Exercise
- A foundation for better spreadsheets
Videos
- Recap “Fundamentals” and Intro “Functions & Formulas” in Excel
- Expert Video: Pitfalls of commonly used Functions & Formulas
- Expert Video: Functions and Formulas
- Expert Video: Functions and Alternatives
Readings
- Find & Search Functions
- Calculation Functions
- Other Functions
Videos
- Recap “Functions & Formulas” and Intro “Structure & Flow” in Excel
- Expert Video: Linear and logical spreadsheet flow
- Expert Video: Keep it Simple
- Expert Video: Protection and Hidden Information
Readings
- Linear and logical spreadsheet flow
- Keep it Simple
- Protection & Hidden Information
Practice Exercise
- Spreadsheet Structure and Logical Flow
Videos
- Recap “Structure & Flow” and Intro “Finishing Touches” in Excel
- Charts, Pivot Tables, and Reporting (Gasper Kamensek)
- Charts, Pivot Tables, and Reporting (Henk Vlootman)
- Expert Video: Checking, Testing, and Validation
- Expert Video: Finalization
Readings
- Charts and Reporting
- Checking, Testing, and Validation
- Finalization