FINA4920-IntroToExcel

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

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

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

View Full Document

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

View Full Document

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

View Full Document

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

View Full Document

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

View Full Document
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 &#2; Finance is all about numbers &#2; 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 &#2; Setting up the problems in spreadsheets can help us gain a deeper understanding of the problems &#2; Excel is used very widely in financial decision- 6/6/11 Excel – Basics &#2; Excel is a program that allows us to store, organize and analyze quantitative data With excel, we can forecast, manage, predict, and present information &#2; When you open a new excel operation, it creates a workbook &#2; 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 &#2; 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 &#2; 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 &#2; 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 &#2; 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 &#2; 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 &#2; 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
Ask a homework question - tutors are online