Excel Forum
Similar Content
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.