Microsoft Office Tutorials and References
In Depth Information
3. Working with Formulas and Functions
3. Working with Formulas and Functions
What You’ll Do
Understand Formulas
Create and Edit Formulas
Understand Cell Referencing
Use Absolute Cell References
Use Mixed and 3-D Cell References
Name Cells and Ranges
Enter and Manage Names
Simplify a Formula with Ranges
Display Calculations with the Status Bar
Calculate Totals with AutoSum
Perform One Time Calculations
Convert Formulas and Values
Correct Calculation Errors
Correct Formulas
Audit a Worksheet
Locate Circular References
Perform Calculations Using Functions
Create Functions and Nested Functions
Calculate Multiple Results
Use Constants and Functions in Names
Search JabSto ::

Custom Search