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.