6. Using Formulas and Functions

In this section:

• Understand Formulas and Cell References in Excel

• Create and Edit Formulas

• Create, Edit, and Delete Named Ranges

• Use Named Ranges in Formulas

• Summarize the Values in Groups of Cells

• Create Formulas that Reference Cells in Other Workbooks

• Sum with Subtotals and Grand Totals

• Explore the Excel Function Library

• Create Conditional Functions

• Debug Your Formulas