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)