FINA4920-IntroToExcel - Click to edit Master subtitle style...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Click to edit Master subtitle style 6/6/11 Intro to Excel and Spreadsheet FINA 4920 Computers in Finance 6/6/11 Finance and Excel  Finance is all about numbers  Microsoft Excel is a very useful program to organize, analyze and present numbers and data for both one- of-a-kind problems and ongoing problems Capability to run “what-if” analyses and scenario analyses allows us to make better decisions  Setting up the problems in spreadsheets can help us gain a deeper understanding of the problems  Excel is used very widely in financial decision- 6/6/11 Excel – Basics  Excel is a program that allows us to store, organize and analyze quantitative data With excel, we can forecast, manage, predict, and present information  When you open a new excel operation, it creates a workbook  Each workbook has three spreadsheets by default Denoted by the tabs at the bottom left-hand corner of the excel screen 6/6/11 Excel – Basics  Spreadsheets are made up of Columns – identified with alphabetic headings Each column in a range represents a field Rows – identified with numeric headings Each row in a range represents a record Cells – the intersection of rows and columns  In each cell, there may be the following types of data 6/6/11 Excel – Basics 6/6/11 Excel – Basics 6/6/11 Excel – Basics  Navigating within worksheets To navigate within a workbook, you use the arrow keys, PageUp, PageDown, or the Ctrl key in combination with the arrow keys to make larger movements. The most direct means of navigation is with your mouse. Scroll bars are provided and work as they do in all Windows applications. 6/6/11 Excel – Basics  Navigating between worksheets To move to other Worksheets, you can: Click their tab with the mouse Use the Ctrl key with the Page Up and Page Down keys to move sequentially up or down through the worksheets 6/6/11 Excel – Basics  Identifying cell ranges A group of worksheet cells is known as a cell range, or range. Working with ranges in a worksheet makes working with the data easier. Ranges can be adjacent or nonadjacent. An adjacent range is a single, rectangular block of cells Select an adjacent range by clicking on a cell and dragging to an opposite corner of a rectangle of cells A nonadjacent range is comprised of two or more adjacent ranges that are not contiguous to each other To select a nonadjacent range, begin by selecting an adjacent range, 6/6/11 Excel – Basics  Selecting and moving worksheet cells...
View Full Document

This note was uploaded on 06/06/2011 for the course STAT 4290 taught by Professor Lazar during the Spring '11 term at University of Georgia Athens.

Page1 / 68

FINA4920-IntroToExcel - Click to edit Master subtitle style...

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

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