computer-applications-for-finance---lectures
Computer Applications in Finance
Lecture 2 : Excel Functions Download
Lecture 3: Formatting Text Download
Lecture 4: Formatting Text 2 Download
Importing Text PSX data | Emails
Lecture 5 : Ratio Analysis Download
Lecture 6 : Time Val. of money Download
Lecture 7 : TVM Annuity Download
Lecture 8 : Capital Budgeting
Loan Amortization Lecture | Excercise 2
Lecture 9 : Time Value of Money Lecture | Exercises
Lecture 9 : Time value of Money II Lecture
Lecture 10 : IF, Nested IF Download
Lecture 11 : Income Tax with IF Excercise
Lecture 12: Revision for mid-term Download
Lecture 13 : Cell Protection Read
Lecture 14: Conditional Formatting 1 Download
Lecture 15: Conditional Formatting 2 Read
Lecture 16 : Depreciation Lecture
Lecture 17: If Function Exercise
Lecture 18: Vlookup Function Part 1 | Part 2 | Part 3 | YouTube Video
Lecture 19 Graphs and Charts Exercise
Lecture 20 : Ratio Analysis Download
Lecture 21 Pivot Tables Exercise
Lecture 22 : Macros The Three points | Video 1 | Video 2 | Video 3 | Day1 Files
Lecture 23 : Macros Day 2 | YouTube Video
Lecture 24: Macros Visual Basic First Example
Lecture 25: Macros Cheque Printing | YouTube Video
Lecture 26 Macros SD YouTube Video | List of Macros for Final Exam
Lecture 27 : Solver Function for Capital Budgeting [Study Material ] [Coffee Shop Example.xls ]
[CapBudget File.xls, Text link ]
Lecture 28: Find cost of equity with Excel Solver | Excel File | YouTube Video
[Bank Scheduling.xls, Text link ]
Lecture 25: Panel Data Analysis [State 9] [Panel data slides ] [panel data example ] [ Panel Data
Set+Guidlines+Prctical Application Download ]
Lecture 26: Bonds and Stock Valuation
Lecture 1: Excel Environment Download