Chapter 6 Filter data, use absolute references and paste values ・ MISSION 30

Mission 30: Month-end close: add, total and report

📋 Mission list

Keycat

Enter the additional expense of 3000 in B6, change the total (B7) to the total of B2 to B6, and paste only that value in report column D7.

Keystrokes 0/ Best example: 15

Chapter 6 ・ MISSION 30

Month-end close: add, total and report

Enter the additional expense of 3000 in B6, change the total (B7) to the total of B2 to B6, and paste only that value in report column D7.

Now
Goal

The tutorial is On. You can change this setting on the mission list page. Mission list

Shortcuts used in this mission

  1. Ctrl↓
  2. →↓
  3. →3
  4. →0
  5. →0
  6. →0
  7. →Enter
  8. →Alt=
  9. →CtrlEnter
  10. →CtrlC
  11. →→
  12. →→
  13. →CtrlAltV
  14. →V
  15. →Enter

Add an expense, update the AutoSum range, and report the value. You have completed a typical month-end workflow without a mouse.

On Mac, use ⌘ (command) instead of Ctrl (control for date, currency display, etc.).

Practise individual shortcuts or check the shortcut reference here. Shortcut drillsExcel shortcut list

Use the keys shown in this simulator. In Excel itself, ribbon letters and some shortcuts differ by language and keyboard layout.