fullscreen background
Skip to main content

Summer Quarter

Summer Registration Now Open
Most Classes Begin Jun 26
shopping cart icon0

Courses

« Back to Professional & Personal Development

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

Quarter: Summer
Course Format: Online course (System Requirements)
Duration: 9 weeks
Date(s): Jun 26—Aug 25
Drop Deadline: Jul 4
Unit: 1
Tuition: $605
Instructor(s): Iddo Hadar
Limit: 50
Status: Open
Summer
Date(s)
Jun 26—Aug 25
9 weeks
Drop By
Jul 4
1 Unit
Fees
$605
Instructor(s):
Iddo Hadar
Limit
50
Open
COURSE DESCRIPTION:

We have a great tool—a super-powerful spreadsheet on our desktops—but most of us rarely use more than 5 percent of Microsoft Excel’s functionality to solve the many financial and business decisions that we face in our professional and personal lives. What a missed opportunity!

This 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 Microsoft Excel spreadsheets to solve them. Topics covered will include general techniques (structure, parameters, sensitivity analysis, scenarios, reporting), as well as demand forecasting, financial analysis, and optimization. We will also discuss personal financial planning, data mining, dealing with uncertainty, and more. The course will keep theory to a minimum, focusing on hands-on implementation and practice using a variety of cases.

WHAT MAKES OUR ONLINE COURSES UNIQUE:

  • Course sizes are limited.
    You won't have 5,000 classmates. This course's enrollment is capped at 50 participants.

  • Frequent interaction with the instructor.
    You aren't expected to work through the material alone. Instructors will answer questions and interact with students on the discussion board and through weekly video meetings.

  • Study with a vibrant peer group.
    Stanford Continuing Studies courses attract thoughtful and engaged students who take courses for the love of learning. Students in each course will exchange ideas with one another through easy-to-use message boards as well as optional weekly real-time video conferences.

  • Direct feedback from the instructor.
    Instructors will review and offer feedback on assignment submissions. Students are not required to turn in assignments, but for those who do, their work is graded by the instructor.

  • Courses offer the flexibility to participate on your own schedule.
    Course work is completed on a weekly basis when you have the time. You can log in and participate in the class whenever it's convenient for you. If you can’t attend the weekly video meetings, the sessions are always recorded for you and your instructor is just an email away.

  • This course is offered through Stanford Continuing Studies.
    To learn more about the program, visit our About Us page. For more information on the online format, please visit the FAQ page.

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

Iddo Hadar, M&A Transaction Advisor, Ernst & Young

Iddo Hadar has thirty years of strategy experience in many segments of high tech—combining industry and consulting work in mergers and acquisitions, restructuring, technology strategy, and marketing strategy. Earlier, he was head of corporate strategy and chief marketing officer at Applied Materials and a turnaround CEO of a digital publishing startup. He received an MBA from Stanford.
DOWNLOAD THE PRELIMINARY SYLLABUS » (subject to change)