Excel Forum
Similar Content
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Understanding Formulas and Functions in Excel
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...
Manually Calculate Formulas and Functions in Excel
Tutorial: How to force Excel to recalculate all formulas and functions without editing or entering ...

Excel Basics #4: Formulas and Functions

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#4 Video topics:
1)Formulas with cell references
2)Formula efficiency rule: Numbers that can change go in cells and numbers that do not change can be typed into cells
3)Formulas with cell references operators and parenthesis
4)Formula for Effective Annual Interest Rate
5)How to find Excel functions to use in formulas
6)Search for Excel functions
7)EFFECT function
8)Formula for month interest rate
9)Formula for total number of periods
10)Formula for monthly payment on a loan using the PMT function
11)Formula for text string that use cell references, Text in quotes and the DOLLAR function

Got a Question? Ask it Here in the Forum.