BUS 150 W — Discovering Your Inner Quant Jock: Financial Modeling and Business Decisions
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.