Information is displayed exactly as it is entered. When cells are formatted for text, all cell contents-letters, numerals, or alpha-numeric combinations-are treated as text. Įxcel automatically right-aligns numerical values and left-aligns text.ĭo not include spaces or alphabetical characters in a calculation cell. HINT: To enter a fraction, type 0 and press before the fraction otherwise, Excel will interpret the fraction as a date. Type the numeric information that should be in the cell.

Select the cell where you want to enter numbers. A numeric cell may contain numbers, a decimal point (.), plus (+) or minus (-) signs, and currency ($).

$data analysis tool in excel 2007$

Numeric cells can be used for calculations and functions. To force text to wrap at a specific point in a cell, press +. Select the cell where you want to enter text.

Under New Blank, double click Blank Workbook.Įxcel allows you to enter text into cells. In the top left corner of the Excel window, click File. Worksheets can contain data, charts, or both.įor more information on Excel terminology, refer to Worksheet Terms. The advantage of having multiple worksheets, or layers, is that a variety of data can be compiled, analyzed, and integrated in a single file. By default, workbooks open with three blank worksheets, although you can add or delete worksheets at any time. To open Excel 2007, from the Start menu, select All Programs » Microsoft Office » Microsoft Office Excel 2007.Īn Excel file is called a workbook.

This document introduces some of the essential concepts that will help you design effective workbooks in Excel. When used optimally, Excel saves a great deal of time performing a multitude of tasks. Microsoft Excel combines the column-row layout of traditional paper spreadsheets with powerful tools for data calculation, analysis, and formatting. This article is based on legacy software. (Archives) Microsoft Excel 2007: Getting Started with Excel

Data analysis tool in excel 2007