Summary and Exercise- Copy and Paste

Please purchase the course before starting the lesson.

Summary

By now you should be able to:

  • Create, Save, Open and Close Excel files;
  • Discern the effect of file extensions when naming your spreadsheets;
  • Navigate in a spreadsheet using various tools;

Exercise

1. As per Excel example (Copy and Paste) do the plain copy and paste exercise;
2. As per Excel example (Copy and Paste) do the paste formulas exercise;
3. As per Excel example (Copy and Paste) do the paste formats exercise;
4. As per Excel example (Copy and Paste) do the paste values exercise;
5. Paste special: Formulas and number formats;
6. Paste special: All except borders and column width; and
7. Paste special: Transpose

To see the full course contents click here.

Back to: Beginner Excel Course > Basic workings of an Excel spreadsheet