Using Functions

• The Function Wizard
• Auto Calculate
• The IF Function
• Min, Max and Average Functions

Relative and Absolute Cell References

• About Relative and Absolute Cell References
• Creating and Editing Relative and Absolute Cell References

Conditional Formatting

• Setting a Conditional Format
• Setting multiple Conditional Formats
• Editing Conditional Formats

Using Multiple Workbooks

• Sharing Workbook Data
• Entering formulas using multiple workbooks

Sorting and Filtering Data

• To Sort Data
• To Filter Data
• To customise a Sort and Filter

Naming Ranges

• To Name a Range
• Using Named Ranges in Formulas

Password Protection

• Setting a password for the Workbook
• Setting a password for the Worksheet
• Locking/Unlocking and Hiding Cell Contents