1 of 25
PREFACE TO EXCEL TUTORIAL
Excel is essential when analyzing finance cases. Most students have taken a course that
covers the basics of Excel, including accessing the program, adding and subtracting,
copying, and the like.
Although some students
are quite proficient, most need help
when dealing advanced features, and this Tutorial provides that help. Procedurally, we
developed a series of cases on financial management, wrote models to analyze them,
tested the cases and models in our classes, and identified the Excel features that caused
students trouble. We then wrote this tutorial to help clarify the trouble spots.
We recommend that you skim through the tutorial, get an idea of what it covers,
and then use it as a reference as you go through the cases. The models provide
references to the Tutorial at the point where advanced Excel features are used.
example, all of the case models use Data Table to do sensitivity analysis.
If you are not
familiar with Data Tables, when you first encounter them in a model go to the tutorial
for instructions on how to make and use them.
Many Excel features are used repeatedly
in the cases, so taking the time to learn them in the early cases will make the later cases
Excel is useful for things other than working finance cases, so what you learn
about Excel will benefit you in other courses and in the real world after you graduate.
Indeed, recruiters tell us that students who are proficient with Excel have a definite
advantage in the job market, and our former students tell us that having Excel skills is a
big help in moving up the ladder.
So, learning more about Excel is well worth the
If students need more help than the Tutorial provides, we recommend Mayes and Shank,
Analysis With Microsoft Excel,
(South Western, 2003).