Main Profile

At A Glance

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
Length: 10:13


Questions about Excel Basics #4: Formulas and Functions

Want more info about Excel Basics #4: Formulas and Functions? Get free advice from education experts and Noodle community members.

  • Answer