Spreadsheet & Database Demos

Note: You must use Mozilla Firefox to save or open files on this site

Save the files to your desktop or USB memory before you work with them.

Excel Tutorial	worksheet functions.xlsx	Employee_list.xls	Simple Spreadsheet.xlsx
ABC.xls	Sort/subtotal	Employee-List Pivot.xls	Grocery-scenarios.xls
LOAN-"What if".xls		INDEX and MATCH functions	Product-Solver.xls
Chart Basics.xls	Available Chart Types	Chart Data	Object Linking and Embedding
		Charting Memo for OLE
Data Summary & Charts Sparklines Sparklines.xlsx		Hourly Wages Complete.xls	Problem Solving-Buzz OFF	BuzzOff.xls
		PurrFect.xls
Goal Seek 1.xls			CostBenefit.xls
Temperature Pivot	Pivot Demo.xls	Pivot Demo 2.xls	CPM_Gantt
Pivot Table of Bank Accounts			Order DATABASE	Sales Database
OptimalDistributionSolver.xls			Bank24Solver.xls
CoffeeSolver.xls			CoffeeScenario.xls
SampleSalespersonReport.xls			PivotTableTutorial
ProductMix.xls Solver			ProductMix Solver Tutorial
JIT Inventory Solution			VLOOKUP.xls
Compare Two Lists.xls			Compare Two ListsSolved.xls
Compare Two Lists.Doc			Fairways
Solver for Capital Budgeting.xls			Solver for Capital Budgeting.doc		Solver for Crew Scheduling
West.xlsx		East.xlsx	Consolidating Data
Database Functions in Excel			Cost Regression with Trend.xls
Importing Data from the Internet.doc			Internet.xls
Estimating Straightline Relationships.doc			StraightLine.xlsx	StraightLine.xls
Multiple Regression.xls			Multiple Regression.xlsx
Spin buttons,Scroll Bars etc.doc			Spin Button lab.xlsx	Quarterly.xlsx
Requirements Prioritization		House Data Correlation
Pareto Analysis		Pareto Chart	HotSprings.xls		HotSprings Solved.xls
Lab 1 Overview of Excel		Material Cost Overall TZBuget Solved Text BudgetSolved Sales
Goal Seek		Lemonadegs Paymentgs
IF statement		fstatement If-1 If-2