Engineering Pathway

We have added new content on Excel VBA in this pathway, and replaced the existing PowerPoint Skills and Economics topics with new and improved content. As a result your pathway completion may have changed. Discover the new content sections below.

Intern 0/52 Playlists Completed

Menu and Shortcut Basics

Financial Modeling | 7 videos | 1 quiz
Intro to Excel and Interface
1 of 8
01:50
The Ribbon
2 of 8
03:57
Shortcut Basics - Accelerator Keys
3 of 8
03:37
Excel Set Up
4 of 8
03:35
Selecting
5 of 8
01:56
Copying
6 of 8
03:10
Editing
7 of 8
02:51
Menus & Shortcut Basics Tryout
8 of 8

Basic Formatting

Financial Modeling | 7 videos | 1 quiz
Font
1 of 8
03:49
Cell Borders and Fill Colors
2 of 8
04:57
Alignment
3 of 8
04:27
Number Formats
4 of 8
02:02
Styles
5 of 8
05:16
Cell Size
6 of 8
04:40
Standard Formatting Often Used
7 of 8
02:16
Basic Formatting Tryout
8 of 8

Basic Formulas and Calculations

Financial Modeling | 4 videos | 1 quiz
Intro to Formulas
1 of 5
03:29
Intro to Formula Workout
2 of 5
03:57
Avoid Hardcodes in Formulas
3 of 5
04:17
Intro to Functions and Syntax
4 of 5
06:35
Basic Formulas and Calculations Tryout
5 of 5

Basic Functions

Financial Modeling | 10 videos | 1 quiz
COUNT Function
1 of 11
03:58
MIN Function
2 of 11
02:48
MAX Function
3 of 11
04:07
AVERAGE Function
4 of 11
02:00
IF Function
5 of 11
03:20
SUMPRODUCT Function
6 of 11
00:47
SUMPRODUCT Function Workout 1
7 of 11
04:36
SUMPRODUCT Function Workout 2
8 of 11
03:02
SUMPRODUCT With Add, Subtract and Divide
9 of 11
00:49
SUMPRODUCT With Add, Subtract Workout
10 of 11
03:11
Basic Functions Tryout
11 of 11

Naming Cell References

Financial Modeling | 3 videos | 1 quiz
Intro to Naming Cells
1 of 4
04:21
Creating Names Using the Mouse
2 of 4
01:08
Creating Names Using Name Manager
3 of 4
04:06
Naming Cells & Referencing Tryout
4 of 4

Advanced Formatting

Excel | 10 videos | 1 quiz
Cell Styles
1 of 11
01:12
Normal Cell Style
2 of 11
02:32
Normal Cell Style Workout
3 of 11
03:31
Percent, Date, Multiple and Hard Code Cell Styles
4 of 11
02:32
Percent, Date, Multiple, Hard Code Workout
5 of 11
04:04
Conditional Formatting
6 of 11
00:35
Conditional Formatting Workout
7 of 11
02:32
Conditional Formatting with Formulas Workout
8 of 11
03:17
Data Validation - Formatting
9 of 11
00:42
Data Validation Workout
10 of 11
02:09
Advanced Formatting Tryout
11 of 11

Exploring a Model

Excel | 5 videos | 1 quiz
F5 Tips and Tricks
1 of 6
04:48
Camera Tool
2 of 6
02:09
Watch Window
3 of 6
02:18
Split Windows
4 of 6
01:31
Circularity Issues
5 of 6
04:45
Exploring a Model Tryout
6 of 6

Text and Date

Excel | 9 videos | 1 quiz
Text Functions
1 of 10
01:56
CONCATENATE, LEN, FIND, RIGHT, LEFT Workout
2 of 10
02:46
UPPER, LOWER, PROPER, VALUE Workout
3 of 10
01:58
Date Functions
4 of 10
01:45
Date Formatting
5 of 10
01:12
Date Formatting Workout
6 of 10
02:55
DAY, MONTH, YEAR, DATE Workout
7 of 10
02:02
TODAY, WORKDAY, EOMONTH Workout
8 of 10
01:41
DATEDIF Workout
9 of 10
01:46
Text and Date Tryout
10 of 10

Excel Charts and Graphs

Excel | 14 videos
Column Chart
1 of 14
02:34
Pie Chart
2 of 14
02:20
Column Chart Side By Side
3 of 14
02:32
Column Chart Overlapping
4 of 14
02:46
Pie Chart - Value and Percentage
5 of 14
02:08
Stock Price History and Volume Bar Chart 1
6 of 14
03:52
Stock Price History And Volume Bar Chart 2
7 of 14
03:06
Stock Price Rebased To 100 Chart
8 of 14
03:54
XY Scatter Chart
9 of 14
05:16
Logos In Charts
10 of 14
02:21
Using Paste Format In Charts
11 of 14
01:55
Waterfall Chart
12 of 14
01:57
Floating Bar Chart
13 of 14
13:51
Benchmarking Chart
14 of 14
03:32

Scenarios

Excel | 13 videos | 1 quiz
Choose Function
1 of 14
01:38
Choose Function Workout
2 of 14
02:09
Offset Function
3 of 14
01:38
Offset Function Workout
4 of 14
01:53
Index Function
5 of 14
01:04
Index Function Workout
6 of 14
02:36
Match Function
7 of 14
01:30
Match Function Workout
8 of 14
02:49
Data Validation - Scenarios
9 of 14
01:03
Data Validation Workout
10 of 14
02:09
Conditional Formatting
11 of 14
02:15
Conditional Formatting Workout
12 of 14
02:33
Scenario Use in a Model Workout
13 of 14
04:23
Scenarios Tryout
14 of 14

Data Extraction

Excel | 10 videos | 1 quiz
Lookup, Index, Offset and Match Functions
1 of 11
02:48
Lookup, Index, Offset and Match Functions Workout
2 of 11
05:37
XLOOKUP Workout
3 of 11
02:24
Nested XLOOKUP Workout
4 of 11
03:42
Working With Multiple Sheets
5 of 11
00:35
Working With Multiple Sheets Workout 1
6 of 11
04:10
Multiple Sheets Indirect Workout 2
7 of 11
03:45
Multiple Sheets Formulatext Workout 3
8 of 11
02:06
Transposing Data
9 of 11
00:41
Transposing Data Workout
10 of 11
04:10
Data Extraction Tryout
11 of 11

Sensitivity Data Tables

Excel | 10 videos | 1 quiz
Simple Data Tables
1 of 11
01:04
Simple Data Table - One Input One Output
2 of 11
02:12
Simple Data Table - One Input Multiple Output
3 of 11
01:32
Simple Data Tables - Two Input One Output
4 of 11
01:43
Data Tables Best Practice
5 of 11
00:57
Advanced Data Tables
6 of 11
02:00
Advanced and Flexible Data Tables
7 of 11
03:29
Three Input Data Table - Left Right
8 of 11
05:09
Three Input Data Table - Pivot
9 of 11
12:04
Three Input Data Table - Offset
10 of 11
07:14
Sensitivity Data Tables Tryout
11 of 11

Goal Seek and Solver

Excel | 5 videos | 1 quiz
Goal Seek Tool
1 of 6
00:47
Goal Seek Model
2 of 6
01:10
Solver Tool
3 of 6
00:50
Installing Solver Add-in
4 of 6
00:32
Solver Example
5 of 6
02:37
Goal Seek and Solver Tryout
6 of 6

Database Analysis

Excel | 12 videos | 1 quiz
Simple Sorting
1 of 13
05:30
Advanced Sorting
2 of 13
06:40
Auto Filters
3 of 13
06:39
Advanced Filters
4 of 13
09:45
Subtotals
5 of 13
05:58
Sum IF
6 of 13
07:11
D Functions
7 of 13
05:07
Simple Pivot Tables
8 of 13
08:18
Cross Tab Pivot Tables
9 of 13
03:44
Filters and Slicers
10 of 13
04:48
Pivot Table Grouping
11 of 13
02:23
D Functions and Pivot emulation
12 of 13
03:12
Database Analysis Tryout
13 of 13

Introduction to Macros

Legacy | 13 videos | 1 quiz
Macros Overview and Settings
1 of 14
02:35
Recording a Macro
2 of 14
06:52
Macro Relative References
3 of 14
03:26
Macro Security
4 of 14
04:10
Running Macros - Keyboard
5 of 14
02:11
Running Macros - QAT
6 of 14
03:27
Running Macros - Worksheet Object
7 of 14
02:17
Running Macros - Ribbon
8 of 14
02:59
The VBA Editor - Overview
9 of 14
04:37
The VBA Editor - Organizing
10 of 14
02:39
The VBA Editor - Comments
11 of 14
02:14
The VBA Editor - Backup
12 of 14
01:25
Recording Macros with Calculations
13 of 14
11:15
Introduction to Macros Tryout
14 of 14

The Ribbon and Quick Access Toolbar

Microsoft Office Skills | 4 videos | 1 quiz
PowerPoint Interface Overview
1 of 5
01:40
The Ribbon
2 of 5
01:15
Quick Access Toolbar (QAT) and Customizing the QAT
3 of 5
04:42
Productivity Tools
4 of 5
00:41
The Ribbon and Quick Access Toolbar Tryout
5 of 5

Slides and Slide Master

Microsoft Office Skills | 7 videos | 1 quiz
Aspect Ratio or Slide Size
1 of 8
01:40
Adding Slides and Section Dividers
2 of 8
01:22
Slide Master Introduction
3 of 8
00:51
Slide Master - Editing Layouts
4 of 8
01:21
Slide Master - Editing Fonts and Colors
5 of 8
01:30
Slide Master - Editing the Footer
6 of 8
00:40
Gridlines, Guidelines and Smart Guides
7 of 8
01:29
Slides and Slide Master Tryout
8 of 8

Collaborating and Printing

Microsoft Office Skills | 2 videos | 1 quiz
Comments and Feedback
1 of 3
00:47
Saving and File Properties for Printing
2 of 3
01:30
Collaborating and Printing Tryout
3 of 3

Working with Text

Microsoft Office Skills | 8 videos | 1 quiz
Adding Text - Text Boxes vs. Shapes
1 of 9
01:20
Basic Text Formatting
2 of 9
00:44
Advanced Text Formatting
3 of 9
00:39
Paragraph Formatting
4 of 9
00:39
Adjusting Shape Margins with Text
5 of 9
00:47
Adding Hyperlinks
6 of 9
01:00
Find and Replace
7 of 9
01:07
Building an Equation
8 of 9
01:17
Working with Text Tryout
9 of 9

Working with Shapes

Microsoft Office Skills | 9 videos | 1 quiz
Intro to PowerPoint Objects
1 of 10
00:34
Transforming Shapes and Other Objects
2 of 10
01:41
Basic Shapes Formatting and Effects
3 of 10
01:03
Advanced Shape Formatting and Effects
4 of 10
00:58
Alignment and Rotate Tool
5 of 10
01:12
Send Backwards or Forwards
6 of 10
01:28
Grouping and Ungrouping
7 of 10
00:49
Lines and Connectors
8 of 10
01:25
Merging Shapes and Adding Points
9 of 10
01:30
Working with Shapes Tryout
10 of 10

Working with Images, Icons and Video

Microsoft Office Skills | 8 videos | 1 quiz
Inserting an Image and Image Licensing
1 of 9
01:20
Transforming Images
2 of 9
00:29
Image Editing
3 of 9
01:36
Cropping and Compressing
4 of 9
03:23
Image File Types
5 of 9
01:51
Creating and Inserting Screenshots
6 of 9
01:11
Icons Tools
7 of 9
01:14
Adding a Video
8 of 9
01:36
Working with Images, Icons and Video Tryout
9 of 9

Working with Animations and Transitions

Microsoft Office Skills | 4 videos | 1 quiz
Animations Overview
1 of 5
00:58
Animation Pane and Sequencing Animations
2 of 5
05:31
Other Animation Tools
3 of 5
01:10
Transitions Overview
4 of 5
00:38
Animations and Transitions Tryout
5 of 5

Working with Lists and SmartArt

Microsoft Office Skills | 5 videos | 1 quiz
Re-ordering Items List
1 of 6
00:37
SmartArt from Scratch and a List
2 of 6
00:58
SmartArt Design
3 of 6
02:01
Formatting SmartArt
4 of 6
00:53
SmartArt with Images
5 of 6
01:22
Working with Lists and SmartArt Tryout
6 of 6

Working with Tables

Microsoft Office Skills | 4 videos | 1 quiz
Inserting a Table using PowerPoint
1 of 5
01:35
Inserting a Table from Excel using Paste Special
2 of 5
04:06
Table Design
3 of 5
01:48
Table Layout
4 of 5
02:04
Working with Tables Tryout
5 of 5

Working with Charts

Microsoft Office Skills | 10 videos | 1 quiz
Introduction to Charts
1 of 11
01:02
Importing Excels Charts as an Image
2 of 11
02:59
Importing Excel Chart with Automatic Updates
3 of 11
04:35
Importing Excel Charts - Paste Options
4 of 11
00:35
Use Destination Theme vs Keep Source Formatting
5 of 11
01:10
Embed Workbook vs Link Data
6 of 11
01:30
Chart Design - Imported Charts from Excel
7 of 11
02:04
Creating a Simple Chart in PowerPoint
8 of 11
01:59
Formatting Tips for Charts
9 of 11
03:18
Creating Templates for Charts
10 of 11
01:30
Working with Charts Tryout
11 of 11

Outlook Introduction

Microsoft Office Skills | 25 videos
How to Create and Add an Outlook Email Address to Your Profile
1 of 25
04:21
Adding Gmail
2 of 25
06:08
Moving Between Accounts
3 of 25
03:03
Understanding Data Files
4 of 25
04:22
Removing an Email Address from Your Profile
5 of 25
01:21
Navigation
6 of 25
02:49
Creating a New Email
7 of 25
02:39
Email Message Options
8 of 25
03:50
Adding Attachments
9 of 25
01:11
Saving and Editing a Draft Email
10 of 25
03:59
Delay Sending
11 of 25
02:07
Recall
12 of 25
02:13
Folders and Sorting
13 of 25
05:44
Reply Forward and Resend
14 of 25
02:40
Rules
15 of 25
03:43
Using Search
16 of 25
01:44
Out of Office Assistant
17 of 25
01:36
Signature
18 of 25
02:59
Calendar View Intro
19 of 25
01:57
Adding Appointments to Cal
20 of 25
05:00
Contacts
21 of 25
03:22
Adding Google Calendar
22 of 25
01:46
Timezones
23 of 25
04:29
Tasks
24 of 25
05:25
Assigning Tasks
25 of 25
01:31

Microsoft Word - Introduction

Microsoft Office Skills | 7 videos
Intro to Word
1 of 7
04:27
Save vs. Save As
2 of 7
02:41
Adding Text and Default Settings
3 of 7
02:35
Hard Return vs. Soft Return
4 of 7
01:25
Keyboard Nav, Select and Edit
5 of 7
04:20
Find and Replace
6 of 7
05:41
Using Mouse to Nav, Select and Mini Toolbar
7 of 7
01:24

Microsoft Word - Formatting

Microsoft Office Skills | 7 videos
The Font Menu
1 of 7
06:02
Paragraph
2 of 7
05:59
Intro to Styles
3 of 7
03:01
Using Styles to Re-Order Quickly
4 of 7
02:25
Using Styles for Auto TOC Creation
5 of 7
02:33
Creating Styles
6 of 7
03:18
Adding Styles to the QAT
7 of 7
03:19

Microsoft Word - Inserting

Microsoft Office Skills | 7 videos
Page Breaks
1 of 7
02:25
Page Setup
2 of 7
05:13
The Insert Tab Intro
3 of 7
00:50
Headers and Footers
4 of 7
03:57
Comments
5 of 7
02:23
Pictures
6 of 7
06:07
Equations
7 of 7
06:31

Microsoft Word - Common Tasks

Microsoft Office Skills | 7 videos
Track Changes
1 of 7
05:47
Spell and Grammar Check
2 of 7
06:06
Autocorrect
3 of 7
03:52
Adding a Cover Page
4 of 7
01:37
Custom Cover Page
5 of 7
06:41
Using Passwords to Protect your Document
6 of 7
02:19
Final Checks
7 of 7
05:03

Building your Brand and Career

Professional Skills and Careers | 3 videos | 1 quiz
Building Your Brand and Career - Part 1
1 of 4
04:30
Building Your Brand and Career - Part 2
2 of 4
03:10
Building Your Brand and Career - Part 3
3 of 4
02:42
Building Your Brand and Career Tryout
4 of 4

Developing Your Business Writing Effectiveness

Professional Skills and Careers | 2 videos | 1 quiz
Developing Your Business Writing Effectiveness - part 1
1 of 3
05:31
Developing Your Business Writing Effectiveness - part 2
2 of 3
02:59
Developing your Business Writing Effectiveness Tryout
3 of 3

Communicating and Presenting Skills

Professional Skills and Careers | 5 videos | 1 quiz
Fundamentals of Communicating and Presenting Part 1
1 of 6
03:53
Fundamentals of Communicating and Presenting Part 2
2 of 6
02:02
Presenting yourself with Impact and Influence Part 1
3 of 6
03:39
Presenting yourself with Impact and Influence Part 2
4 of 6
05:26
Questioning and Listening Skills
5 of 6
06:54
Presentation and Communication Skills Tryout
6 of 6

Accounting Foundations

Accounting | 22 videos | 1 quiz
What is Accounting
1 of 23
03:21
Who Uses Financial Statements - Part 1
2 of 23
03:28
Who Uses Financial Statements - Part 2
3 of 23
03:32
What are the Three Main Financial Statements
4 of 23
04:01
What Else is in Financial Reports - Annual Report
5 of 23
03:29
What Else is in Financial Reports - Press Release
6 of 23
01:06
What Else is in Financial Reports - Other Statements
7 of 23
02:02
What Are Accounting Standards
8 of 23
03:42
How Often Are Financial Statements Prepared
9 of 23
02:22
Annual Report Example
10 of 23
05:14
The Accounting Equation
11 of 23
04:43
The Balance Sheet - Assets
12 of 23
02:45
The Balance Sheet - Liabilities
13 of 23
02:09
The Balance Sheet - Equity
14 of 23
01:37
Balance Sheet Example
15 of 23
05:32
The Income Statement
16 of 23
04:39
Income Statement Example
17 of 23
03:49
The Cash Flow Statement
18 of 23
02:41
Cash Flow Statement Example
19 of 23
02:54
Accrual Accounting
20 of 23
04:46
The Matching Principle
21 of 23
01:21
Capitalization
22 of 23
03:08
Accounting Foundations Tryout
23 of 23

Accounting Fundamentals

Intern | 23 videos | 1 quiz
Why Analyze Financial Statements Fundamentals
1 of 24
03:38
Accounting Introduction Fundamentals
2 of 24
02:26
Financial Statement Dates Fundamentals
3 of 24
02:21
Build a Simple Balance Sheet Fundamentals
4 of 24
02:17
Build a Simple Balance Sheet Fundamentals Workout
5 of 24
08:01
Income Statement Introduction Fundamentals
6 of 24
01:12
Matching Principle Introduction Fundamentals
7 of 24
01:36
IS Presentation and Expenses Fundamentals
8 of 24
02:34
Operating Profit and EBIT Fundamentals
9 of 24
05:05
Working Capital and Operating Working Capital Fundamentals
10 of 24
04:30
Working Capital Fundamentals Workout
11 of 24
01:52
Non Current Assets Introduction Fundamentals
12 of 24
01:25
Forecasting PPE Fundamentals
13 of 24
02:37
PP&E Depreciation Fundamentals
14 of 24
03:19
PP&E Transactions Fundamentals
15 of 24
02:08
Equity vs. Debt, and Leverage Fundamentals
16 of 24
04:41
Net Debt Fundamentals
17 of 24
02:32
Net Debt Fundamentals Workout
18 of 24
03:47
Leverage Ratios Fundamentals
19 of 24
03:18
Forecasting Retained Earnings Fundamentals
20 of 24
01:41
CFS Introduction and Why Cash Is Important Fundamentals
21 of 24
03:09
Cash Flow Statement - Reconciliation Fundamentals
22 of 24
03:33
Financial Statements Integration Fundamentals
23 of 24
02:25
Accounting Fundamentals Tryout
24 of 24

Financial Accounting Review

Accounting | 9 videos | 1 quiz
Why Analyze Financial Statements
1 of 10
03:29
Accounting Introduction - Financial Statements
2 of 10
02:13
Key Financial Statements and Dates
3 of 10
02:02
Balance Sheet Formula
4 of 10
01:11
Build a Simple Balance Sheet
5 of 10
05:25
Balance Sheet and Income Statement Transactions
6 of 10
05:40
Balance Sheet and Income Statement Transactions Workout
7 of 10
09:58
Financial Statement Integration
8 of 10
02:13
Cash Flow Statement Introduction and Why is Cash Important
9 of 10
02:23
Financial Accounting Review Tryout
10 of 10

Financial Math Fundamentals

Financial Math | 3 videos | 3 quizzes
Present Value and Future Value
1 of 6
08:09
Present Value and Future Value Tryout
2 of 6
Yields and Internal Rate of Return
3 of 6
11:49
Yields and Internal Rate of Return Tryout
4 of 6
Annuities and Perpetuities
5 of 6
09:50
Annuities and Perpetuities Tryout
6 of 6

Statistics - Basic Concepts

Financial Math | 3 videos | 1 quiz
Distributions
1 of 4
02:42
Normal and Non-Normal Distributions
2 of 4
05:26
Variance and Standard Deviation
3 of 4
06:59
Statistics - Basic Concepts Tryout
4 of 4

Statistics - Portfolio Statistics

Financial Math | 3 videos | 1 quiz
Probabilities and Expected Returns
1 of 4
03:53
Covariance and Correlation
2 of 4
06:56
Portfolio Expected Returns and Standard Deviation
3 of 4
06:24
Statistics - Portfolio Statistics Tryout
4 of 4

Statistics - Analytic Methods

Financial Math | 3 videos | 1 quiz
Regressions
1 of 4
06:28
Monte Carlo Simulations
2 of 4
05:33
Interpreting Data Analysis
3 of 4
04:42
Statistics - Analytic Methods Tryout
4 of 4

Equity Indices

Capital Markets | 5 videos | 1 quiz
Equity Indices - Introduction
1 of 6
03:26
Market Value Weighted
2 of 6
02:14
Price Weighted
3 of 6
01:35
Equally Weighted
4 of 6
01:47
Fundamentally Weighted
5 of 6
01:43
Equity Indices Tryout
6 of 6

Macroeconomics – Fundamentals and GDP

Economics | 7 videos | 1 quiz
Macro vs. Microeconomics
1 of 8
01:34
Link Between Financial Markets and the Economy
2 of 8
03:19
The Economic Cycle
3 of 8
05:00
Gross Domestic Product (GDP)
4 of 8
04:56
Gross Domestic Product (GDP) Over Time
5 of 8
05:06
Nominal vs. Real Gross Domestic Product (GDP)
6 of 8
05:35
Benefits of Gross Domestic Product (GDP) Growth
7 of 8
05:09
Macroeconomics – Fundamentals and GDP Tryout
8 of 8

Macroeconomics - Inflation and Unemployment

Economics | 8 videos | 1 quiz
Macroeconomic Objectives
1 of 9
02:48
Inflation
2 of 9
03:28
Inflation Complexities
3 of 9
05:33
Core vs. Non-Core Inflation
4 of 9
03:19
Types of Unemployment
5 of 9
02:34
Full Employment
6 of 9
02:27
Measuring Unemployment
7 of 9
07:49
U.S. Unemployment & Participation Rate
8 of 9
01:46
Macroeconomics - Inflation and Unemployment Tryout
9 of 9

Macroeconomics - Fiscal and Monetary Policy

Economics | 5 videos | 1 quiz
Fiscal and Monetary Policy
1 of 6
05:49
Budget Deficits and Government Debt
2 of 6
03:30
Central Bank Monetary Policy
3 of 6
04:32
Additional Functions of Central Banks
4 of 6
03:14
Business Cycle vs. Market Cycle
5 of 6
02:01
Macroeconomics - Fiscal and Monetary Policy Tryout
6 of 6

Macroeconomics - Indicators

Economics | 5 videos | 1 quiz
Economic Indicators
1 of 6
04:00
Leading Indicators
2 of 6
01:56
Coincident Indicators
3 of 6
01:45
Lagging Indicators
4 of 6
01:21
The Market Narrative
5 of 6
02:56
Macroeconomics - Indicators Tryout
6 of 6

Market Sectors

Capital Markets | 2 videos | 1 quiz
Market Sectors
1 of 3
04:24
Industrials vs. Financials
2 of 3
02:29
Market Sectors Tryout
3 of 3

Introduction to Excel VBA

Excel | 7 videos
Introduction to Excel VBA
1 of 7
01:30
The Excel VBA Environment
2 of 7
05:24
The Macro Recorder
3 of 7
02:23
The Macro Recorder Workout
4 of 7
01:55
Running Macros Workout
5 of 7
05:10
The VBA Editor Workout
6 of 7
06:11
The Macro Recorder Summary
7 of 7
01:14
Excel Object VBA Overview
1 of 11
04:41
Objects, Properties and Methods
2 of 11
02:17
Objects, Properties and Methods Workout
3 of 11
03:46
Range Objects
4 of 11
04:18
Range Object Workout
5 of 11
04:39
Range Objects, Properties and Methods
6 of 11
04:38
Range Objects and Methods Workout
7 of 11
04:27
Worksheets and Workbooks Collection
8 of 11
03:21
Excel and VBA Functions
9 of 11
01:32
Excel VBA Functions Workout
10 of 11
04:49
The Object Browser
11 of 11
01:03
Introduction to Variables
1 of 13
02:39
Declaring Variables
2 of 13
02:37
Declaring Variables Workout
3 of 13
07:18
For Each Next
4 of 13
02:03
For Each Next Workout
5 of 13
05:31
If Then Else
6 of 13
02:28
If Then Else Workout
7 of 13
07:13
For Next
8 of 13
02:31
Do Loops
9 of 13
03:43
Select Case
10 of 13
02:11
Select Case Workout
11 of 13
12:57
With End With
12 of 13
01:14
Error Handling
13 of 13
02:06
Introduction to User Defined Functions
1 of 8
01:30
User Defined Functions Part 1 Workout
2 of 8
03:53
User Defined Functions Part 2 Workout
3 of 8
12:37
Workbook and Worksheet Events
4 of 8
02:12
Worksheet Events Workout
5 of 8
04:07
Workbook Events Workout
6 of 8
03:44
Arrays
7 of 8
01:11
Arrays Workout
8 of 8
10:28

Modifying the User Interface

Excel | 6 videos
Form Controls on a Worksheet
1 of 6
03:00
Check Box Workout
2 of 6
04:14
Combo Box Workout
3 of 6
02:32
Form Controls vs. ActiveX Controls
4 of 6
01:41
MsgBox and InputBox
5 of 6
03:50
UserForm Walkthrough
6 of 6
18:06

Interacting with Charts

Excel | 7 videos
The Chart Object
1 of 7
01:39
Chart Properties and Methods Part 1
2 of 7
01:21
Chart Properties and Methods Part 2
3 of 7
01:42
Chart Workout 1
4 of 7
02:26
Chart Workout 2
5 of 7
03:28
Chart Events
6 of 7
01:08
Interactive Chart Walkthrough Workout
7 of 7
13:40
Analyst 0/29 Playlists Completed

Intro to Python

Data Science and Systems | 13 videos
Introduction to Python Learning Objectives
1 of 13
00:23
Python Fundamentals Introduction
2 of 13
01:08
Downloading Anaconda
3 of 13
02:02
Introducing Jupyter Notebook
4 of 13
02:42
Calculations
5 of 13
00:57
Calculations Workout
6 of 13
01:43
Mathematical Operators
7 of 13
01:26
Text Outputs
8 of 13
03:21
Dynamic Outputs
9 of 13
02:22
Text Workout
10 of 13
03:34
Variables
11 of 13
05:01
Variables Workout
12 of 13
11:36
Introduction to Python Review
13 of 13
00:26

Python Objects

Data Science and Systems | 20 videos
Python Objects Learning Objectives
1 of 20
00:22
Python Object Types
2 of 20
03:42
Object Type Workout
3 of 20
00:51
Lists
4 of 20
04:05
Accessing List Objects
5 of 20
04:19
Lists Workout
6 of 20
05:04
Changing List Objects
7 of 20
02:54
More List Functions
8 of 20
02:05
List Functions Workout
9 of 20
03:01
Tuples
10 of 20
02:13
Sets
11 of 20
01:58
Using Sets to Remove Duplicates
12 of 20
02:09
Set Operations
13 of 20
03:08
Sets Workout
14 of 20
03:01
Dictionaries
15 of 20
03:02
Accessing Dictionary Items
16 of 20
01:43
Dictionary Workout
17 of 20
04:32
Dictionary Functions
18 of 20
03:14
Dictionary Functions Workout
19 of 20
01:55
Python Objects Review
20 of 20
01:00

Custom Functions, For Loops, Conditional Logic

Data Science and Systems | 11 videos
Custom Functions Learning Objectives
1 of 11
00:19
Creating Custom Functions
2 of 11
07:51
Custom Functions Workout
3 of 11
02:13
Adding Arguments
4 of 11
03:09
For Loops
5 of 11
04:04
Adding Arguments Workout
6 of 11
03:07
Filling a List with a For Loop
7 of 11
03:20
For Loops Workout
8 of 11
02:37
Conditional Logic
9 of 11
04:48
Conditional Logic Workout
10 of 11
03:44
Custom Functions Review
11 of 11
00:25

NumPy

Data Science and Systems | 18 videos
NumPy Learning Objectives
1 of 18
00:31
Importing Libraries
2 of 18
01:56
Introduction to NumPy
3 of 18
01:35
NumPy Arrays
4 of 18
02:31
Multidimensional Arrays
5 of 18
01:46
NumPy Arrays Workout
6 of 18
01:40
Reshape and Transpose
7 of 18
02:31
Selecting Objects
8 of 18
04:37
Reshaping Workout
9 of 18
03:29
Array Calculations
10 of 18
01:09
Array Functions
11 of 18
03:46
Array Function Workout
12 of 18
02:24
The Random Module
13 of 18
03:09
Setting a Random Seed
14 of 18
01:18
Random Sampling with .choice
15 of 18
01:32
Generating Sequences
16 of 18
00:54
Random Module Workout
17 of 18
03:45
NumPy Review
18 of 18
00:18

Pandas

Data Science and Systems | 18 videos
Pandas Learning Objectives
1 of 18
00:27
Pandas Introduction
2 of 18
02:14
Importing Data
3 of 18
02:49
Import From.csv
4 of 18
01:32
Get to Know Your DataFrame
5 of 18
00:59
DataFrame Workout
6 of 18
02:20
Summary Statistics
7 of 18
01:47
Summary Statistics Workout
8 of 18
01:14
Series
9 of 18
02:13
Series Functions
10 of 18
01:01
Feature Engineering
11 of 18
00:58
Series Functions & Feature Engineering Workout
12 of 18
02:12
Boolean Masks
13 of 18
03:47
Indicator Variables
14 of 18
02:57
Boolean Mask Workout
15 of 18
01:45
Segmenting with .groupby
16 of 18
01:56
Groupby Function Workout
17 of 18
01:00
Pandas Review
18 of 18
00:14

Data Cleaning and Exploration in Python

Data Science and Systems | 24 videos
Data Cleaning Learning Objectives
1 of 24
00:30
The Machine Learning Process
2 of 24
02:02
Matplotlib and Seaborn
3 of 24
00:45
Errors in Stock Data Dataset
4 of 24
01:24
Matplotlib and Seaborn Workout
5 of 24
01:46
Countplot
6 of 24
01:21
Countplot Workout
7 of 24
01:57
Replace and Sparse Classes
8 of 24
03:01
Replace Workout
9 of 24
01:55
Sparse Classes Workout
10 of 24
02:14
Spotting Outliers
11 of 24
01:08
Spotting Outliers Workout 1
12 of 24
01:31
Spotting Outliers Workout 2
13 of 24
01:23
Spotting Outliers Workout 3
14 of 24
01:15
Spotting Outliers Workout 4
15 of 24
01:38
Summary Statistics Workout
16 of 24
00:47
NaN Object
17 of 24
02:10
NaN Object Workout
18 of 24
01:02
Dropping Null Values
19 of 24
00:32
Dropping Null Values Workout
20 of 24
00:45
Box Plots
21 of 24
00:52
Box Plots Workout
22 of 24
01:17
Saving Your Data Frame
23 of 24
00:52
Data Cleaning and Exploration Review
24 of 24
00:31

Regression Algorithms in Python

Data Science and Systems | 5 videos
Regression Algorithms Learning Objectives
1 of 5
00:39
What are Regression Algorithms
2 of 5
03:09
Real Relationships & Overfitting
3 of 5
08:31
Regularization
4 of 5
06:53
Decision Trees & Ensemble Methods
5 of 5
04:32

Liquidity Regressors in Python

Data Science and Systems | 30 videos
Liquidity Regressor Learning Objectives
1 of 30
00:21
Case Study Overview
2 of 30
03:01
Importing Data Workout
3 of 30
01:09
Metadata
4 of 30
01:09
Metadata Workout
5 of 30
00:35
Splitting Your Data
6 of 30
01:57
Splitting Your Data Workout
7 of 30
02:04
Train Test Split
8 of 30
02:46
Unpacking Lists
9 of 30
01:51
Unpacking Lists Workout
10 of 30
01:24
Progress Checkpoint
11 of 30
00:13
Model Pipelines
12 of 30
04:38
Model Pipelines Workout
13 of 30
01:59
Progress Checkpoint 1
14 of 30
00:44
Hyperparameter Tuning
15 of 30
04:32
Hyperparameter Grid Workout 1
16 of 30
02:21
Hyperparameter Grid Workout 2
17 of 30
02:27
Aggregating Hyperparameter Grids
18 of 30
00:50
Progress Checkpoint 2
19 of 30
00:42
Cross Validation
20 of 30
02:06
Creating Untrained Models
21 of 30
02:13
Creating Untrained Models Workout
22 of 30
03:49
Training and Tuning Models
23 of 30
00:55
Training and Tuning Models Workout
24 of 30
02:29
Model Evaluation
25 of 30
02:02
Model Evaluation Workout
26 of 30
03:00
Progress Checkpoint 3
27 of 30
00:31
Visualizing Model Predictions
28 of 30
01:22
Visualizing Model Predictions Workout
29 of 30
01:04
Using Your Model
30 of 30
00:57

Classification Algorithms

Data Science and Systems | 4 videos
Classification Algorithms Learning Objectives
1 of 4
00:31
Binary Classification
2 of 4
03:04
Logistics Regression
3 of 4
01:46
Decision Tree Classifiers
4 of 4
00:49

Investor Classifiers in Python - Part 1

Data Science and Systems | 20 videos
Investor Classifiers Part 1 Learning Objectives
1 of 20
00:21
Overview of the Business Case
2 of 20
04:08
Importing Data Workout
3 of 20
00:40
Metadata
4 of 20
01:46
Metadata Workout
5 of 20
00:28
One Error Workout
6 of 20
01:18
Countplot of Investors Workout
7 of 20
00:56
Exploring Relationships
8 of 20
05:03
Exploring Relationships Workout
9 of 20
00:55
Reviewing Your Results
10 of 20
01:21
Feature Engineering
11 of 20
01:48
Feature Engineering Workout 1
12 of 20
02:40
Reviewing Tier Change
13 of 20
01:15
Controlling for Demotions
14 of 20
00:47
Feature Engineering Workout 2
15 of 20
00:55
Analyzing Goldman Sachs
16 of 20
00:42
fee_percent and invite_perfect Workout
17 of 20
00:38
lmplot
18 of 20
02:07
lmplot Workout
19 of 20
00:54
Investor Classifier in Python 1 Review
20 of 20
00:54

Investor Classifiers in Python - Part 2

Data Science and Systems | 24 videos
Investor Classifiers Part 2 Learning Objectives
1 of 24
00:25
Import Packages and Data
2 of 24
00:38
.drop Workout
3 of 24
00:48
Dummy Variables
4 of 24
00:54
Dummy Variables Workout
5 of 24
00:36
Remove Redundant Target
6 of 24
00:45
Splitting Data
7 of 24
02:50
Splitting Data Workout
8 of 24
00:51
Model Pipelines
9 of 24
00:38
Model Pipelines Workout
10 of 24
01:39
Validating Pipelines
11 of 24
00:17
Hyperparameter Tuning
12 of 24
01:13
Hyperparameters Workout
13 of 24
00:32
Validating Hyperparameter Grids
14 of 24
00:13
Cross Validation
15 of 24
00:57
Cross-Validation Workout
16 of 24
01:13
Fitting Untrained Models
17 of 24
00:28
Fitting Untrained Models Workout
18 of 24
01:13
AUROC
19 of 24
01:27
Confusion Matrix
20 of 24
02:52
Perfect AUROC
21 of 24
01:32
Calculating AUROC
22 of 24
00:10
Calculating AUROC Workout
23 of 24
01:33
Investor Classifiers Part 2 Review
24 of 24
00:19

SQL - Getting Started

Data Science and Systems | 9 videos | 1 quiz
Data
1 of 10
01:08
Database
2 of 10
01:08
Difference Between a Database and Spreadsheet
3 of 10
00:59
Types of Databases
4 of 10
01:36
Database Management System
5 of 10
01:06
Structured Query Language
6 of 10
01:22
SQL Key Terms
7 of 10
00:59
SQL Query Syntax and Structure
8 of 10
01:39
Integrated Development Environment
9 of 10
01:25
SQL - Getting Started Tryout
10 of 10

SQL - Fundamental Concepts

Data Science and Systems | 7 videos | 1 quiz
SQL Syntax
1 of 8
01:54
SQL String Types
2 of 8
01:09
SQL Numeric Types
3 of 8
01:24
SELECT Statement
4 of 8
01:13
SELECT Statement Workout
5 of 8
02:39
SELECT DISTINCT Statement
6 of 8
01:20
SELECT DISTINCT Workout
7 of 8
02:07
SQL - Fundamental Concepts Tryout
8 of 8

SQL - Organizing Data

Data Science and Systems | 8 videos | 1 quiz
WHERE Clause
1 of 9
01:21
WHERE Clause Workout
2 of 9
02:13
ORDER BY Statement
3 of 9
01:01
ORDER BY Statement Workout
4 of 9
02:34
Null Values
5 of 9
00:45
NULL Values Workout
6 of 9
01:48
GROUP BY Statement
7 of 9
01:11
GROUP BY Statement Workout
8 of 9
02:08
SQL - Organizing Data Tryout
9 of 9

Valuation Fundamentals

Intern | 9 videos | 1 quiz
Valuation Overview
1 of 10
02:32
Calculating Equity Value
2 of 10
02:08
Calculating Equity Value Workout
3 of 10
01:41
Enterprise Value Bridge
4 of 10
02:33
Using the Enterprise Value Bridge
5 of 10
02:08
The Bridge - EV or Equity Value
6 of 10
01:55
EV and Equity Multiples Intro
7 of 10
03:28
EV and Equity Multiples Range of Multiples
8 of 10
02:18
EV and Equity Multiples Similar Co Workout
9 of 10
02:13
Valuation Fundamentals Tryout
10 of 10

Equity Investment Vehicles

Capital Markets | 3 videos | 1 quiz
Mutual Funds
1 of 4
04:29
ETFs
2 of 4
02:34
Other Equity Investment Vehicles
3 of 4
05:45
Equity Investment Vehicles Tryout
4 of 4

Equity Investment Characteristics

Capital Markets | 6 videos | 1 quiz
Equity Investment Characteristics - Size
1 of 7
04:01
Equity Investment Characteristics - Style
2 of 7
04:09
Equity Investment Characteristics - Volatility
3 of 7
03:27
Other Equity Characteristics
4 of 7
02:43
Equity Valuation Fundamentals
5 of 7
06:29
Equity Indices
6 of 7
05:31
Equity Characteristics Tryout
7 of 7

Equities - Markets and Products

Equity Markets and Derivatives | 14 videos | 1 quiz
Cash Equities and Delta One
1 of 15
01:46
Stock Exchanges
2 of 15
03:02
Stock Exchanges Workout
3 of 15
01:31
The Order Book
4 of 15
02:07
The Order Book Workout
5 of 15
02:49
Initial Public Offerings
6 of 15
03:09
Initial Public Offerings Workout
7 of 15
01:32
Role of ECM vs. Trading Desk
8 of 15
02:34
Trading Desk Functions
9 of 15
03:31
Role of ECM vs. Trading Desk Workout
10 of 15
01:26
Convertible Securities
11 of 15
02:57
Convertible Debt Workout
12 of 15
02:37
Exchange Traded Funds
13 of 15
03:46
Exchange Traded Funds Workout
14 of 15
01:30
Equity Markets and Products Tryout
15 of 15

Equities - Derivatives

Capital Markets | 21 videos | 1 quiz
Equity Fundamentals
1 of 22
03:57
Equity Forwards Fundamentals Workout
2 of 22
02:37
Equity Futures Fundamentals
3 of 22
03:54
Equity Futures Closing Out Workout
4 of 22
02:12
Forwards and Futures Settlement
5 of 22
01:52
Pricing of Equity Forwards and Futures
6 of 22
02:52
Pricing of Equity Forwards and Futures Workout
7 of 22
03:27
Equity Forwards and Futures Arbitrage
8 of 22
03:24
Equity Forwards and Futures Arbitrage Workout
9 of 22
03:07
Equity Options Fundamentals
10 of 22
03:38
Equity Options Fundamentals Workout
11 of 22
02:05
Equity Call Option Payoffs
12 of 22
03:53
Equity Put Option Payoffs
13 of 22
03:22
Equity Options Payoffs Workout
14 of 22
04:03
Decomposing the Equity Option Premium
15 of 22
02:15
Decomposing the Equity Option Premium Workout
16 of 22
02:19
Equity Swaps
17 of 22
02:58
Equity Swaps Workout
18 of 22
02:43
Structured Products
19 of 22
02:32
Structures Products Workout
20 of 22
02:53
OTC vs. Listed
21 of 22
02:30
Equity Derivatives Tryout
22 of 22

Bonds and the Yield to Maturity

Fixed Income Markets and Derivatives | 18 videos | 1 quiz
Bonds Overview
1 of 19
03:14
Bond Price Quotation
2 of 19
03:23
Bond Redemption
3 of 19
03:34
Fixed Coupon Bonds
4 of 19
01:42
Zero Coupon Bonds
5 of 19
01:23
Floating Rate Notes (FRNs)
6 of 19
04:45
Pricing A Fixed Coupon Bond
7 of 19
03:45
Government Bond Issuance
8 of 19
02:49
Government Bond Issuance Workout
9 of 19
02:50
Yield To Maturity
10 of 19
04:20
Yield To Maturity Workout
11 of 19
05:16
Bond Price Yield Relationship
12 of 19
02:33
Yield Curve
13 of 19
02:12
Dirty Vs Clean Price
14 of 19
03:03
Dirty VS. Clean Price Characteristics
15 of 19
03:09
Fixed Coupon Cash Flow Conventions
16 of 19
02:08
Fixed Coupon Workout
17 of 19
03:54
Carry, Net-Carry and Roll Down
18 of 19
04:15
Bonds and the Yield to Maturity Tryout
19 of 19

Interest Rate Risk and Sensitivities for Bonds

Fixed Income Markets and Derivatives | 13 videos | 1 quiz
Interest Rate Risk of Fixed Coupon Bonds
1 of 14
02:48
Key Drivers of Interest Rate Sensitivity - Maturity
2 of 14
03:02
Key Drivers of Interest Rate Sensitivity - Coupon
3 of 14
04:47
Key Drivers of Interest Rate Sensitivity - Yield Level
4 of 14
04:17
Interest Rate Sensitivity Ratios
5 of 14
02:56
Macaulay Duration
6 of 14
07:40
Modified Duration
7 of 14
05:10
Convexity
8 of 14
03:41
Dollar Value of a Basis Point (DV01)
9 of 14
04:21
Duration and Dollar Value of a Basis Point (DV01) Workout
10 of 14
05:52
Portfolio DV01 Neutrality Workout
11 of 14
05:48
Interest Rate Sensitivity for Bond Portfolios
12 of 14
05:05
Interest Rate Risk of Floating-Rate Notes (FRNs)
13 of 14
06:28
Interest Rate Risk and Sensitivities for Bonds Tryout
14 of 14

Government Bonds

Fixed Income Markets and Derivatives | 16 videos | 1 quiz
Benefits of Government Bond Investments
1 of 17
02:57
Government Bond Yields as a Benchmark
2 of 17
01:34
U.S. Government Bond Products
3 of 17
04:43
On-the-Run vs. Off-the-Run Bonds
4 of 17
04:46
Government Bond Issuance
5 of 17
03:34
Government Bond Issuance - Illustration
6 of 17
04:23
The When-Issued Market - U.S. Treasuries
7 of 17
02:44
Interpreting Auction Results
8 of 17
03:44
Separate Trading of Registered Interest and Principal of Securities (STRIPS)
9 of 17
04:04
The Treasury Stripping Process
10 of 17
04:47
Reassembling Separate Trading of Registered Securities (STRIPS)
11 of 17
01:50
Treasury Inflation-Protected Securities (TIPS)
12 of 17
04:13
Inflation Linked Bonds - Example
13 of 17
02:43
Treasury Inflation-Protected Securities (TIPS) - The Real Yield
14 of 17
03:05
Break-Even Inflation
15 of 17
03:48
Non-U.S. Government Bond Market Examples
16 of 17
04:42
Government Bonds Tryout
17 of 17

Credit Risk Overview

Credit Analysis | 8 videos | 1 quiz
How Banks Make Money
1 of 9
01:06
The Credit Perspective
2 of 9
01:47
How Bad Loans Affect Banks
3 of 9
01:52
Intro to the Credit Process
4 of 9
02:40
The 5 Cs of Credit
5 of 9
01:27
Quantifying Credit Risk
6 of 9
02:11
Default Risk
7 of 9
02:39
Loss Given Default Risk
8 of 9
03:50
Credit Risk Overview Tryout
9 of 9

Corporate Bonds

Fixed Income Markets and Derivatives | 19 videos | 1 quiz
Corporate Bonds and Credit Spreads
1 of 20
05:32
How to Assess Credit Risk
2 of 20
07:09
Credit Ratings
3 of 20
04:41
The Bond Indenture and Covenants
4 of 20
04:05
Default Risk - Types of Default
5 of 20
04:01
Historical Default Rates
6 of 20
03:06
Historical Credit Spreads
7 of 20
03:25
Risk in Corporate Bonds
8 of 20
05:01
Term Structure of Credit Spreads
9 of 20
01:37
Corporate Bond Issuance
10 of 20
06:25
Corporate Bond Secondary Market
11 of 20
04:36
Different Types of Credit Spreads
12 of 20
02:16
Traditional Credit Spread
13 of 20
03:26
G-Spread
14 of 20
04:04
I-Spread
15 of 20
04:13
Z-Spread
16 of 20
04:23
Callable Bonds
17 of 20
04:31
Option-Adjusted Spread (OAS)
18 of 20
01:59
Rates Duration vs Credit Duration
19 of 20
03:12
Corporate Bonds Tryout
20 of 20

Foreign Exchange and Commodities

Capital Markets | 19 videos | 1 quiz
FX Market Intro 1
1 of 20
01:04
FX Market Intro 2
2 of 20
01:19
FX Quotes and Terms 1
3 of 20
01:07
FX Quotes and Terms 2
4 of 20
01:46
FX Quotes and Terms Workout
5 of 20
01:32
FX Common Pairs
6 of 20
00:30
FX Inverse
7 of 20
00:34
FX Inverse Workout 1
8 of 20
02:02
FX Spot Market
9 of 20
01:45
FX Spot Market Workout 1
10 of 20
00:39
FX Spot Market Workout 2
11 of 20
02:34
FX Cross Rates 1
12 of 20
01:38
FX Cross Rates 2
13 of 20
01:27
FX Cross Rates Workout 1
14 of 20
00:24
FX Cross Rates Workout 2
15 of 20
02:10
Commodities Markets Intro
16 of 20
02:03
Commodities Markets Spot
17 of 20
00:40
Commodities Markets Futures
18 of 20
01:41
Commodities Futures Workout
19 of 20
03:28
Foreign Exchange and Commodities Tryout
20 of 20

Credit Default Swaps (CDS)

Fixed Income Markets and Derivatives | 14 videos
CDS Intro
1 of 14
01:50
CDS No Credit Event
2 of 14
00:49
CDS No Credit Event Workout
3 of 14
01:15
CDS Credit Event
4 of 14
01:09
CDS Credit Event Workout
5 of 14
03:20
CDS Credit Deterioration
6 of 14
01:07
CDS Credit Deterioration Workout
7 of 14
02:02
CDS Credit Improvement
8 of 14
00:59
CDS Credit Improvement Workout
9 of 14
02:21
CDS Double Default
10 of 14
00:56
CDS Double Default Workout
11 of 14
02:28
CDS Who Trades
12 of 14
00:57
CDS Indices
13 of 14
01:10
Swaptions
14 of 14
01:12

Interest Rate Swaps

Fixed Income Markets and Derivatives | 23 videos | 1 quiz
Interest Rate Swap (IRS) Mechanics
1 of 24
04:13
Interest Rate Swap Terminology
2 of 24
02:47
Cash Flow Timeline
3 of 24
03:02
Forward Looking RFR Term Rates
4 of 24
02:23
IRS or OIS (Overnight Index Swap)
5 of 24
01:37
OIS Mechanics
6 of 24
03:30
OIS Mechanics Example
7 of 24
03:40
Interest Rate Risk in IRS
8 of 24
02:12
Mark-to-Market (MTM) Valuation of IRS
9 of 24
03:27
Interest Rate Sensitivity of IRS
10 of 24
04:08
Application 1 Hedging Floating-Rate Debt
11 of 24
03:47
Application 2 New Issue Swaps
12 of 24
03:27
Application 2 New Issue Swaps Workout
13 of 24
02:01
Application 3 Trading the Curve
14 of 24
05:28
Swap Spreads
15 of 24
04:44
What Drives Swap Spreads
16 of 24
05:32
What Drives Swap Spreads Workout
17 of 24
02:42
Basis Swaps
18 of 24
03:00
EURIBOR 3s6s Tenor Basis
19 of 24
03:04
Tenor Basis Swap Applications
20 of 24
04:03
Swap Execution
21 of 24
03:05
The Shift to Central Clearing for Swaps
22 of 24
01:33
How Swap Clearing Reduces Risk
23 of 24
03:36
Interest Rate Swaps Tryout
24 of 24

Collateral Management

Capital Markets | 12 videos | 1 quiz
Collateral Management Fundamentals
1 of 13
03:27
Pros and Cons of Holding Collateral
2 of 13
02:53
Types of Collateral
3 of 13
01:42
Types of Collateral Workout
4 of 13
01:49
Documentation
5 of 13
03:22
Documentation Workout
6 of 13
01:57
Credit Risk
7 of 13
03:20
Credit Risk Workout
8 of 13
02:58
Centralized Clearing
9 of 13
03:15
Centralized Clearing Workout
10 of 13
02:49
Clearing House Margin Calls
11 of 13
01:05
Clearing House Margin Calls Workout
12 of 13
04:05
Collateral Management Tryout
13 of 13

Convertible Bonds

Capital Markets | 20 videos
Convertibles Introduction
1 of 20
04:00
IFRS - Liability or Equity Classification
2 of 20
03:04
IFRS - Simple Split Between Bond and Option Component - Option Treated as Equity
3 of 20
02:14
IFRS - Simple Convertible Bond Accounting - Equity Treatment for Option Workout
4 of 20
02:25
IFRS - Conversion of Bond Assuming Option Converts into a Variable Number of Shares
5 of 20
04:08
IFRS - Conversion of Bond Assuming Option Converts into a Fixed Number of Shares
6 of 20
04:11
IFRS - SCBA - Equity Treatment for Option with Transaction Costs - Workout
7 of 20
04:51
IFRS - Reasons the Option May Fail Equity Treatment
8 of 20
01:44
IFRS - Convertible Bonds Where the Option is Treated as a Financial Liability
9 of 20
02:06
IFRS - Convertible Bond With Transaction Costs - Liability Treatment for Option Workout
10 of 20
05:05
IFRS - Complexities and Other Issues
11 of 20
01:37
US GAAP - Accounting Overview
12 of 20
04:22
US GAAP - Derivative Separation Accounting
13 of 20
02:59
US GAAP - Derivative Separation - Issuance
14 of 20
02:42
US GAAP - Derivative Separation - Issuance Workout
15 of 20
05:27
US GAAP - Derivative Separation - Conversion
16 of 20
02:11
US GAAP - Cash Conversion Option Accounting
17 of 20
01:19
US GAAP - Cash Conversion Option - Issuance
18 of 20
02:01
US GAAP - Cash Conversion Option - Conversion
19 of 20
03:50
US GAAP - Cash Conversion Option - Conversion Workout
20 of 20
06:00