Course overviewExcel for Beginners
Module 6 of 6
Course CompletionModule 6 of 6

Course complete

Key takeaways

  • Every formula starts with =, and cell references keep results up to date.
  • SUM, AVERAGE, MIN, MAX and IF handle most everyday calculations.
  • Relative references move when copied; dollar signs lock a reference in place.
  • Bold headers, number formats and a frozen top row make a sheet easier to read.

Your certificate is waiting

Pass the knowledge quiz to unlock your free OpenSkills Certificate of Completion.

Go to the quiz