Supplemental Websites for this Chapter
Information to Supplement this Chapter from the Authors
Other Websites Pertinent to this Chapter
Websites from this Chapter in the Text
Websites Referred to in the Text of this Chapter
Chapter References for this Chapter that Are Online
Onsite Information to Supplement the Text
For Use with Applications and Competencies
Goal Seek (Chapter 25)
Offsite Websites That Are Pertinent to This Chapter
- Charts
- Designing Spreadsheets
- Printing
- Statistics (Chapter 25)
- Statistics Templates for Excel (Chapter 25)
- Tutorials
Charts
Charting with Excel. Great help!
http://peltiertech.com/Excel/Charts/index.html
Problems With Using Microsoft
Excel for Statistics. The author, Jonathan D. Cryer, maintains that most of the charts offered in Excel should never be used because they distort data.
http://www.stat.uiowa.edu/~jcryer/JSMTalk2001.pdf
Using charts to present data.
http://www.strategiccomm.com/usecharts.html
Using data and statistics. Great description of line, pie, and bar graphs with description of what they are best used for.
http://www.mathleague.com/help/data/data.htm
Designing Spreadsheets
Planning
Designing and Developing Good Spreadsheet Models. Organized under two categories, Characteristics of Good Models and Designing and Building Good Models.
http://www.rwc.uc.edu/cheatham/gen_class_notes_ss_designing_good_models.htm
Making it look good
Excel Design Tips - Make Your Excel Spreadsheets Look Good
http://www.cogniview.com/convert-pdf-to-excel/post/excel-design/
Printing
How to avoid spreadsheet printing errors. (Note in 2007, to access this click on the Page Layout tab and then Page Setup Group, Print Area)
http://www.post-gazette.com/interact/20000615radin.asp
Tutorials
This tutorial is excellent, covers the basics, plus formatting cells, formulas, functions, and graphs. Recommended. Although for Excel 2000, will work for XP (2002) as well.
http://www.fgcu.edu/support/office2000/excel/
2007 version is at http://www.fgcu.edu/support/office2007/Excel/index.asp
Excel 2003 help.
This tutorial is excellent, covers the basics, plus formatting cells, formulas, functions, and graphs. Recommended. Although for Excel 2000, will work for XP (2002) as well.
http://office.microsoft.com/en-us/excel/FX100646961033.aspx
Excel 2003 from Rutgers State University of New Jersey
http://getit.rutgers.edu/tutorials/excel/media/excel.pdf
Excel 2007. A great site that is free through the first two chapters. Great way to start. Includes pdf files to download and print,videos for each segment, and sample files for experimenting.
http://www.learnmicrosoftexcel.com/free_tutorials/free_tutorials_with_video.htm?gclid=CPbo_4n-2poCFRINDQod5jcm2Q
Excel 2007 tutorials designed to make you think by giving you a task to perform and pointing you to the article(s) in the Excel Help System.
http://www.vertex42.com/Excel2007/excel-tutorial.htm
Excel 2007 for all charts in Microsoft Office (added June 24, 2010)
http://office.microsoft.com/en-us/excel-help/overview-of-charting-HP001216348.aspx
Websites Referred to in Text of Chapter
Order of math functions in formulas (holds true for any computer formula). http://regentsprep.org/Regents/math/math-topic.cfm?TopicCode=orderop
References in this Chapter that are Online
Centers for Disease Control and Prevention. (2007, May 22). About BMI for adults. Retrieved November 22, 2008, from http://www.cdc.gov/nccdphp/dnpa/bmi/adult_BMI/about_adult_BMI.htm
Google. (2007). Getting to know Google Docs: Size limits Google Docs & Spreadsheets Help Center. Retrieved November 22, 2008, from http://docs.google.com/support/bin/answer.py?answer=37603
Mattessich, R. (n.d.). Spreadsheet: Its First Computerization (1961-1964). Retrieved November 22, 2008, from http://www.j-walk.com/ss/history/spreadsh.htm
Created June 1, 2009