- #Microsoft office excel 2007 tutorial for beginners how to
- #Microsoft office excel 2007 tutorial for beginners plus
No matter if you have a little or no experience with Microsoft Excel you can join this course anyways. With the help of this course you will learn, the excel 2007 interface & the ribbon, entering & editing data, the formula bar, rows, columns, cells, ranges, worksheets & workbooks, formatting data & cells, basic math calculations & formulas, saving, loading, printing sheets and more.
#Microsoft office excel 2007 tutorial for beginners how to
In this series you will learn all about how to get started with Excel, you will be able to identify the different spreadsheet components, and some other main components of Excel. University of Wisconsin-Eau Claire 105 Garfield Avenue P.O.This Microsoft Office 2007 Excel Beginners is designed to teach you the basics elements and functions of Microsoft Excel 2007. NOTE: This is an important consideration if you want your document to be able to open in Excel 97-2003.įrom the Quick Access toolbar, click Save. (Optional) To save your workbook in a format other than the default (.xlsx), from the Save as type pull-down list, select the desired format. In the File name text box, type a filename. The following steps should be used when you are saving a worksheet for the first time, when you want to save it to a new location (e.g., as a backup), or when you want to save a copy with a different name.įrom the Save in pull-down list, select the appropriate save location. Saving Your Work Saving for the First Time Įntering the Current Date and Time Automaticallyįor information on having Excel automatically insert dates and times, refer to Inserting Dates and Times. To indicate AM or PM, press + or, respectively. To enter a date, type the date in one of the following formats:, 8-14-2006, or August 14, 2006. Select the cell where you want to enter the date or time. Type the desired numbers and/or text in the cell.Įntering Dates and Times Entering a Date and Time Manually NOTE: This method is especially useful when formatting multiple cells to display text.įrom the Ribbon, select the Home command tab.įrom the Category scroll list, select Text. Press, then type numeric information.Įntering Numbers Formatted as Text: Dialog Box Select the cell you want to enter information into. Entering Numbers Formatted as Text: Apostrophe Character There are two ways to enter numbers as text. 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.
#Microsoft office excel 2007 tutorial for beginners plus
A numeric cell may contain numbers, a decimal point (.), plus (+) or minus (-) signs, and currency ($).
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
0 kommentar(er)
