Excel 365 in 30 Minutes – Sharing (Advanced 11 of 11)

In this Bigger Brains course, you’ll learn how to prepare Excel 365 workbooks for confident sharing by addressing accessibility and link management. You’ll explore how to run the Accessibility Checker, identify common issues, and apply fixes, including defining and using alt text. You’ll also see how to review and update a workbook to meet accessibility recommendations, ensuring your files are usable by a wider audience. Along the way, you’ll learn how to add, edit, remove, and manage hyperlinks, including creating links to email addresses. 

You’ll also learn how to protect Excel data without limiting productivity. You’ll see how to protect and unprotect worksheets, lock and unlock cells, and allow specific actions or editable ranges while safeguarding critical data. The course also explores the difference between protecting individual worksheets and protecting the structure of an entire workbook. Finally, you’ll learn how to apply file-level security options—such as read-only settings, passwords, marking a workbook as final, and restricting access—to help maintain data integrity and confidentiality when sharing Excel files with others. 

Topics covered include: 

• Running the Accessibility Checker 

• Identifying types of issues 

• Defining and using alt text 

• Addressing needed changes to a workbook 

• Adding and managing hyperlinks 

• Linking to an email address 

• Protecting a worksheet from changes 

• Protecting sheet data while allowing certain actions  

• Formatting cells as Hidden to restrict what is visible 

• Describing how protecting a workbook is different from protecting worksheets 

• Protecting the structure of a workbook using Protect Workbook 

• Locking and unlocking cells to customize worksheet protection 

• Allowing users to edit specific ranges with a password 

• Securing workbooks using file-level protection settings 

Enjoy award winning HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.