Chapter 20. Calculating and Manipulating Data

IN THIS CHAPTER

• About Spreadsheet Calculations

• Formula Basics

• Entering Formulas Manually

• Using the Function AutoPilot

• Using Cell References

• Updating Calculations

• Sorting Data

• Filtering Data

• Conditional Formatting

• Controlling Content and Formatting When Pasting Data

• Combining Cells

• Combining Sheets and Linking to Other Spreadsheets

• Using Form Controls to Enter Values

• Tips for Using Spreadsheets

• Troubleshooting Spreadsheets