
Featured Tutorial
Featured Macro
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
#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