COMMERCE 3QA3 Chapter Notes - Chapter 1: Expected Utility Hypothesis, Fixed Cost, European Route E18
4 Jun 2018
School
Department
Course
Professor
Lectures 1-4 – Ch 1 Notes (Introduction, App B, Excel tutorial) page 1
Lectures 1-4 – Introduction, Ch 1, App B, Excel Tutorial – 3qa3.xlsm
Excel
For PC’s: Excel 2010, 2013 or 2106 can be used. The textbook uses Excel 2010 on a PC. For Mac’s: Use
Excel 2011 or 2016 (that’s standard). With respect to the material in this course, all these versions of Excel
(for PC’s and Mac’s) are very similar.
Design of an Excel Worksheet
An Excel file is called a ‘workbook’. An Excel workbook is comprised of several Excel ‘worksheets’. Each
worksheet is designed as follows.
Name of workbook click to access help
Tabs
Excel Tutorial <click here to go to the podcast>
There is an Excel tutorial file called ‘Excel Tutorial - 3qa3.xlsm’ in Avenue > Content > Excel tutorial,
software. It is comprised of Excel information and Practice Exercises.
Download this file and save it on your computer.
Save a copy of the file with a different name, say ‘Excel Tutorial - 3qa3 - copy 1.xlsm’, and work with the
copy. Then if you make a mistake in the Practice Exercises, you can always retrieve the original file.
Ribbon
Cell reference
Row header
Click to access Formula bar
Excel functions Column header
Vertical scoll bar
Horizontal scroll bar Zoom
Tab showing worksheet name
Click here to insert a new worksheet
Click ‘Enable’
Click ‘List of Topics’
Lectures 1-4 – Ch 1 Notes (Introduction, App B, Excel tutorial) page 2
You MUST work through the information and
Practice Exercises in these five sections (Basics,
Formulas, Charts, Functions, Data) of the
tutorial. You MUST do this on your own during
the first few weeks of the course. You MUST do
as much of this as possible.
YOU WILL BE TESTED ON THIS AT QUIZ #1.
This material is general and you have probably
already seen some of it. The goal is to become
familiar with the material, to learn it generally,
not to memorize it.
When we use this material later in the course
for specific problems (models, linear
programming, simulation, waiting lines) you will
have to learn the material more carefully.
You usually don’t memorize things in Excel
because Excel has lots of help features.
Lectures 1-4 – Ch 1 Notes (Introduction, App B, Excel tutorial) page 3
Optional Excel (video) tutorials
Optional Excel tutorials are available on Youtube. There are versions for PC’s and versions for Mac’s. If
you can find them my favourites are:
(optional) Tutorial for PC users: Excel 2013 Essential Training with Dennis Taylor.
On Youtube search for ‘Excel 2013, Dennis Taylor’. The video should be 6 hours long. I have also seen
this called Microsoft Excel 2013 Tutorial for Beginners (1), (2), (3), (4) with Dennis Taylor. Note that
there are four tutorials (1), (2), (3), (4); and they take a total of about 6 hours. <click here>
(optional) Tutorial for Mac users: Excel for Mac 2011 Essential Training with Curt Frye
Learning Excel podcasts are also available on Lynda.com, which is a learning platform freely available to
McMaster Commerce students. <click here to go to the McMaster link to Lynda.com>
or <click here to go directly to Lynda.com >
Business Decision Models <click here to go to the podcast>
We develop a mathematical model of a real business decision problem. We analyze the model to
develop insights into the business problem and then find a solution for the business problem.
Steps: 1. Define the business problem – What are the parameters/input variables (known and unknown
or certain and uncertain), decision variables, and results/output variables?
2. Develop a mathematical model in Excel – What are the mathematical relationships
between the variables?
3. Acquire input data
4. Develop the solution – Determine the best values of the decision variables
5. Analyze the results using sensitivity analysis – Change the values of the input variables
6. Implement the results
Document Summary
Lectures 1-4 introduction, ch 1, app b, excel tutorial 3qa3. xlsm. Fo(cid:396) pc(cid:859)s: e(cid:454)(cid:272)el (cid:1006)(cid:1004)(cid:1005)(cid:1004), 2013 or 2106 can be used. The textbook uses excel 2010 on a pc. With respect to the material in this course, all these versions of excel (cid:894)fo(cid:396) pc(cid:859)s a(cid:374)d ma(cid:272)(cid:859)s) are very similar. A(cid:374) e(cid:454)(cid:272)el (cid:449)o(cid:396)k(cid:271)ook is comprised of several excel (cid:858)worksheets(cid:859). Excel tutorial There is an e(cid:454)(cid:272)el tuto(cid:396)ial file (cid:272)alled (cid:858)excel tutorial - (cid:1007)(cid:395)a(cid:1007). (cid:454)ls(cid:373)(cid:859) i(cid:374) a(cid:448)e(cid:374)ue > co(cid:374)te(cid:374)t > excel tutorial, software. It is comprised of excel information and practice exercises. Download this file and save it on your computer. Sa(cid:448)e a (cid:272)op(cid:455) of the file (cid:449)ith a diffe(cid:396)e(cid:374)t (cid:374)a(cid:373)e, sa(cid:455) (cid:858)excel tutorial - 3qa3 - (cid:272)op(cid:455) (cid:1005). (cid:454)ls(cid:373)(cid:859), and work with the copy. Then if you make a mistake in the practice exercises, you can always retrieve the original file. Lectures 1-4 ch 1 notes (introduction, app b, excel tutorial) page 1.
