Practical Excel – Discovering and Navigating Workbook Links

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.

Learning Objectives:

  • 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:

  • CFOs
  • CPAs
  • Controllers
  • 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
  • Auditors
  • Banking Professionals
  • Insurance Professionals
  • Excel Users in Regulated Lifesciences Industry
  • Logistics and Supply Chain Professionals
  • Sales and Marketing Professionals

IT2795

David H Ringstrom

David H. Ringstrom, CPA, is a nationally recognized Microsoft Excel expert. He is the president and owner of Accounting Advisors, Inc. based in Atlanta, Georgia. David founded Accounting Advisors in 1991 as a consulting-services business, later he began teaching continuing education classes as well. His mission since is to offer quality training and consulting services on Microsoft Excel via live webcasts, on-demand self-study webcasts, and in-house engagements. David has taught hundreds of webinars on Excel and other topics, in addition to speaking at conferences and in-house engagements.

membership

JUST RELEASED
SEMINARS
&
WORKSHOPS
 





  • Login Information with Password to join the session, 24 hours prior to the webinar
  • Presentation Handout in .pdf format
  • Presentation from the Speaker
  • Feedback form
  • Certificate of Attendance
  • Recording access Information with Password to view the webinar, will be sent 24 hours after the completion of the Live webinar.
  • Presentation Handout in .pdf format
  • Certificate of Attendance
.