Workbook links allow you to connect one Microsoft Excel spreadsheet to other spreadsheets, Word documents, databases, and even web pages. However, if you’re unfamiliar with workbook links and how to maneuver your way through them, you’ll benefit from this outstanding webcast. Excel expert David Ringstrom, CPA, explains the pros and cons of workbook links and walks you through creating and working with them. David 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.
- 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 :
- Understanding how to create and identify workbook links.
- Creating flexible workbook links that can be copied down columns or across rows.
- Controlling whether linked workbooks update automatically or not as well as suppress unwanted prompts.
- Using the Break Links command to remove links to other workbooks.
- 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.
- Learning about a free tool you can use to locate even the most buried workbook links.
- Learning how to break links to other workbooks and data sources.
- Managing prompts that appear when you open a workbook that contains links.
- Using features within Excel to locate workbook links.
- Learning the risks of linked workbooks, determining if a workbook contains links, and seeing how links can hide within Excel features
Who Should Attend:
- Investment Analysts
- Financial Analysts
- Business Analysts
- Forecasting & Planning Teams
- M&A Specialists (Mergers & Acquisitions)
- Risk Managers
- Strategic Planners
- Capital Expenditure Planners
- Cost Accountants
- Managerial Accountants
- Other Accounting and Finance Professionals
- Human Resources Departments
- IT Departments
- Banking Professionals
- Insurance Professionals
- Excel Users in Regulated Lifesciences Industry
- Logistics and Supply Chain Professionals
- Sales and Marketing Professionals