Microsoft Office Tutorials and References
In Depth Information
Enter Formulas Using a Variety of Methods . . . . . . . . . . . 24
Name Cells and Ranges . . . . . . . . . . . . . . . . . . . . . . . . . . . 26
Define a Constant . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
Create Formulas That Include Names . . . . . . . . . . . . . . . . 30
Calculate with the Function Wizard . . . . . . . . . . . . . . . . . 32
Figure Out Loan Terms. . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
Determine the Internal Rate of Return . . . . . . . . . . . . . . . 36
Determine the Nth Largest Value . . . . . . . . . . . . . . . . . . . 38
Create a Conditional Formula . . . . . . . . . . . . . . . . . . . . . . 40
Calculate a Conditional Sum . . . . . . . . . . . . . . . . . . . . . . . 42
Add a Calculator. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
Find Products and Square Roots . . . . . . . . . . . . . . . . . . . . 46
Perform Time Calculations. . . . . . . . . . . . . . . . . . . . . . . . . 48
Perform Date Calculations . . . . . . . . . . . . . . . . . . . . . . . . . 50
Search JabSto ::




Custom Search