Written and Presented by David H. Ringstrom, CPA Accounting - - PowerPoint PPT Presentation

▶
written and presented by david h ringstrom cpa accounting
SMART_READER_LITE
LIVE PREVIEW

Written and Presented by David H. Ringstrom, CPA Accounting - - PowerPoint PPT Presentation

Nov 29, 2023 224 likes •453 views

Slide ID: 445 www.accountingweb.com/highimpactexcel Customer service/CPE questions: editor@accountingweb.com Written and Presented by David H. Ringstrom, CPA Accounting Advisors, Inc. www.accountingadvisors.com About the speaker: David is

slide-1
SLIDE 1

Written and Presented by David H. Ringstrom, CPA Accounting Advisors, Inc. www.accountingadvisors.com

About the speaker: David is owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. Throughout his career David has spoken at conferences on Microsoft Excel, and written dozens of freelance articles about spreadsheets. He offers Excel and Access training and consulting services nationwide.

Last Revised: 10/30/14

Slide ID: 445

www.accountingweb.com/highimpactexcel

Customer service/CPE questions: editor@accountingweb.com

slide-2
SLIDE 2

Excel Versions

Slide ID: 368 2 of 21

slide-3
SLIDE 3

Arranging Two Workbooks Onscreen

Slide ID: 3102 3 of 21

slide-4
SLIDE 4

Creating a Workbook Link

Slide ID: 3105 4 of 21

slide-5
SLIDE 5

Deconstructing a Workbook Link

Slide ID: 3103 5 of 21

slide-6
SLIDE 6

Workbook Links Work in any Worksheet Function

Slide ID: 3104 6 of 21

slide-7
SLIDE 7

Confirming If a File Has Links

Slide ID: 853 7 of 21

slide-8
SLIDE 8

When Workbook Links Go Awry

Slide ID: 843 8 of 21

slide-9
SLIDE 9

Linked Workbook Security Settings

Slide ID: 2981 9 of 21

slide-10
SLIDE 10

Link Start-Up Prompt

Slide ID: 3107 10 of 21

slide-11
SLIDE 11

Find Links in a Workbook

Slide ID: 1199 11 of 21

slide-12
SLIDE 12

Another Place that Links Sometimes Hide

Slide ID: 1899 12 of 21

slide-13
SLIDE 13

Workbook Link Removal Tool

Slide ID: 2980 13 of 21

slide-14
SLIDE 14

Using the Link Finder Tool

Slide ID: 503 14 of 21

slide-15
SLIDE 15

Microsoft Query as Workbook Link Alternative

Slide ID: 2063 15 of 21

slide-16
SLIDE 16

Microsoft Query as Workbook Link Alternative

Slide ID: 2064 16 of 21

slide-17
SLIDE 17

Link Data from Web Pages

Slide ID: 1332 17 of 21

slide-18
SLIDE 18

Link Data from Web Pages

Slide ID: 1333 18 of 21

slide-19
SLIDE 19

Linking Word Documents to Excel Spreadsheets

Slide ID: 1773 19 of 21

slide-20
SLIDE 20

Formatting Linked Excel Data In Word

Slide ID: 3106 20 of 21

slide-21
SLIDE 21

Thank you for attending!

 I’m happy to hear from you: david@acctadv.com  Don’t miss the Q&A hour, as some of the best learning happens then!  View recordings for any past sessions, and register for upcoming

sessions at www.accountingweb.com/highimpactexcel

 CPE is only available for live sessions of the High Impact Excel series.

No CPE credit is available for past recordings or the Q&A hour.

 Get notified when I write new articles about Excel, et. al.:

Slide ID: 485

www.twitter.com/excelwriter www.facebook.com/accountingadvisors

  • www. linkedin.com/in/davidringstrom