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.