Skip to main content

Library Workshops

Excel Intermediate - Learning Objective #1

Excel Intermediate - Learning Objective #1:

Using basic keyboard shortcuts:

Skills and concepts covered:

  • Copy, Paste, Cut
  • Find, Select All
  • Insert Date
  • Formula Shortcuts

Activities:

  • Copy names from data worksheet by using ctrl c → paste using ctrl v into ClientDept worksheet → Try it with ctrl x (cut)

  • On the OrderForm worksheet, press ctrl F to open the find and replace pop-up → enter 83702 in search box → in the corresponding adjacent status column, enter “received” and the date use ctrl ; to enter today’s date.

  • Use crtl z to undo any actions that you performed.

Telephone416-864-5059 Email icon hslibrary@smh.ca           Twitter icon   Health Sciences Library Blog                Health Sciences Library Feedback