Excel Basics

Dear Finance students,

I am sure that you would be preparing well for your ensuing end term examinations and looking forward for your Christmas vacation. You will have about 10 days leave and I thought it is an ideal period for you to spend some time to learn Ms Excel.

You will all agree that good working knowledge in Excel is one of the most important pre-requisites for corporate especially in the finance profile. While we are incorporating few portions of Excel in your main course curriculum, I feel you should spend some time to harness your skill there.

I find that excel can be self-learnt in your own pace and convenience. I find excellent YouTube videos particularly Excelisfun channel as one of the best help available to learn Excel.

We feel you should be comfortable in Excel in the following functions.

• Basic

• Keyboard navigations

• Relative, mixed and absolute cell referencing

• Various types of charts.

I am giving the following web links from “Excelisfun” channel which cover the above topics. They are given below:

Link Topic covered.

1. http://www.youtube.com/watch?v=XmSp2-Fa4rg excel basics

2. http://www.youtube.com/watch?v=jDogLgKTRf8 - keyboard shortcuts.

3. http://www.youtube.com/watch?v=_ABHR3R-Zbk Formulas and cell references.

4. http://www.youtube.com/watch?v=yGPx94pSOP0 Mixed and absolute reference.

5. http://www.youtube.com/watch?v=YlAVvCZUyYg –mixed cell references and budgeted income statements.

6. http://www.youtube.com/watch?v=XT3AvZU2VXk Sum and count

7. http://www.youtube.com/watch?v=JonS_YuFeMQ sumif and countif functions.

8. http://www.youtube.com/watch?v=9KbhiSeMYKE - comparative charts

9. http://www.youtube.com/watch?v=uE0txDHYZUo percentage change charts.

10. http://www.youtube.com/watch?v=LRge01sFy7Y - column,pie charts.

You