Functions and Formula Microsoft Excel Tutorials
You use formulas in your Excel worksheets to calculate results from the data stored in the worksheet. When data changes, those formulas calculate updated results with no extra effort on your part. Excel provides a number of different ways to build formulas, letting you craft them by hand or point-and-click them into existence. Here, you'll learn about all of these techniques.
Report
Using Ranges names for formulas
Range names are extremely useful not only for documenting the function of the formulas in your worksheet, but also for finding and selecting cell ranges quickly and easily.
Operators in Formulas
An operators is the basic element of a formula. An operator is a symbol that represents an operation.
LEFT Function
To find out the details of using this function read the article on the Excel 2007 LEFT Function.
Show formulas
Ever want to see which formulas are being used in an excel documents? Well, now you can.
Multiply
Multiplication is essential in Excel. Luckily it is extremely easy. To multiply numbers or cells in Excel, we must use a basic formula. All Formulas in Excel begin with =
VLOOKUP function
VLOOKUP in excel stands for vertical lookup. This simple function is extremely useful if you have large lists of data. With this function, you can easily search through a list of data and match specific criteria.
Random Numbers
The many capabilities of Excel include generating random numbers for use in your spreadsheets. One way to accomplish this is with the RAND function.
Working with Lookup Functions
In this tutorial, you get a chance to practice creating formulas that automate table lookup, including looking up a single value....
Date and Time Formulas
Formulas that perform calculations between elapsed dates and times are quite common in spreadsheets. In this tutorial give you a chance to build formulas that calculate the difference between starting.
Counting and Summing Worksheet Cells
A summing formula returns the sum of the values of the cells in a range that meet certain criteria. The range you want counted or summed may or may not consist of a worksheet database.
Function Argument Types
In this tutorial, you will notice that all the functions use a set of parentheses.
Excel Formula Shortcuts
You have learned how to build a formula by entering it manually. That's a good way to start out because it forces you to understand the basics of formula writing.
Errors in Formulas
It's not uncommon to enter a formula only to find that the formula returns an error. In this tutorial types of error values that may appear in a cell that has a formula.
Calculating Formulas
You have probably noticed that the formulas in your worksheet get calculated immediately. If you change any cells that the formula uses, the formula displays a new result with no effort on your part.
How To Use The Product Function
A video quickskill designed to show how to use the product function in excel
Excel 2007 COUNTIF
To find out the details of using this function read the article on the Excel 2007 COUNTIF function.
Excel 2007 RIGHT Function
Another Excel function, similar to the LEFT function, which can be used to remove unwanted characters from imported data, is the RIGHT function.
Adobe Fireworks
Adobe Flash
Adobe Illustrator
Adobe Image Ready
Adobe Photoshop
3D Studio Max
Cinema 4D
Maya 3D
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
Microsoft Access
MySQL
C and C++ 
Python
Visual Basic
.htaccess
Adobe DreamWeaver
ASP
CGI & Perl
CSS
Java
JavaScript
Microsoft FrontPage
Windows Vista
Windows 7