Excel Forum
Similar Content
Change Formulas to Absolute or Relative References
Macro: This macro will change the formulas in cells to absolute or relative. It allows you to cha...
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can...
Enter a Constant Value in a Defined Name in Excel - Text, Numbers, Formulas, Etc.
Tutorial: In Excel you can store values in Defined Names.  Often people use a Defined Name to refe...
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




Office 2010 Class #21: Excel Formulas & Functions: Formula Inputs Numbers or Cell References?


Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. Equal Sign
2. Use Cell References for formula Inputs any time a number can change (like payroll data or an interest rate)
3. Numbers that can be typed into a formula (numbers that do not change)
4. Three ways to enter a formula (Mouse, Arrows, Typing)
5. Ampersand = Join Symbol (Shift + 7)
6. Calculating Formula
7. Text Formula
8. Search For Function using Insert Function dialog box
9. EFFECT and PMT finance functions
10. Format Cells Dialog Box
11. Currency Number formatting
12. General Number formatting
13. DOLLAR function for Text Formulas (applies Currency Formatting to number in text formulas)
14. Number Formatting is a façade that sits on the surface of the spreadsheet: the actual item (like a number) in the cell can be different than what you see on the surface of the spreadsheet.





Got a Question? Ask it Here in the Forum.