Excel Tutorial_Brigham Buzzard(1)

Excel - PREFACE TO EXCEL TUTORIAL Excel is essential when analyzing finance cases Most students have taken a course that covers the basics of Excel

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Tab 0 1 of 25 6/12/04 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. 1 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. For 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 easier. 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 effort! 1 If students need more help than the Tutorial provides, we recommend Mayes and Shank, Financial Analysis With Microsoft Excel, (South Western, 2003).
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Tab 1. Contents 2 of 25 6/12/04 1. TUTORIAL CONTENTS 6/12/04 This Tutorial provides some information that is useful in working with the case models. Excel is a very complete and complex program, and we do not come even close to covering all of its features. For a more complete treatment, we refer you to Timothy R. Mayes and Todd M. Shank, Financial Analysis With Microsoft Excel, 3rd Edition, South-Western, 2004. Click on the tabs in the lower section of the screen to access the various sections of the Tutorial, which are outlined below. If you cannot see all 7 of the tabs as shown on the picture on Row 13 below, then either (1) use the arrow keys to the left on the Tab Menu to scroll or (2) put the pointer on the vertical line to the right of the last tab, hold down the left clicker, and drag to extend the Tab Row. Scroll bar adjuster Tab/Row 0. Tutorial 1. Contents 1/1 2. General Information Workbooks, Worksheets, Rows, Cells, Ranges, Etc. 2/6 Help Feature 2/37 Copy, Paste, Paste Special 2/46 Absolute and Relative Copy Commands 2/57 Main Menu, Tool Bars, and Related Items: 2/59 Title Bar 2/73 Main Menu 2/74 Formatting Toolbar 2/75 Standard Toolbar
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/07/2010 for the course FIN 3162N taught by Professor Spencer during the Spring '10 term at Dowling.

Page1 / 25

Excel - PREFACE TO EXCEL TUTORIAL Excel is essential when analyzing finance cases Most students have taken a course that covers the basics of Excel

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online