Excel basics
(1) using Excel as an ordinary calculator
(2)
formula vs. value | sign convention
(3) absolute/relative address
(4) =pv( |
=fv( |
=rate( |
=pmt( |
=nper(
(5) annuity due |
count()
(6) EAR: =effect( | =rate(
(7) NPV() is actually PV()
(8) IRR()|
mutiple IRRs |
modified IRR
(9)
if() |
sort |
amortization table
(10) arithmatic vs. geometric means
(11) vlookup() |
regression(pdf) |
solver()
(12) data from web |
variance
(13) Bond: yield() |
price()
More
choose n-1 HW |
pv(growing annuity)
NPVyan() |
effectYan()
yield() vs. rate() |
duration()
number vs. text|
coded ID |
double vlookup()
M/B to values|
date()
5 values only (data validation)
pdf:
Excel cheat sheet |
(2) |
(3)
pdf:
Formula/function
pdf:
10 Formulas|
or here |
Matrix mmult|
or
fun:
random name
|
Videos
For Beginners: (9m 12s) |
(14m 46s) |
(4m 29s)
Formula and function (2m 32s) |
range (2m 34s)
vlookup() (7m 45s)
Advanced (5m 3s)|
Excel 2013 (10m 3s)
A list
Matrix mmult and inverse (5m,23s)
Efficient frontier (1m,15s)
Useful links
Excel tutorial |
Guide to Excel
formula
spread sheet
Excel training
Excel-easy dot com
Excel free training tutorial
Some images
Excel images
|
Simple macro and VBA (Visual Basic Application)
(0) pdf: "developer" is not on menu bar
(1) pdf: control-a and control-b
(2) text: showFormula (copy and paste)
(3) text: showing the last row
(4) text: Hello World!
(5) text: select a cell
(6a) text: NPVyan |
effectYan |
geomeanYan
(6b) Excel: NPYyan |
effectYan |
geomeanYan
download financial statements from Yahoo
Links for VBA
Macro tutorial
Excel VBA Example Code
Getting Started with VBA in Excel 2010
Excel VBA - Excel Macros
Anthony's VBA page
Advanced VBA examples |
pdf file
Microsoft office VBA examles
Efficient Frontier (Anthony)
|
Home