Excel Formulas 

Excel Formulas Additional ResourcesExcel Formulas 
Entering FormulasA formula is a special type of cell entry that returns a result: When you enter a formula into a cell, the cell displays the result of the formula. The Excel formulas itself appears in the formula bar (which is just below the toolbars at the top of the Excel window) when the cell is activated.Excel formulas begins with an equal sign (=) and can consist of any of the following elements:
You can enter Excel formulas into a cell in three ways: manually (typing it in), by pointing to cell references, or with the assistance of the formula palette. Entering Excel Formulas ManuallyEntering Excel formulas manually is not as hard as it sounds.To enter a formula manually, follow these steps:
As you type, the characters appear in the cell as well as in the formula bar. You can use all the normal editing keys (Delete, Backspace, direction keys, and so on) when entering a formula. Entering Excel Formulas By PointingThe pointing method of entering a formula still involves some manual typing.The advantage is that you don't have to type the cell or range references. Rather, you point to them in the worksheet, which is usually more accurate and less tedious. The best way to explain this procedure is with an example. To enter the formula =A1/A2 into cell A3 by pointing method, just follow these steps:

Excel XP Topics Tips Excel Screen Layout  Navigational Techniques  Working with Workbooks  Templates  Working with Worksheets  Moving Around  Move Worksheets  Copy Worksheets  Insert & Delete Cells  Insert & Delete Rows  Insert & Delete Columns  Resize Row  Resize Column  Editing Data  Content Color  Cell Color  Number Formats  Fonts  Alignment  Text Direction  Indent Contents  Merge Cells  Copy  Move  Undo & Redo  Using Zoom  Freeze & Unfreeze Titles  Split Worksheet  Spreadsheet Data  AutoFill  AutoComplete  Comment  Find  Replace  Spellcheck  Formulas  Functions  Password  Sorting  AutoFilter  Advanced Filter  Macros  Charts  Charting  Charting Elements  Gantt Chart  PivotTable  PivotTable Calculations  PivotTable Layout  PivotTable Format  PDF to Excel  PDFtoExcel Converter  Excel to PDF Converter 