# GSB622 Excel Tutorials

Here are four of the tutorials used in the GSB622 online class. They are useful
in learning Excel including some advanced features such as Scenarios (what
if) and Linear Programming (Solver).

If you have technical difficulty loading the material, My email is jmiller@dom.edu and
my cell phone number is 847-530-0550. -- Jim Miller

## Section 1 - Introduction

Introduction
to Excel -- This is a tutorial that is used in
the online version of GSB622. It introduces many features of Excel including
copying formulas, relative and absolute addressing, and charts. It uses a
specific problem as an example. This problem is part of a homework assignment
in the online course but it still serves as a great example whether or not
you need it for homework. **This is a long video (45mb, 22 minutes).
Please be very patient while it is loading 45 megabytes of data. **

Use
of the Excel payment function -- This is a very good tutorial by Dr. Margaret
Kozak on use of the PMT function in Excel. It is shorter than the first tutorial
(7.5 minutes, 8mb). This lecture refers to a homework problem that is assigned
in the online version of gsb622 but the example is useful whether or not you
have homework to do.

## Section 2 - Scenarios (what if)

Using
Excel Scenarios -- The Scenario feature in Excel is very useful for "What
if" analysis. The attached document in
PDF or Word format supports this 13 minute (24 mb) tutorial.

Lecture 2 on Scenarios has been omitted because it was very specific to the
gsb622online homework assignment and does not add any new information about
using Excel.

## Section 3 -- Solver (optimization, linear programming)

Using
Solver in Excel -- This tutorial shows how to install the Solver add-in
and then use it to maximize profit given a series of facts and constraints.
It uses a specific example from gsb622online homework. This tutorial will
be replaced with a more generic example in late September. However, this
tutorial is useable until then. The tutorial runs for 12 minutes and loads
23 megabytes of data.

##