Learning outcomes
- Explain how to control data entry and collaborate without conflicting copies.
- Complete the guided practice safely.
- Check that you can keep one trusted cloud version with valid entries.
Microsoft Excel
Excel Validation and Collaboration
Learn to control data entry and collaborate without conflicting copies and keep one trusted cloud version with valid entries in this beginner-friendly Microsoft 365 lesson.
Before you begin
Open Excel and create a blank practice workbook. Use sample information rather than confidential business data.
Step-by-step instructions
- Open Excel and a blank practice workbook and confirm you are using the intended account.
- Add a drop-down list, share the workbook and add a comment.
- Pause and check permissions, filenames, recipients, dates or settings that affect the task.
- Test the result: keep one trusted cloud version with valid entries.
- Save the workbook to OneDrive and check that formulas, formatting and labels still display correctly.
Ian's practical tip: Use sample information first. Once the workflow is correct, repeat it with approved work information and the minimum necessary access.
Practical activity
Add a drop-down list, share the workbook and add a comment. Your expected result is to keep one trusted cloud version with valid entries.