| You are here: | About>Computing & Technology>Spreadsheets> Formulas in Excel> Excel Formulas - How to Use Excel Formulas - Excel Formulas |
![]() | Spreadsheets |
![]() Basic Excel 2007 Formula Tutorial © Ted French More Free Excel TutorialsFreeze Panes in ExcelHow to Create Data Tables and Lists in ExcelPrinting Options in Excel Excel FormulasUsing Excel Spreadsheet FormulasThis Series of Excel articles and tutorials will teach you the fundamentals of using formulas to perform basic calculations in Excel spreadsheets.
Why Use Formulas in Excel?Excel formulas are one of the most useful features of the program. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Excel does all the calculations for you.
Excel Formulas Step by Step TutorialThis step by step tutorial shows you the steps to follow to write basic formulas in Excel.
Basic Excel 2007 Formula TutorialThis step by step tutorial shows you the steps to follow to write basic formulas in Excel 2007.
Excel MathThese articles cover how to carry out basic math operations using formulas in Excel. If you want to know how to add, subtract, multiply, or divide numbers in Excel, these articles will show you how.
Using Cell References in Excel FormulasCell references describe the location of a cell in an Excel spreadsheet. These cell references can be used in formulas. Excel will calculate the answer for the formula using the data located in the referenced cell.
Show Formulas in ExcelShow formulas allows you to quickly show all the formulas in your Excel Spreadsheet. Doing so does not change your spreadsheet, just the way it is displayed. Show formulas allows you to quickly and easily check your spreadsheet for errors in your formulas."What If" Questions and Excel Formulas"What if" questions involve changing the data used in Excel formulas to give different answers. Asking "What if" questions is very useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared.Excel FunctionsFunctions in Excel and other spreadsheets are just built in formulas that have been built into the spreadsheet to make it easier to perform some of the more common operations. So if you are looking to add or multiply numbers, find the average, the highest, or lowest value in a group of numbers, there is a function to help you out.Using Labels in Excel Formulas and FunctionsUsing labels in formulas and functions in Excel is a easy way to refer to a block of data in an Excel spreadsheet. Labels refer to the data directly under or to the right of a label such as "January". Using labels in a formula or function is often easier then trying to pin point the exact cell references of your data.More Free Excel TutorialsFreeze Panes in ExcelHow to Create Data Tables and Lists in ExcelPrinting Options in Excel Related ArticlesUsing Labels in Functions and Formulas in Excel - Label...Using Labels in Excel Functions and Formulas - Summary ...Formulas and Functions in Excel - How to Use Excel Form...Basic Excel 2007 Formula - Microsoft Excel 2007 Basic F...Excel Tutorial - Free Excel Tutorial - Microsoft Excel ... |
Las Vegas on a BudgetFind a BargainHotel DealsCheap EatsFree AttractionsEntertainment for Less |
All Topics | Email Article | | | ![]() |
| Advertising Info | News & Events | Work at About | SiteMap | Reprints | Help | Our Story | Be a Guide |
| User Agreement | Ethics Policy | Patent Info. | Privacy Policy | ©2008 About, Inc., A part of The New York Times Company. All rights reserved. |



