Formulas in Microsoft Excel

Formulas in excel are a very important feature. They are used to calculate values based on what is in cells, perform operations on a cell content, fetch values based on your search criteria and much more. As a matter of fact, learning excel formulas is very critical for the successful use of spreadsheet software. Excel formulas let you do so much more once you master them.

This site gives easy to understand help for 50 of most frequently used excel formulas. Click on the below sections or formulas to get started.

Mathematical Functions Text Functions Logical & Reference Functions Date & Time Functions Financial Functions Information Functions
Average Formula
Int Formula
Mod Formula
Rand Formula
Round Formula
Sum Formula
Concatenate Formula
Find Formula
Left Formula
Len Formula
Lower Formula
Mid Formula
Proper Formula
Rept Formula
Substitute Formula
Trim Formula
Upper Formula
Value Formula
And Formula
Countblank Formula
Countif Formula
If Formula
Large Formula
Max Formula
Min Formula
Not Formula
Or Formula
Small Formula
Sumif Formula
Vlookup Formula
Day Formula
Hour Formula
Minute Formula
Month Formula
Networkdays Formula
Now Formula
Second Formula
Today Formula
Weekday Formula
Year Formula
Fv Formula
Ipmt Formula
Npv Formula
Pmt Formula
Ppmt Formula
Column Formula
Isblank Formula
Iserror Formula
Isnumber Formula
Istext Formula
Row Formula

Microsoft Excel Formula Training - Ebook