Course Name: Excel: Workbook Links
CPD hours: 2
Type: Online/Video
Price: $120 $108
Description:
In this insightful on-demand webcast, we takes you step-by-step through the process of creating and working with workbook links. In addition, he outlines the pros and cons of Excel’s workbook links. Because workbook links allow you to connect one Excel spreadsheet to other spreadsheets, Word documents, databases, and even web pages, they are quite beneficial. We also covers how to dramatically improve the integrity of linked workbooks, copy links across rows or down columns, repair broken links, and more.
We demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. We also provides an Excel workbook that includes most of the examples he uses during the webcast.
Upon completion of this course, the learner will be able to:
- Apply security prompts and settings related to linked workbooks.
- Describe how to use Microsoft Query to move data from one workbook into another.
- Recall the Excel function that allows you to sum values related to multiple instances of criteria you specify.