Excel learning

  Home   Teaching  Finance  Programming  FinTech  Data  Links

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)
  • 10 Formulas |
  • Matrix Operation using Microsoft Excel
  • 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

  • Guide to Excel
  • formulas and functions
  • computer expert
  • Excel training
  • Excel-easy dot com
  • Excel free training tutorial

    • Excel Cheat Sheets

  • Cheat sheets
  • Excel Cheat sheet (basic skills, pdf)
  • dataQuest: Excel Cheat sheet
  • Excel Cheat sheet

    • Simple Macro and VBA

  • (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

  • Getting started with VBA
  • Macro tutorial
  • VBA Code Examples
  • Getting Started with VBA in Excel 2010
  • Anthony's VBA page
  • Advanced VBA examples (PDF) or here
  • Efficient Frontier (Anthony)

    • Contact information: paulyxy@gmail.com