eHow launches Android app: Get the best of eHow on the go.
How to Record an Excel Macro
How to Add 2 Cells in Excel
How to Sum a Column or Row of Excel Cells
How to Insert a Row or Column in an Excel Spreadsheet
How to Sort a Row or Column in Excel
How to Create a Bar Graph From an Excel Spreadsheet
How to Use Provided Excel Formulas
How to Use Subtotals & Totals in an Excel Spreadsheet
How to Decide When to Use Worksheets & Workbooks in Excel
How to Add or Delete an Excel Worksheet
How to Rename an Excel Worksheet
How to Format Cell Numbers in Excel
How to Align Text in Excel Cells
How to Add a Background Color or Pattern to Excel Cells
How to Protect Excel Cells From Modification
How to Format Rows & Columns in Excel
How to Add Headers & Footers to Excel Documents
How to Add a Custom Menu to an Excel Toolbar
How to Define Cell Names in Excel
How to Define Cell Ranges in Excel
How to Use Cell Ranges in Excel Formulas
How to Use the AutoFill Function in Excel
How to Use the Freeze Pane Command in Excel to Create Static Headings
How to Save an Excel Worksheet as HTML
How to Create a Spreadsheet Template in Excel
How to Make a Circle Graph With Excel
How to Create a Message Box in Excel VBA
Excel formulas are used to perform calculations, identify trends and consolidate numbers from disparate so… More
In order to make a formula in Excel, type in an equal sign and go to the "FX" button in order to select "S… More
Creating an Excel formula in Microsoft Office is a great way to perform mathematical calculations based on… More
Creating a formula in Excel 2003 is a great way to perform mathematical calculations and basic math using … More
Microsoft Excel is a powerful tool for analyzing data. The Forecast function provides users with a way of … More
A per diem is the expenses needed to live per day. Business uses the per diem rate to determine the amount… More
Spreadsheet software offers very useful tools for both business and home applications where users are able… More
How to use Budget Formulas in this free series of personal finance video from our professional Certified P… More
There are two functions to use when calculating APR in Microsoft Excel. Use "PMT" and "Rate" functions in … More
VLookup is an Excel formula that allows a range of cells to be searched through vertically, as opposed to … More
After inserting data into Microsoft Excel, put the cursor into the desired cell and find the VARP function… More
Get totals and subtotals in an Excel spreadsheet by using the auto sum function on the toolbar menu and sp… More
Microsoft Excel formulas can be used to take the sum or average of a set of data by typing an equal sign i… More
Use provided formulas in Excel by selecting the drop down menu from the toolbar next to the auto sound fun… More
Excel users can show formulas by clicking on a cell, which makes the formula appear in a text window. Lear… More
Summary: Use provided formulas in Excel by selecting the drop down menu from the toolbar next to the auto sound function. Use formulas in Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Amar Enhsaihan is an assistant certified public accountant (CPA) and works with Excel applications everyday on his job.read more
"Hi, I'm Amar Enhsaihan, and I'm going to show you how to use formulas in Excel. So, if you go to the tool bar menu, you see that right next to the auto sound function, there's a drop down menu. If you click on that, you'll see that some simple formulas are given and there's more functions. For now we'll just use one of the simple ones. Let's say if we'll use sum, let's say if you click on that one it sums this range highlighted. But, we don't want to sum this range, so we'll highlight this portion of the formula, and then select the range that we want to sum, click enter, and here we have a sum of this range. That was a very simple example, now I'm going to show you something more complicated. I'm going to show you another formula, provided by Excel. I'm going to go to drop down menu, on the tool bar menu, see click, what I'm averaging. Click enter and that's the average. That's how you use Excel provided formulas, I'm Amar Enhsaihan, thank you for watching!"
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use † and Privacy Policy †. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License. † requires javascript
