Mastering how to organize and view your Excel workbooks efficiently can transform your productivity and clarity. The new Bigger Brains course, Excel 365 in 30 Minutes – Workbook Properties & Views (Intermediate 2 of 8), offers a practical and insightful guide to help learners take control of their workbooks through powerful grouping and viewing techniques. You will learn how to group worksheets to make simultaneous changes across multiple sheets, streamlining repetitive tasks and ensuring consistency. The course also teaches you how to ungroup worksheets when you need to work on individual sheets, giving you flexibility and precision. Managing workbook properties becomes straightforward as you explore how to view built-in properties like Titles and Tags, and even create custom workbook properties that add meaningful metadata to your files.
Beyond organization, the course enhances your ability to navigate and view your data with confidence. You will master Freeze Panes to keep header rows or initial columns visible as you scroll, ensuring critical information stays in sight. Using the Split command, you create multiple view windows within a single worksheet, allowing you to compare different sections of your data side by side without losing context. The course introduces Arrange Windows options so you can view multiple workbooks at once, making cross-referencing and multitasking smoother than ever. You will explore viewing workbooks side by side with the option to turn synchronous scrolling on or off, tailoring your experience to your needs.
Watch the course sample below!
Excel 365 in 30 Minutes – Workbook Properties & Views (Intermediate 2 of 8) equips you with essential skills to manage and visualize your workbooks like a pro. You will learn to switch effortlessly between open workbooks using Switch Windows and open multiple instances of the same workbook with New Window, giving you unparalleled control over your workspace. This course offers a clear, hands-on approach to mastering workbook properties and views, helping you work smarter, stay organized, and make your data more accessible and actionable. Whether you’re juggling multiple projects or diving deep into detailed analysis, this course invites you to unlock Excel’s full potential and elevate your efficiency every day.
