Computing Services
All classes are located in S300T of the Haas Computing Center unless otherwise noted. For directions to S300T click here
Excel 2007
Essential Workbook Techniques
Handout 67 pages
Practice Files 2007
2003
Videos: 
Power of Calculations
Handout 37 pages
Practice Files: 2007
2003
Videos:
Presenting Data with Charts
Handouts 39 pagesPractice Files
Videos ExcelBasics07Mod3.rm - [Video Timestamps]
Data Analysis with Functions
Handout 41 pagesPractice Files
Videos ExcelBasics07Mod4.rm - [Video Timestamps]
Pivot Tables
Handout 47 pagesPractice Files
Security and Forecasting Tools
Handouts 37 pagesPractice Files
Automation Through Macros
Handouts (27 pages)Practice
Excel 2003
Module 1: Navigate, Format, Formulas, Print
Handout: Excel Vol 1.pdf 85pgs
Practice Files: ClothingSales.xls, DataEntry.xls, Formatting.xls, Printing.xls, RegionalSales.xls
video of Aug 16, 2005 ExcelBasics - [Video Timestamps]
video of Aug 25. 2006 Excel vol.1 - [Video Timestamps]
Module 2: Work with Large Workbooks, Audit, Analysis, Charts
Handout: Excel Vol 2.pdf 103 pgs
Practice Files: LargeWorkbooks.xls, Functions.xls, ProtectingData.xls, RegionalSales.xls, ScatterCharts.xls, AuditingFormulas.xls, DataAnalysis.xls
video of Aug 16, 2005 Excelvol2
video of Nov 13, 2005 Excelvol2 - [Video Timestamps]
video of Aug 25, 2006 ExcelVol2 - [Video Timestamps]
Module 3: Pivot Tables/Charts - Analysis for Power Users
Handout: Excel Vol 3.pdf 79 pgs
Practice Files: Data_Analysis.xls
last update April 1, 2008 -ei for kv
