Intermediate Excel Materials
Wilma M. Andrews Instructor
This page was last updated on December 8, 2010

Files for the First Session
Advertisingnp_v3.xlsx (Excel document)
Chart__Review_Ribbon_2007_2010_revised.xlsx (Excel document)
largedatabase_Fall2010.xlsx (Excel document)
Part1 reviewnp examples v3.xlsx (Excel document)
Personnel_Database_06_Fall2010.xlsx (Excel document)
PieChartActivity_v3aFall2010.xlsx (Excel document)
State Governmentnp.xls (Excel 2003 document)

Files for the Second Session
importingaccessdatabase.mdb (Access document)
IF_YEAR_COUNT_VLOOKUP.xls (Excel 2003 document)
History_New.txt (txt document)
AccessLinking_pivot table_2010.xls (Excel 2003 document)
Pivottable_studentfile_v2.xls (Excel 2003 document)
functions_date_Vlookup_2007_2010.xls (Excel 2003 document)
SimpleSolver_2_2007_2010.xls (Excel 2003 document)
IF_Sales_JW_2007_2010.xls (Excel 2003 document)
3D_macro_example_09.xls (Excel 2003 document)
Validation_Protection.xls (Excel 2003 document)
grouping exercise_v2.xls (Excel 2003 document)
Lookuptableinfo_2007_2010.xlsx (Excel 2007-10 document)