Maneuvering Linked Workbooks

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Maneuvering Linked Workbooks October   28 1 pm - 2:40 pm ET Presenter: David Ringstrom, an author and nationally recognized instructor Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Learn More Register Today Course Description   When you participate in practical webinar, you'll learn from Excel expert, David Ringstrom, CPA, about the pros and cons of workbook links and how to create and work with them. Workbook links are quite beneficial, as they allow you to connect one Excel spreadsheet to other spreadsheets, Word documents, databases, and even web pages. You will learn how to dramatically improve the integrity of linked workbooks, copy links across rows or down columns, repair broken links, and much more. You will see each technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. You will identify differences in Excel 2016, 2013, or 2010 and will receive detailed handouts. You will also receive an Excel workbook that includes the examples presented during the webinar. You will learn how to: Control whether linked workbooks update automatically or not, as well as how to suppress unwanted prompts Create flexible workbook links that can be copied down columns or across rows Utilize a free tool to locate even the most buried workbook links Eliminate the risk of workbook links by using Microsoft Query to get data from one workbook into another Employ the SUMIF function to sum values related to multiple instances of criteria you specify Integrate data on web pages into your workbooks and create automatic links Arrange two worksheets from within the same workbook on-screen and at the same time Break links to other workbooks and data sources Repair broken workbook links Link Word documents and Excel spreadsheets in the most efficient way Evaluate the risks of linked workbooks, determine if a workbook contains links, and identify how links can hide within Excel features Recognize which functions to avoid when creating workbook links Upon course completion, you will be able to: Describe how to link Excel workbooks to other sources Identify how to minimize data-integrity risks that can arise from workbook links Apply security prompts and settings related to linked workbooks Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,500 on-demand courses Learn More Upcoming Webinars VLOOKUP and SUMIFS Excel Functions October 29 at 3 pm ET Learn More Earned Income Tax Credit (EITC) Due Diligence Requirements October 30 at 1 pm ET Learn More Becoming a Strategic HR Business Partner through Performance Management October 30 at 3 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.