Library Workshops

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.