1 / 5

GMBA Excel Workshop Spring 2007

GMBA Excel Workshop Spring 2007. Billy Mee. GMBA Excel Workshops – Spring 2007. Develop spreadsheets to be used as analysis tools. Covered Summarizing Data, Loan Amortization, and Pivot Tables. Develop spreadsheets that are powerful, flexible and well organized.

bridie
Download Presentation

GMBA Excel Workshop Spring 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GMBA Excel WorkshopSpring 2007 Billy Mee

  2. GMBA Excel Workshops – Spring 2007 • Develop spreadsheets to be used as analysis tools. • Covered Summarizing Data, Loan Amortization, and Pivot Tables. • Develop spreadsheets that are powerful, flexible and well organized. • Consider using Excel to analyze financial situations. • Use functions • Build the formulas manually.

  3. Excel as an Analysis Tool • Excel helps an analyst take the vast array of data, organize it, analyze it and present it to an audience. • Goal is to design powerful, flexible, well organized spreadsheets. • Use good basic spreadsheet techniques: • Always use cell references, not data values, in calculations. • Separate data variables from analysis. • Place variable data at top and analysis below. • Use formatting to highlight and organize data.

  4. Excel as an Analysis Tool • Cell references in functions and calculations change relative to the direction they are copied • Cell references can be one of the following types: • Relative – C15 • Absolute – $C$3 • Mixed – D$47 • Excel processes calculations using the rules of Algebra • Keep your formulas simple

  5. Excel as an Analysis Tool • Building a Financial Tool Kit: • NPV • Evaluating returns: ROI • Amortize a loan • Calculating future value (FV) • Use one workbook to hold many worksheets.

More Related