Skip to content
Back to Spreadsheet analysis
PricingLog in

Data Analytics

Relative and absolute references

Relative references move when copied, while absolute references keep a fixed cell.

4 minutes. No sign-up needed.

Chapter 6: Spreadsheet analysis9 lessons · 33 min
  1. 1Spreadsheet tables3 min
  2. 2Sorting spreadsheet data3 min
  3. 3Filtering spreadsheet data3 min
  4. 4Spreadsheet formulas3 min
  5. 5Relative and absolute references4 min
  6. 6Spreadsheet summary functions4 min
  7. 7Formula checks3 min
  8. 8Spreadsheet pivot tables4 min
  9. 9Challenge: Spreadsheet analysis6 min
Go to the chapter

This lesson is part of the Data Analytics course.

Example plan3 lessons · 11 min

Spreadsheet formulas3 min
Relative and absolute referencesSpreadsheet analysis4 min
Spreadsheet summary functionsSpreadsheet analysis4 min

An example. Your plan follows your answers, so it can start later and end sooner.

Build my plan

Start free, no account needed.