2nd Session

The material is here.

Sorry to keep you guys waiting today. Got held up in a rather unfortunate incident - seems my involement is jinxed this year! The injury is minor, but it being on the left wrist prevents me from driving for a while. But am not sure it would be a good idea to keep you guys in limbo. Would talk to your course coordinator in case they have a 'back-up'. Else, if it's ok with your insti, we could do it in your next term.

Sorry again, in case I left you high and dry. Well, the least I can do is leave you with the video :)

For those who were interested in 'learning' (as against just meeting the grade), I have some partial material ready for the course outline I shared with you and will keep posting it on this blog once a week or so - roughly with the same frequency as our classes would have been.

Good luck to you all!

Today's Class [10/10/09]

I have taken ill overnight with what seems like a viral. So, sorry guys, there won't be a class today. I don't have the class rep's number and I am not able to reach the course co-ordinator on phone. So in the unlikely case any of you has this site open, could you please pass this on to the class.

Excel Tips: I

1. Locating Microsoft Office Excel 2003 commands in v. 2007: Here or here

2. Excel keyboard shortcuts (applies to 2003) - but afaik all 2003 keyboard shortcuts work in 2007 too...something you may wanna try.

1st Session: Course Introduction & some Useful Excel Functions

Here is what we are going to discuss tomorrow:

1. About the course

2. Course evaluation

3. Introduction to - or revision of, as the case may be - some advanced Excel functions and procedures useful for financial applications. In no particular order, we'll cover:

a) Accessing mathematical / statistical functions
b) Using keyboard short-cuts etc
c) Look-up functions
d) Absolute vs Relative Referencing
e) Array functions
f) Data Tables etc.

4. Introduction to VBA - time permitting.

I hope your course coordinator has been able to arrange the book by now. If not, I would suggest you push for it.

Update: Material for the 1st Session is here.