No. of Recommendations: 89
Foolish Collective Spreadsheet Project Archive

Here is the final project archive of the spreadsheet project. The purpose of this project is to teach a novice how to create and use a spreadsheet. These lessons are meant to be applied to the field of investment and financial analysis.

I'd like to thank everyone who contributed to this project. They are 1971simon, confusedfool100, eeii, gebinr, GrandpaRalph, haywool, HGBG, KennyO, Lostinthought, lynbee, obenation, Olya, PosFCF, Rijer, sean1arch, and Zarff.

Week #1: Cells, Rows, Columns, Sheets & Referencing

Week #2: Functions
Math Functions

Financial Functions

Statistical Functions

Boolean logic & nested functions

Lookup/Reference/Database Functions

Week #3: Formatting, Posting to boards/web

Week #4: Charts & Graphs

Week #5: Macros

Week #6: Web Querries & linking spreadsheets

Part 1: File structure conventions and file naming conventions

Part 2: A simple “canned” web query – downloading a set of stock quotes

Part 3a: Making your own web query – Downloading 4 quarters of Income Statement data with Excel 2000

Part 3b: Making your own web query – Downloading 4 quarters of Income Statement data with Excel 2002

Part 4: Editing the query to make it generic

Part 5: Combining several queries and computations to make a “stock” spreadsheet

Part 6: Setting up a “Master” spreadsheet and linking the first and subsequent “stock” spreadsheets to the “master” spreadsheet

Part 7: Tips, Tricks, and Things that go Bump! in the Night.

Web Querries for Excel '97:

Sample Template

Week #7: Debugging & troubleshooting
Common errors and debugging

Data Manipulation (sorting, filtering, importing data):

Week #8: Data sources that provide Excel downloads and Sample spreadsheets

Tips & Tricks -
Shortcut keys

Find & Replace, Splitting Windows, Freezing Panes, Comments, Names in a workbook

Spreadsheet Advice board:

Print the post  


What was Your Dumbest Investment?
Share it with us -- and learn from others' stories of flubs.
When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Community Home
Speak Your Mind, Start Your Blog, Rate Your Stocks

Community Team Fools - who are those TMF's?
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.