excel tutorial

Rbailey

Description

Introduction to Excel & Spreadsheets 1. Déjà Vu: Starting, Quitting, Opening, and Saving… Hot Keys 2. About workbooks and worksheets Workbooks: In Microsoft Excel, a workbook is the file in which you work and store your data. Because each workbook can contain many sheets, you can organize various kinds of related information in a single file. Worksheets: Use worksheets to list and analyze data. You can enter and edit data on several worksheets simultaneously and perform calculations based on data from multiple worksheets. When you create a chart, you can place the chart on the worksheet with its related data or on a separate chart sheet. Sheet tabs: The names of the sheets appear on tabs at the bottom of the workbook window. To move from sheet to sheet, click the sheet tabs. 3. Getting Started • Columns & Rows: A worksheet is divided into a grid of rows (horizontal) and columns (vertical). An excel worksheet can contain up to 65,536 rows and 256 columns. A letter is assigned to column, and a number is assigned to each row. • Cells: The intersection of each row and column is a worksheet cell, which is individually referenced by its “cell name”. For example, the cell created by the intersection of Column A and Row 1 is known as A1. Cell names are also called call addresses or cell references. • Navigating • Scroll bars • Point and click • Cursor keys (hotkeys) • TAB goes to next cell on right (SHIFT TAB=Reverse) • ENTER goes to first ...

Informations

• Publié par: Nusur
• Nombre de lectures: 16
• Langue: English

Extrait

Introduction to Excel & Spreadsheets 1. DéjàVu:Starting, Quitting, Opening, and Saving… Hot Keys 2. Aboutworkbooks and worksheets Workbooks:Microsoft Excel, a workbook is the file in which you work and store your In data. Because each workbook can contain many sheets, you can organize various kinds of related information in a single file. Worksheets:worksheets to list and analyze data. You can enter and edit data on Use several worksheets simultaneously and perform calculations based on data from multiple worksheets. When you create a chart, you can place the chart on the worksheet with its related data or on a separate chart sheet. Sheet tabs:The names of the sheets appear on tabs at the bottom of the workbook window. To move from sheet to sheet, click the sheet tabs. 3. GettingStarted ·Columns & Rows:A worksheet is divided into a grid of rows (horizontal) and columns (vertical). An excel worksheet can contain up to 65,536 rows and 256 columns. A letter is assigned to column, and a number is assigned to each row. ·Cells:The intersection of each row and column is a worksheet cell, which is individually referenced by its “cell name”. For example, the cell created by the intersection of Column A and Row 1 is known as A1. Cell names are also called call addresses or cell references.

·Navigating ·Scroll bars ·Point and click ·Cursor keys (hotkeys) ·TAB goes to next cell on right (SHIFT TAB=Reverse) ·ENTER goes to first cell in next row ·Selecting Cells and Ranges ·Click a cell to select it ·Drag to select a range of cells ·Select anentirerow by clicking on its number ·Select anentirecolumn by clicking on its letter 4.Entering Data & Labeling: ·Information:Excel lets you enter the following types of information into a worksheet cell: Numeric values,such as the numbers 22,000, $29.95, and 33% o st Text values,such as the wordsTotal,1 Quarter, and1820 WarrenAvenue o Dates and times,such as feb97, 11/19/63, or 1:00 PM o Comments to yourself or others,such asThis region leads in sales, or an o appropriate recorded sound or voice message Formulas,such as =B5*1.081 or =SUM(B3:B7) o Hyperlinksto Internet sites or other documents o Electronic artwork,such as clip art, scanned photographs, maps, and o illustrations ·Entering Numeric Values:To enter a number in a cell, select the cell, type the number, and press Enter. Selecting or highlighting a cell makes it the active cell. Then as you type the number appears simultaneously in the active cell and on the formula bar above the worksheet. The formula bar serves as an editing scratch pad. If you make a mistake entering a long cell entry, you can click within the formula bar to move the insertion point and edit the entry. You can also double click

the cell to move the insertion point within the cell for edits. To the left of the formula bar is a Cancel button, which you can click to discard an unwanted entry. To the right of the Cancel button is an Enter button, which you can click to accept a revised entry. Numeric entries are formatted to be right aligned. ·Entering Text Values:To enter text into a cell, select the cell, type the text, and press Enter. Excel recognized text values and aligns them to the left margin of each cell. If you want Excel to store as text a value such as a numeric address, date, or part number, precede the value with a single quotations mark. For example, if you enter ’55 in a cell, the number 55 will appear left aligned in the cell without a quotation mark. ·Copy, Cut, and Paste– Drag and Drop  Insert ·Clear:Select the cell and press DELETE ·AutoFill:The easiest method for entering repeating or incrementing data is to use Excel’s AutoFill feature. Begin by locating thefill handle, a tiny black square located in the lower right corner of the active cell or selected range of cells. To create a series of labels, numbers, or dates, select two or more cells (to establish a pattern) and the click the fill handle and drag it over the cells you want to fill with information. ·Spell Check: press the F7 key or select “spelling” from the “tools” menu. 5.Formulas:All formulas in Excel begin with an equal sign (=). Excel stores your formulas internally (you can see them on your formula bar), but it displays the result of each calculation in the cell that contains the formula. For example “=10+20+30”, which is a formula which adds three numbers, would display the result “60” in the cell. You can use the standard mathematical operators in a formula –addition (+), subtraction (), multiplication (*), division (/), and exponentiation(^),as well as a few specialty operators (examplesSUM, AVERAGE, PMT, etc..) Formulas can also contain worksheet “cell references” so that you can include the contents of cells in formulas and combine them in any way you choose. For example “=A1+B1=C1”. Tospecify a cell reference while you are entering a formula, you can type in the cell name (i.e. B5), highlight the cell individually using the mouse, or highlight the cell using the keyboard. ·AutoSum tool:Totals the range of cells you select. 1. Clickin the cell you want to place theSUMfunction 2. ClicktheAutoSumbutton 3. IfExcel selects the range you want to total, press Enter to complete the function. If Excel didn’t pick the range you wanted, select a new range by dragging your mouse over the range and pressing enter.

Paste Function:Allows you to insert any of a number of functions into your worksheet. 1. Clickon the cell you wish to paste the function 2. Clickon thePaste Functiontool 3. Selecta function category from the list on the left (example: Statistical) and then select a function name from the list on the right (example: AVERAGE). Press OK 4. Selectthe range you wish to work with 5. PressOK to complete the formula 6.Formatting ·Font and Font Size ·Bold, Underline, and Italics ·Alignment ·Currency ·Adjusting cell size double click: Do you see ###### in a cell? Widen the column by doubleclicking the right boarder of the column heading. ·Merge and Center ·Auto format 7.Sorting 8.Chart Wizard ·Select data range ·Select chart type ·Finish 9.View and Adjust the Sheet Layout ·Print Preview ·Page Setup (Sheet, Margins, Page, Headers & Footers) ·Page Break Preview

11. PracticalUses for Bow Teacher ·Make a Purchase Order request (or a budget) ·Make a Gradebook