|
|
How to apply the power of linking techniques within Excel and other key MS Office applications to boost productivity and efficiency for you and your organization? Using MS Excel you can link or reference to other cells in a worksheet or other worksheets, external workbooks, external files, and pages on the internet or your intranet, a valuable and marketable skill. Dynamic links ensure changes in source data, graphics and charts etc. are reflected in all “dependent linked” files. Mastering the linking of information using MS Excel and MS Office is a valuable skill. Attend this presentation with Excel expert David Ringstrom, CPA, and you’ll
discover the pros and cons of workbook links and how to create and work with them.
Key Learning Objectives- Learn how to link Excel workbooks to other sources
- Understand how to minimize the data-integrity risks that can arise from workbook links
- Identify and take control of security prompts and settings related to linked workbooks
- Summarize information from access databases and other sources
- Learn functions you should avoid when creating workbook links
- Create workbook links that can be copied down columns or across rows
|
| |
|
|
|
 |
David H. Ringstrom
David H. 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 dozens of webinars annually on Excel and other topics. He has written numerous articles on spreadsheets, some of which have been published internationally. | |
View More |
| |
|
