in the early days of the personal computer, there wasn't too much that
these machines could do. That changed with the first "killer
app," a spreadsheet program intended to harness the computer's power and work
with numbers called Lotus 123. Suddenly,
calculations that were tedious, difficult, even impossible to do became
effortless - almost. Many of these operations and processes within
Microsoft Excel were pioneered by Lotus. These include the use of
FUNCTIONS and FORMULAS and how to build and utilize them.
Your Portfolio Theory class uses Microsoft Excel, and introduces many of
the program's formulas and functions. These are a couple of the tools that
create the nearly effortless "number-crunching".
"Almost" effortless, because if you do not know what is
available within the program, and how to use them, there results much
annoyance, and difficulty with Excel. Of note: NO one knows every
the course, you will become a proficient user of functions and formulas.
Additionally, you may have many questions. Many of the answers will be
found below. This information is in a finance context only. Also check the
"Quik fx" Guide
for other possible answers. But, please be advised, this website is a
"work in progress." As a result, if you find a problem, error, or solution
...please email the webmaster.