Introduction+to+Excel

=**Introduction to Excel **=

__Practical Projects and Application for Excel __
Develop a worksheet to keep track of personal/business mileage. Develop a worksheet to track sales and look at trends. Develop a personal grade book to keep track of points earned in a class. Develop a worksheet to keeping track of Fantasy Football players/contributions.

media type="youtube" key="Iu764Eef8TE" height="315" width="560" align="center"

=[|Excel 2010 -More Condiional Formating]=

=**Microsoft Excel 2010: 10 Best New Features in Microsoft Excel 2010 **=




 * Concepts **

=
__**Spreadsheet **__ is an electronic file that contains a grid of columns and rows containing related data and to display results of calculations, enabling interpretation of quantitative data for decision making. =====

__**Plan for Effective Workbook and Worksheet Design **__

 * ===== Plan before entering data =====
 * ===== State the purpose =====
 * ===== Identify input values =====
 * ===== Determine outputs =====
 * ===== Decide what data to add into columns and rows =====

Name Box–An identifier that displays the address of the cell currently used in the worksheet. Used to:

 * ===== Go to a particular cell, =====
 * ===== Assign a meaningful name to one or more cells, or =====
 * ===== Select a function =====

=
Sheet tabs–Located at the bottom-left corner of the Excel window; shows the names of the worksheets contained in the workbook. Rename a sheet by double-clicking the tab. Click a sheet tab to display the contents of a particular worksheet =====

Edit cell contents– Different ways to edit a cell

 * ===== Select **Cell**, click in the **Formula Bar** to make changes, and then click **Enter** on the left side of the Formula Bar =====
 * ===== Double-click **Cell**, make edits directly in the cell, and then press **Enter** =====
 * ===== Select **Cell**, press **F2**, make changes in the cell, and then press **Enter** =====

Clear Cell Contents– Different ways to clear a cell

 * ===== Click the cell and then press **Delete** =====
 * ===== Click the cell, click **Clear** in the Editing group on the Home tab, and then select **Clear Contents** =====

=

 * Auto Fill – ** Enables you to copy the contents of a cell or a range of cells by dragging the fill handle (a small black square appearing in the bottom-right corner of a cell) over an adjacent cell or range of cells =====

=

 * TIP **–Copying Formulas with Auto Fill. After you enter a formula in a cell, you can duplicate the formula down a column or across a row without retyping it by using Auto Fill. Excel adapts each copied formula based on the type of cell references in the original formula=====

Displaying cell formulas– Different ways to display formulas

 * ===== Quickest is to press **Ctrl** and the **grave accent (`) key**, sometimes referred to as the tilde key, in the top-left corner of the keyboard, below Esc =====
 * ===== Click **Show Formulas** in the Formula Auditing group on the Formulas tab to show and hide formulas. This is a toggle feature =====

__**Insert, Delete, Move, and Copy Worksheets **__

Number formats

 * ===== Use commands in Number group on Home tab =====
 * ===== Number Dialog Box =====

Page Setup dialog box– After selecting Page Setup options, you are ready to print your worksheet

 * ===== Specify Page Options =====
 * ===== Specify Margins Options =====
 * ===== Create Headers and Footers =====
 * ===== Select Sheet Options =====