Ch 5: Shared Workbooks in Excel

About This Chapter

The Shared Workbooks in Excel chapter of this Intermediate Excel Training: Help & Tutorials course is the simplest way to master creating and using shared workbooks in Excel spreadsheets. This chapter uses simple and fun videos that are about five minutes long, plus lesson quizzes and a chapter exam to ensure you learn the essentials of using shared workbooks in Excel.

Who's It For?

Anyone who needs help learning or mastering shared workbooks in Excel material will benefit from the lessons in this chapter. There is no faster or easier way to learn how to use shared workbooks in Excel. Among those who would benefit are:

  • Students who have fallen behind in understanding shared workbooks in Excel
  • Students who struggle with learning disabilities or learning differences, including autism and ADHD
  • Students who prefer multiple ways of learning Excel (visual or auditory)
  • Students who have missed class time and need to catch up
  • Students who need an efficient way to learn about Excel shared workbooks
  • Students who struggle to understand their teachers
  • Students who attend schools without extra Excel learning resources

How It Works:

  • Find videos in our course that cover what you need to learn or review.
  • Press play and watch the video lesson.
  • Refer to the video transcripts to reinforce your learning.
  • Test your understanding of each lesson with short quizzes.
  • Verify you're ready by completing the Shared Workbooks in Excel chapter exam.

Why It Works:

  • Study Efficiently: Skip what you know, review what you don't.
  • Retain What You Learn: Engaging animations and real-life examples make topics easy to grasp.
  • Be Ready on Test Day: Use the Shared Workbooks Excel chapter exam to be prepared.
  • Get Extra Support: Ask our subject-matter experts any Excel question. They're here to help!
  • Study With Flexibility: Watch videos on any web-ready device.

Students Will Review:

This chapter helps students review the concepts in a shared workbooks unit of a intermediate Excel course. Topics covered include:

  • Protecting worksheets and workbooks to prevent inadvertent changes
  • Unlocking cells or ranges of cells in a protected sheet to allow editing
  • Placing workbooks on a network to allow simultaneous editing by multiple users
  • The uses and limitations of a shared workbook
  • Adding restricted features before sharing
  • Use change tracking to accept or reject changes in shared workbooks

Chapter Practice Exam
Test your knowledge of this chapter with a 30 question practice chapter exam.
Not Taken
Practice Final Exam
Test your knowledge of the entire course with a 50 question practice final exam.
Not Taken

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Other Chapters

Other chapters within the Intermediate Excel Training: Help & Tutorials course