fullscreen background
Skip to main content

Summer Quarter

Summer Registration Opens May 17
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: Flex Online (About Formats)
Duration: 9 weeks
Date(s): Jun 21—Aug 27
Refund Deadline: Jun 24
Unit: 1
Tuition: $670
Instructor(s): Iddo Hadar
Limit: 45
Class Recording Available: Yes
Status: Registration opens May 17, 8:30 am (PT)
Please Note: No class the week of July 5
DOWNLOAD THE SYLLABUS » (subject to change)
Summer
Flex Online(About Formats)
Date(s)
Jun 21—Aug 27
9 weeks
Refund Date
Jun 24
1 Unit
Fees
$670
Instructor(s):
Iddo Hadar
Limit
45
Recording
Yes
Registration opens May 17, 8:30 am (PT)
Please Note: No class the week of July 5
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 Microsoft 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 Microsoft 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.

IDDO HADAR
Mergers and Acquisitions Expert; Principal and Associate Director, Boston Consulting Group

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.