{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Tutorial_Brigham Buzzard(1)

# Excel Tutorial_Brigham Buzzard(1) - PREFACE TO EXCEL...

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

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).

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

View Full Document
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 2/76 Drawing Toolbar 2/77 Formula Bar 2/78 Dialog Boxes 2/82 Formatting 2/87
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern