Course Content
Part 1: Time and your first model
Welcome! This course will show you step by step how to use Openbox. If you haven’t already, you can get a 45 day free trial of the software by clicking the “Download” button at the top of the screen.
0/3
Intro
00:55
1a: Build a 3 Financial Statement model
04:21
1b Standard project finance model
06:57
Part 2: Reports
This section of the course shows you how to create and edit reports. Reports are the purpose of the model – the results it produces – and every model needs to have at least one.
0/3
Intro
00:50
2a: Adding a new report
04:12
2b: Importing a whole report structure
02:12
Part 3: Calculations
0/5
Intro
00:19
3a: Instant mode
06:20
3b: Instant mode with alt down
01:54
3c editing in normal OBX window
04:22
3d: Editing a calculation in the preview window
03:23
Part 4: Inputs
0/4
Intro
00:22
4a: Entering inputs
02:30
4b: Input sheets and types of input
03:16
4c: Entering complex inputs, such as tables or time series
01:10
Part 5: Visualizing your model
0/3
Intro
00:39
5a: Focus mode
02:58
5b: Model structure
03:53
Part 6: Components
0/5
Intro
00:55
6a: Finding a component
02:29
6b: Importing components
03:55
6c: suggesting components
01:10
6d: Creating your own components
03:37
Part 7: Validating and sending to Excel
0/3
Intro
00:42
7a: Validating – checking – your models
02:36
7b: Sending the model to Excel
01:58
Advanced topics
This section covers more advanced topics, such as creating a portfolio of assets using arrays, editing the model once it has been created in Excel, and so on.
0/1
A1: Portfolio of assets
00:00
Course completion
0/1
Get your certificate
00:00
Introduction to Openbox
About Lesson

Components let you use tried and trusted parts of spreadsheet models again, with just a few clicks. This video shows you how to find components, and how to bring them into your models.

Join the conversation
Previous
Next