Excel 365 in 30 Minutes – Workbook Properties & Views (Intermediate 2 of 8) 

In this Bigger Brains course, you’ll learn how to work with grouped worksheets so you can edit multiple sheets at once, and you’ll see how to ungroup them when you need to work individually. You’ll explore how to view and update workbook properties, add built-in details like Titles and Tags, and create custom workbook properties to keep your files organized and easier to find. You’ll also learn navigation tools such as Freeze Panes to keep headers visible and the Split command to view distinct parts of a worksheet simultaneously

You’ll see how to manage and compare several workbooks with features that make multitasking easier. You’ll explore options for arranging windows, viewing workbooks side by side with synchronous scrolling, and switching quickly between open files. You’ll also learn how to open multiple instances of the same workbook using the New Window feature—ideal for reviewing different sections or comparing data. Designed for users already comfortable with Excel basics, this course helps you work smarter, faster, and more confidently across all your workbooks. 

Topics covered include: 

• Grouping worksheets  

• Making changes to grouped worksheets  

• Ungrouping worksheets 

• Viewing Workbook Properties  

• Populating built-in Workbook Properties like Titles or Tags  

• Create a Custom Workbook Property 

• Using Freeze Panes to keep header rows or initial columns visible  

• Using the Split command to create multiple view windows within one worksheet 

• Using Arrange Windows options to see multiple workbooks at a time  

• Viewing multiple workbooks side by side and turn on or off Synchronous Scrolling  

• Switching between open workbooks using Switch Windows  

• Opening multiple instances of the same workbook using New Window    

Enjoy award-winning HD content in the “Uniquely Engaging”™ 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.