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
Microsoft Excel is primarily used to create spreadsheets that are split up into rows and columns. Highligh… More
Microsoft Excel can be used to calculate home budgets, to create formulas, to make tables and to form char… More
Use provided formulas in Excel by selecting the drop down menu from the toolbar next to the auto sound fun… More
Making a table in Excel is as easy as highlighting data, going to the "Insert" tab and clicking on "Table.… More
Microsoft Excel is a computer spreadsheet program that is practical for keeping track of monthly expenses.… More
That college paper needs to get finished, but you don't have a computer with Microsft Excel installed. Bei… More
You can use Excel to track information for accounts. If you are running a small business and only need to … More
To use Microsoft Excel's graphing program, create a list of data, highlight the data, click on "Insert," a… More
Having a calendar in Excel can be a great tool to have on hand, especially at the office. You can use it t… More
Many people use Excel as a database. Excel can be a convenient way to store information as a database as l… More
Spreadsheets are worksheets created on paper or a computer application that has gridlines, making numbers … More
Excel macros are a special feature in Microsoft Excel that allow you to perform common tasks automatically… More
Rename an Excel worksheet by either clicking on the name part of the file and retyping a new name or by ri… 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!"
eHow Article: How to Use Provided Excel Formulas
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.
