Excel Formulas

Description of Excel Formulas

Excel provides an enormous number of established formulas and assistance in auditing and calculating your data. The primary groupings are financial, logical, text, date and time, lookup and reference, math and trigonometry, statistical, engineering, cube, and file-related information.
The parts of an Excel formula :
• Using constants in Excel formulas
• Using calculation operators in Excel formulas
• The order in which Excel performs operations in formulas
• Using functions and nested functions in Excel formulas
• Using references in Excel formulas
• Using names in Excel formulas
• Using array formulas and array constants in Excel
• Delete a formula
• Avoid common errors when creating formulas