Here are a few readings about spreadsheets and financial modeling that you should do.
Course Reader: please read the Burton G. Malkiel Chapter from “A Random Walk Down Wall Street”
In addition, please also read:
A quick primer on spreadsheet given to me my first day on the job at Babcock & Brown. Called simply, Spreadsheet Rules.txt.
Stanford – Best Practices for Spreadsheeting has at least a few very good ideas in it: http://library.stanford.edu/research/data-management-services/case-studies/case-study-spreadsheets
1b. Number Formats
“1. Excel Custom Number Formats.docx” Source: http://www.ozgrid.com/Excel/excel-custom-number-formats.htm
Another good article on this subject is: http://peltiertech.com/Excel/NumberFormats.html
The New Zealand Treasury prepared this a brief example of how to calculate a NPV.
To the extent that you feel that you need some brushing up in basics, I would recommend watching parts of the Lynda.com Essential Training course, which can be found at:
At a minimum, it would be a good idea to make sure you understand the basics of formatting numbers, cells, columns, and rows. To that end, you may want to watch the following movies in Section 4:
- Exploring font styles and effects
- Adjusting row heights and column widths
- Working with alignment and Wrap Text
- Exploring numeric and special formatting
- Formatting numbers and dates