Skip to content
Skillreps

Lesson 5 of 8

Relative and absolute references, named ranges

Video by Kevin Stratvert

Sign in to save your place, your notes and your practice.

Speed

This lesson’s steps

  1. Watch the step+10 XP

    Watch to the end. Slow it down or loop the tricky part as often as you need.

  2. Try it yourself+25 XP

    Add a column that shows each expense as a share of the total, using $ to lock the reference to the total cell.

Quick check

1 question · +15 XP

Recalling what you just watched is one of the best ways to remember it. No timer.

Sign in to write notes that stay with this lesson.