Computer Applications in 
 
 
Finance

                                      




Lecture Notes and Files


 Lecture 1: Excel Environment   Download
 Lecture 2 : Excel Functions    Download
 Lecture 3: Formatting Text   Download
 Lecture 4: Formatting Text 2   Download
 Lecture 4b Importing Text   PSX data | Emails
 Lecture 5 : Ratio Analysis Download
 Lecture 6 : Time Val. of money Download
 Lecture 7 : TVM Annuity Download 
 Lecture 8 : Loan Amortization Lecture | Excercise  2
 Lecture 9 : Time value of Money II  Lecture  | Exercises
 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 
 Lecture 18: Vlookup Function YouTube Video
 Lecture 19 Graphs and Charts Exercise
 Lecture 20 Pivot Tables Exercise
 Lecture 22 : MacrosThe 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 | Video
 Lecture 26 Macros SD YouTube Video
 Lecture 27 : Solver FunctionStudyMaterial | Example.xls 
 Lecture 28 : Solver Function CapBudget File.xls
 Lecture 28: Find cost of equity with Excel Solver Excel File | YouTube Video | Bank Scheduling
 Lecture 29: Panel Data Analysis
Notes: Download  Class Log file Download







Ĉ
Attaullah Shah,
Feb 14, 2018, 12:09 AM
Ĉ
Attaullah Shah,
Feb 22, 2018, 12:29 AM
Ĉ
Attaullah Shah,
Sep 19, 2013, 8:13 AM
Ĉ
Beta.xlsx
(11k)
Attaullah Shah,
Nov 8, 2013, 6:38 AM
Ĉ
Attaullah Shah,
Apr 29, 2018, 10:22 PM
Ĉ
Attaullah Shah,
Mar 14, 2018, 1:36 AM
Ĉ
Attaullah Shah,
Apr 11, 2018, 11:13 AM
Ĉ
Attaullah Shah,
Apr 24, 2018, 12:00 AM
Ĉ
Attaullah Shah,
Apr 23, 2018, 11:55 PM
Ĉ
Attaullah Shah,
Sep 27, 2013, 8:07 AM
Ĉ
Attaullah Shah,
May 9, 2018, 11:52 PM
Ĉ
Attaullah Shah,
Sep 20, 2013, 8:11 AM
ĉ
Attaullah Shah,
Feb 28, 2018, 11:05 PM
ć
Attaullah Shah,
Sep 19, 2013, 8:12 AM
ċ
Attaullah Shah,
Feb 27, 2018, 1:28 AM
ċ
Attaullah Shah,
Feb 11, 2016, 5:52 AM
Ĉ
Attaullah Shah,
Mar 17, 2016, 5:23 AM
Ĉ
Attaullah Shah,
May 14, 2018, 11:25 PM
Ĉ
Attaullah Shah,
Apr 4, 2015, 1:15 AM
Ĉ
Attaullah Shah,
Apr 8, 2018, 11:49 PM
Comments