Excel Tutorial Index
This page will soon have a growing list of tutorials for using Excel. Please check back soon.
I have posted the following tutorials:
- Microsoft Excel as a Financial Calculator. It covers the basics of using the FV, PV, Rate, NPer, and PMT functions just like you would otherwise use on your financial calculator.
- How to Create a Loan Amortization Schedule. It also shows how to use conditional formatting.
- Bond Valuation. This covers the methodology of valuing bonds on, and between, coupon payment dates.
- Calculating Bond Yields. This covers the calculation of the current yield, yield to maturity, and yield to call both on and between coupon payment dates.
Also, I have quite a bit of Excel related material available on my academic Web site. Specifically, you might check:
- My financial modeling course Web page - Scroll to the bottom for Excel files that are available.
- My Excel Stuff Web page - This page has a bunch of spreadsheets that I have put together that I think are useful to a broader audience.
I'm building this Web site as quickly as I can, and I hope that you will find it to be a very useful resource. If you have any requests for content please feel free to send me an email.
15 Most Recent Posts in my Excel Blog
- Go directly to the blog front page
- Coin Tosses and Stock Price Charts
- Modifying the Ribbon in Excel 2007
- Analyze Google AdSense Data Using Pivot Tables
- Testing a String for Proper Case
- Charting Economic Time Series with Shaded Recessions
- Native Excel 2007 Viewer Now Available
- Disallow Special Characters Using Data Validation
- Chart the Yield Curve Using Yahoo! Finance Data
- Display Scenarios Using a Drop-Down List
- Adding an Average Line to a Chart Using Defined Names
- Dealing With Unusual Date Formats
- Parallel Install of Office 2007 and Office 2003
- Video: Using Controls to Change Chart Data
- Google Spreadsheets and Google Finance
- Loan Amortization Tutorial Added
