Excel Basics

Topics: Learning, Spreadsheet, Reference Pages: 2 (343 words) Published: May 20, 2013
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....
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Week 6 Excel Essay
  • penn foster microsoft excel Essay
  • Excel Quiz Research Paper
  • Excel Assignment 1 Essay
  • Essay about Matlab vs Excel
  • Excel Exercise Essay
  • The Basics for Writing Undergraduate History Essays and Papers
  • Excel Solver for Linear Programming Essay

Become a StudyMode Member

Sign Up - It's Free