Advanced Excel Materials
Wilma M. Andrews & Robert L. Andrews Instructors
This page was last updated on September 27, 2007

Files with Sample Data
Data file for students (2006) for PivotTable exercises (Excel document)
3D Macro Example (Excel document)
Personnel Database for subtotal (Excel document)
Personnel Database & Exercises (Excel document)
Sample data list for nonprofits (Excel document)
Small Database for Pivot Tables & Analysis (Excel document)

Files for Instruction
Paste Special (Excel document)
Validation Protection (Excel document)
Analysis Methods with Excel (Excel document)
Date & Vertical Lookup Functions (Excel document)
IF, YEAR, COUNT & VLOOKUP functions (Excel document)
Finance Functions (Excel document)
Regression (Excel document)
Guide for using Solver in Excel (Excel document)
Conditional Formatting Comments (Excel document)

Webpages with Media Player instructions for analysis with Excel
Bob's Media Player Files for Mathematics (Web page)
Bob's Media Player Files for Statistics (Web page)

Articles about the Computational Accuracy of Excel
Excel97 Accuracy Issues (pdf document)
Excel2000 Accuracy Issues (pdf document)
Excel2003 Accuracy Issues for Stat Distributions (pdf document)