calpoly.eduExcel ResourcesExcel Resources RESOURCES FOR EXCEL PROJECTS Compiled by Elizabeth Howell Brunner Tutorials from UniversitiesExcel introduction, in five parts, from the University of North Carolina Part One help.unc.edu/cgi-bin/getdocs?docnumber=dwe26 Part Two help.unc.edu/cgi-bin/getdocs?docnumber=dwe27 Formulas & Functions help.unc.edu/cgi-bin/getdocs?docnumber=dwe30 Charts /help.unc.edu/cgi-bin/getdocs?docnumber=dwe28 Data Management help.unc.edu/cgi-bin/getdocs?docnumber=dwe29Helpful instructions from Rollins College Recording Macros www.rollins.edu/technews/document/excel8macro.html Financial Functions www.rollins.edu/technews/document/excel8_finfu.htmlSome Excel tips for beginners from a Geology Professor in Canada www.science.ubc.ca/~geol302/excel/excel_index.htm Introductory MaterialThis online "Getting Started" guide, an excerpt from a textbook, provides a nice overview merchant.superlibrary.com:8000/products/07897/0789711656/0789711656s.html Orientation for Beginners, a simple tutorial sorrel.humboldt.edu/~tlm7001/excel.htm#mainmenu Useful Excel tips that anticipate common problems faced by students. www.computerimages.com/tip_xl.html Microsoft's official Excel site. Quality of the information varies, but worth checking. www.microsoft.com/excel/ Tips on Formatting Data cwis.bournemouth.ac.uk/service-depts/lis/oac/pcexcel/excel5spreadform.htmlFourteen practical tips from a training firm: www.engr.psu.edu/www/trg/TIPS/Tip-excl.htm http://www.csc.calpoly.edu/~ebrunner/ExcelResources.htm (1 of 3)2/3/2005 10:24:34 AMExcel Resources More Advanced ResourcesThe Spreadsheet Page, sponsored by a columnist from PC World, includes Frequently Asked Questions, software tips, links, and even a joke collection. www.j-walk.com/ss/ Follow these tips to create a Data Map with Excel: merchant.superlibrary.com:8000/products/07897/0789709554/0789709554r.html Be informed about the Excel Laroux Virus which plagues our classroom each quarter. www.pcworld.com/heres_how/article/0,1400,7506+4+0,00.html For more sophisticated users, this ZDnet article "Master Excel Spreadsheets" will help you avoid calculation errors. www.zdnet.com/products/content/pccg/1101/259421.html And for the student who probably should have challenged out of this course, try "Advanced Spreadsheet Programming" by Eric Wells: www.windows.com/exceldev/articles/movs104.htm Online CalculatorsCalculating Download Time for Web Files www-sci.lib.uci.edu/HSG/AATimeCalc.html Martindale's Online Calculator Center www-sci.lib.uci.edu/HSG/RefCalculators.html Home Decorating Calculations www.todayshomeowner.com/calculators/ Cost of Living Comparisons between Cities www2.homefair.com/calc/salcalc.html Comparison of Renting and Buying www2.homefair.com/usr/rentbuyform.html Cost of a Baby from Birth to College www.babycenter.com/costofbaby/ ClickCalcs: What will it take to be a millionaire? www.financenter.com/savings.htm Professional Exampleshttp://www.csc.calpoly.edu/~ebrunner/ExcelResources.htm (2 of 3)2/3/2005 10:24:34 AMExcel ResourcesThis Australian company is trying to sell football spreadsheets. Don't even think of plagiarizing in this way, but feel free to get some layout ideas from the web site. www.rtwd.com.au/football/index.html Example of spreadsheet that calculates corporate vehicle and mileage costs. www.cablenet.co.uk/~rfds/excel/index.html Remember to Accurately Label All Charts and Use Complex Formulas for the Highest Grade Example of Excellent Student Excel Project Excel Shopping Spree ExerciseSuggestions for Excel Data Sets Excel Pictographs & Other Examples Created by Elizabeth Brunner Designed with Netscape Composer Gold Bead Tile from Pat's Graphics Updated on May 10, 1999 http://www.csc.calpoly.edu/~ebrunner/ExcelResources.htm (3 of 3)2/3/2005 10:24:34