These Excel exercises can be reviewed as Adobe
Acrobat Version 4-format documents and -- in some cases -- also online.
To view an Acrobat-format file in your browser you'll need a copy
of the free Adobe Acrobat Reader. If you don't already have a copy
of the Reader, get one from Adobe's
download site. Click an Acrobat file link to view it. You can print
the file from within the view. If you want to save the file directly
to your hard drive without viewing it first, right-click the link
and choose the pop-up menu command that appears and reads "'Save
Link As", "Save Target As", or something similar.
Excel Proficiency Exercises
Adobe format, ~130K
to the Excel Proficiency Exercises,
format, ~ 512K
Five exercises that cover some key Excel features
including relative, fixed, and mixed addressing; IF statements; SUMPRODUCT
and MIN functions; Data Table; Goal Seek; and the XY plot. For help
with the exercises and notes on the concepts, see the "Guide"
and the Excel "Solutions" files.
Online & Adobe Acrobat formats
Click the link above for practice with basic Excel
modeling skills, the use of some specialized Excel functions, and the
Excel Solver add-in in the context of a resource optimization problem.
The Oak Products exercise is drawn from Prentice-Hall's "Introductory
Management Science" by Eppen, Gould, Schmidt, Moore, and Weatherford.
Adobe format, ~185K
Svelte Glove is a product mix problem that takes
you step-by-step through building a worksheet to determine what mix
of products yields the highest profit. A set of production constraints
complicates the model. You first build the model to allows a manual
determination of the product mix, then apply Excel's Solver to automate
the process. The Adobe Acrobat format file is about 185K in size.
Adobe format, ~113K
The Padgett's Widgets problem is similar to the
Oak Products and Svelte Glove problems above. For the Padgett's Widgets
model you calculate profit as a function of four price levels and identify
the optimum price with the help of a chart. You then expand and refine
the model and the chart to allow for forty prices. Although worksheet
screen shots are provided, no step-by-step help is given. The Adobe
Acrobat file is about 113K in size.
to Data Tables/Data Table Exercises
Adobe format, ~296K
Excel's Data Tables are useful for sensitivity analysis,
or observing how changes to one or more variables in a model affect other
values. This introduction to Data Tables uses the Xertech
Exercise.xls worksheet (22k) as the basis for describing how to construct
both One-Variable and Two-Variable Data Tables, and generate scenarios
and graphs from the results.