fullscreen background
Skip to main content

Summer Quarter

Summer Courses Still Open
View Fall Courses Jul 28
shopping cart icon0


« Back to Professional & Personal Development

BUS 150 W — Discover Your Inner Quant Jock: Financial Modeling and Business Decisions

Quarter: Summer
Course Format: Flex Online (About Formats)
Duration: 9 weeks
Date(s): Jun 20—Aug 26
Refund Deadline: Jun 23
Unit: 1
Tuition: $670
Instructor(s): Iddo Hadar
Limit: 45
Class Recording Available: Yes
Status: Closed
Please Note: No class the week of June 27
DOWNLOAD THE SYLLABUS » (subject to change)
Flex Online(About Formats)
Jun 20—Aug 26
9 weeks
Refund Date
Jun 23
1 Unit
Iddo Hadar
Please Note: No class the week of June 27
DOWNLOAD THE SYLLABUS » (subject to change)
We have a great tool—a super-powerful spreadsheet on our desktops and laptops—but most of us rarely use more than 5 percent of Microsoft Excel’s functionality to resolve the many financial and business decisions that we face in our professional and personal lives. What a missed opportunity! This online course will provide students with the methods and the mindset to make complex financial and economic decisions by framing them as analytical models and using Excel spreadsheets to solve them. Topics covered will include general techniques (structure, parameters, sensitivity analysis, scenarios, and reporting), as well as demand forecasting, financial analysis, and optimization. We will also discuss personal financial planning, data mining, dealing with uncertainty, and other relevant topics. The course will keep theory to a minimum, focusing on hands-on implementation and practice using a variety of cases.

Students must have access to Microsoft Excel. All exercises will be demonstrated in Excel 2013 (Windows) and 2016 (Mac) but should be easily understandable by users of other Excel versions. This course relies on tutorial videos that feature highly detailed visual elements. Taking this course using a mobile device is not advised.

Growth Strategist; Private Equity Executive; Mergers and Acquisitions Expert

Iddo Hadar has over thirty years of strategy experience in high tech, combining industry and consulting work in mergers and acquisitions, restructuring, technology strategy, and marketing strategy at Boston Consulting Group, Ernst & Young, and Applied Materials, among others. He has also been a software product manager and a turnaround CEO of a digital publishing startup. He received an MBA from Stanford, where he was an Arjay Miller Scholar.

Textbooks for this course:

There are no required textbooks; however, some fee-based online readings may be assigned.