[ Software | Quantitative Skills | Qualitative Skills | Vocabulary & Concepts | Site Map ]

Excel Video Series for Activity VIII, Problem 1      These videos were designed for high speed access. They may work with a 56K modem; however, there will be delays as the videos buffer. If you need help viewing or listening to the videos, or downloading the free plug-ins, Click Plug-ins and Video Tips. Click your browser's Back button to return to this page. Each video runs less than ten minutes. Here is a link to the Activities Problems Download Page. Scroll down the list of links to Activity VIII: Problems. (The file includes all Activity VIII problems. This Excel Video Series corresponds to Problem 1.) Click the Back button to return to this page. Playing the Videos We recommend playing the videos in the order listed. They begin with basic steps, and then show you how to use more advanced steps as the series progresses. Basic Setup: This video shows a basic method to create the table of Revenues, Costs, Profits, and so on. The method is adequate for doing the homework; however, it is not the best method. The next video presents an improved method. We suggest you review the basic setup first. Improved Setup: This video shows a better way to create the table of Revenues, Costs, Profits, and so on, introduced in the Basic Setup video. This method puts constants in their own cells, and therefore allows for easy change of values (e.g., changing the price per unit to $180 instead of the given $170). Marginals: This video shows how to calculate the Marginal Cost and Marginal Revenue at 1000 and 2300 units sold. The video also shows how to, by hand, discover what the break-even value for units sold is. Goal Seek: This video continues the lesson started in the Marginals video, and shows how to use Goal Seek to more easily find the break-even value. Revenue & Cost Graph: This video shows how to produce a scatter plot (using lines) to show a graph of Revenue and Cost vs. Units Sold. This is a quick and basic introduction to Excel's Chart Wizard. Revenue & Cost Format: This video shows simple formatting of elements of a graph (either by using the right-mouse click method or using the Excel Format toolbar method). Revenue & Cost Drawing: This video sows how to use the Drawing Toolbar to add an arrow and a textbox to point out the break-even point on the graph. Profit Graph: This video shows how to produce a chart of the Profit vs. Units Sold, along with formatting and drawing ideas. The main idea is the use of Ctrl-mouse click to select data that is not in adjoining columns. Average Cost Graph: This video addresses Average Cost showing material similar to in the Profit Graph. Visual BASIC: This video shows how to produce a Visual BASIC module of two functions called Revenue and Cost that are new, user-defined functions. This video provides a quick introduction to using Visual BASIC in Excel; it sows how the use of user-defined functions can hide some of the messiness of a calculation. Questions, Comments, and Concerns Your questions, comments, and concerns are important. Please review them with your instructors. If you feel an S3C helpline would be beneficial, please email the Site Coordinator.

[ Home | Help | Programs | Professors/Instructors | What's New on S³C? | Video Library ]

[ Software | Quantitative Skills | Qualitative Skills | Vocabulary & Concepts | Site Map ]

Last Updated June 12, 2003 by prp. Email comments to Site Coordinator. Privacy Statement and Site Evaluation © 2000 - 2003 University of St. Thomas and Thomas H. Ressler, Ph.D. All Rights Reserved.