Tags

, ,

Overview:

Many Excel users have a love-hate relationship with workbook links. For the uninitiated, workbook links allow you to connect one Microsoft Excel training spreadsheet to other spreadsheets, MS Word training online documents, databases, and even web pages.
In this webinar, Excel expert David Ringstrom, CPA discusses the pros and cons of workbook links, and walks you through the nuances of creating workbook links. David will also show how to dramatically improve the integrity of linked workbooks by using Microsoft Query instead of traditional cell-based links.

Why Should You Attend:

Control whether linked workbooks update automatically or not, and suppress unwanted prompts
Discover a free tool that you can use to locate even the most buried workbook links
Eliminate the risk of workbook links by using Microsoft Query to get data into one workbook from another
Integrate data on web pages into your workbooks, and create automatic links

Areas Covered in this Webinar:

Learn how to break links to other workbooks and data sources
Learn how to repair broken workbook links
Learn the most efficient way to link Word documents and Excel spreadsheets
Learn the risks of linked workbooks, determine if a workbook contains links, and see how links can hide within Excel features
Learn the risks of linked workbooks, determine if a workbook contains links, and see how links can hide within Excel features
Understand how to create and identify workbook links
Use features within Excel to locate workbook links

Learning Objectives:

Learn how link Excel workbooks to other sources
Minimize the data integrity risks that can arise from workbook links
Take control of security prompts and settings related to linked workbooks

Who Will Benefit:

CFO’s
Controllers
Investment Analysts / Financial Analysts / Business Analysts
Forecasting & Planning Personnel
Mergers & Acquisitions Specialists
Risk Managers
Strategic Planners / Capital Expenditure Planners
Cost Accountants / Managerial Accountants

Speaker Profile:

David Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. David speaks at conferences and presents webinars to thousands of attendees annually on Excel and other topics. He has written hundreds of freelance articles on spreadsheets, some of which have been published internationally. David’s catch phrase is “Either you work Excel or it works you.” His goal is to make you a smarter and more effective spreadsheet user.

For more detail please click on this below link:

http://bit.ly/1U3lmpB

Email: referrals@complianceglobal.us
Toll Free: +1-844-746-4244
Tel: +1-516-900-5515

Fax: +1-516-900-5510

Advertisements