If you're unfamiliar with workbook links and how to maneuver your way through them, you'll benefit from this outstanding webcast. Workbook links allow you to connect one Excel spreadsheet to other spreadsheets, Word documents, databases, and even web pages. Excel expert David Ringstrom, CPA, explains the pros and cons of workbook links and walks you through creating and working with them. He also shows you how to dramatically improve the integrity of linked workbooks by using Microsoft Query instead of traditional cell-based links.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
Why should you attend?
- Recall how to link Excel workbooks to other sources.
- Describe how to use Microsoft Query to move data from one workbook into another.
- Identify and take control of security prompts and settings related to linked workbooks.
Areas Covered in the Session:
- Controlling whether linked workbooks update automatically or not as well as suppress unwanted prompts.
- Learning how to repair broken workbook links.
- Learning how to arrange two worksheets from within the same workbook on-screen and at the same time.
- Managing prompts that appear when you open a workbook that contains links.
- Using features within Excel to locate workbook links.
- Discovering a free tool you can use to locate even the most buried workbook links.
- Understanding how to create and identify workbook links.
- Using the Break Links command to remove links to other workbooks.
- Learning how to break links to other workbooks and data sources.
- Creating flexible workbook links that can be copied down columns or across rows.
- Learning the risks of linked workbooks, determining if a workbook contains links, and seeing how links can hide within Excel features.
Who can Benefit:
Practitioners seeking to learn about Excel workbook links and improve the integrity of their linked workbooks.