Все публикации

=SUMIF explained0:00:22

=SUMIF explained

=COUNTIF explained0:00:22

=COUNTIF explained

Vector autoregression: forecasting0:18:23

Vector autoregression: forecasting and trading applications (Excel)

=ABS explained0:00:16

=ABS explained

Covariance matrix shrinkage:0:16:35

Covariance matrix shrinkage: Ledoit and Wolf (2004)

=ACCRINT explained0:00:23

=ACCRINT explained

Gradient descent in0:10:35

Gradient descent in Excel

=ACOS explained0:00:20

=ACOS explained

Credit risk in0:23:38

Credit risk in Basel III: Risk-weighted assets explained (Excel)

Adjust the columns0:00:26

Adjust the columns fast!

Replace explained0:00:16

Replace explained

=VLOOKUP explained0:00:27

=VLOOKUP explained

Flash Fill overview0:00:15

Flash Fill overview

= CONCATENATE explained0:00:25

= CONCATENATE explained

=IF explained0:00:35

=IF explained

=ROW explained0:00:33

=ROW explained

Paste + Transpose0:00:23

Paste + Transpose tables

Easy sums0:00:20

Easy sums

Adjust the columns0:00:14

Adjust the columns fast!

Get rid of0:00:21

Get rid of blank rows fast!

Instrumental variable regression:0:36:22

Instrumental variable regression: TSLS explained (Excel)

ARCD model explained:0:13:02

ARCD model explained: autoregressive conditional density (Excel)

PEG ratio explained:0:10:06

PEG ratio explained: price to earnings growth (Excel)

Sensitivity and scenario0:12:48

Sensitivity and scenario analysis in investment appraisal (Excel)