FRINK Linked Data Fragments server

Matches in SemOpenAlex for { <https://semopenalex.org/work/W355233786> ?p ?o ?g. }

• W355233786 startingPage "57" @default.
• W355233786 abstract "Your boss asks you to make an important financial presentation to a group of potential shareholders who are not particularly adept at reading spreadsheets crammed with numbers. Although the financial information is collected and calculated in Excel, he wants the presentation to be viewer friendly and have more pizzazz than a spreadsheet. It may be a cliche, he says, but a picture is worth a thousand words--or in this case it's worth more than a thousand numbers. So you tell your boss you'll put on a sprightly financial show-and-tell in PowerPoint, the Microsoft presentation application. Whoa, he interrupts, don't you know that last-minute sales data will come in from the accounting department just minutes before your scheduled presentation--which means there's no way you'll have time to plug the new numbers into the PowerPoint slides? can solve that problem, you reply confidently. With just a few keystrokes and mouse clicks, I can link the Excel cells to the appropriate slides in PowerPoint so that when the accounting department changes the spreadsheet data, those numbers will change immediately in PowerPoint, too. HOW IT'S DONE This article will demonstrate how to create such a link. Since all integrated software suites--which typically include a word processor, a spreadsheet, a database and a presentation application--allow users to create links between any of its applications so that data changes in one will be reflected in the other, what you learn here also can be adapted for use in other office suite applications. For this demonstration, using the 2000 version of Microsoft Office Suite, we'll demonstrate how to convert an Excel spreadsheet into a chart and then paste and link it to a slide in PowerPoint. As you know, it's a cinch to simply copy a chart created in Excel and paste it into another application. However, that method only lets you create a static image. If the Excel numbers change and you want them to be reflected in the copy made in the other application, you'll have to make the changes manually. If, however, you link the original spreadsheet to the copy, changes in the original will flow automatically to the copy--in this case to a PowerPoint slide. To accomplish that, we're applying a technology called OLE (object linking and embedding). GETTING STARTED We created a simple spreadsheet in Excel that shows quarterly and annual revenues of Main Golf Course, broken down by revenue sources. Using those data, we created a pie chart to illustrate the revenue contributions (exhibit 1, page 58). Since the data and the chart are automatically linked, any changes in the underlying data in the spreadsheet change the chart at the same time. [ILLUSTRATION OMITTED] So let's get started. Open PowerPoint, choose Blank Presentation and click on OK. That brings up the New Slide dialog box. Select a blank slide and click on OK. Your screen should now resemble exhibit 2, page 58. This is the slide where you want to place the linked chart. [ILLUSTRATION OMITTED] Return to Excel and open the file containing the data and chart you want to link to PowerPoint. Highlight the pie chart and you will see black selection handles (see exhibit 1). In addition, Excel places colored borders around the data that were used to create the chart. Now click on the Copy button on the toolbar or right-click for a menu and click on Copy. That copies the chart to the Clipboard. You should now see a moving border around the selected chart. Return to the PowerPoint slide and select Edit, Paste Special. That will bring up the Paste Special dialog box (exhibit 3), which enables you to create an active link between the Excel chart and the PowerPoint slide. [ILLUSTRATION OMITTED] Caveat: Don't just switch to PowerPoint and click on the Paste button. If you do, you'll paste the Excel chart in the presentation but you won't create an active link. …" @default.
• W355233786 created "2016-06-24" @default.
• W355233786 creator A5032328364 @default.
• W355233786 creator A5090107237 @default.
• W355233786 date "2002-02-01" @default.
• W355233786 modified "2023-09-23" @default.
• W355233786 title "Show-and-Tell in Real Time: Link a Spreadsheet to a PowerPoint Slide for Up-to-the-Minute Visuals" @default.
• W355233786 hasPublicationYear "2002" @default.
• W355233786 type Work @default.
• W355233786 sameAs 355233786 @default.
• W355233786 citedByCount "0" @default.
• W355233786 crossrefType "journal-article" @default.
• W355233786 hasAuthorship W355233786A5032328364 @default.
• W355233786 hasAuthorship W355233786A5090107237 @default.
• W355233786 hasConcept C126838900 @default.
• W355233786 hasConcept C127413603 @default.
• W355233786 hasConcept C136764020 @default.
• W355233786 hasConcept C138885662 @default.
• W355233786 hasConcept C17744445 @default.
• W355233786 hasConcept C199360897 @default.
• W355233786 hasConcept C199539241 @default.
• W355233786 hasConcept C204321447 @default.
• W355233786 hasConcept C2777020290 @default.
• W355233786 hasConcept C2777601897 @default.
• W355233786 hasConcept C2777904410 @default.
• W355233786 hasConcept C2778184401 @default.
• W355233786 hasConcept C2983335612 @default.
• W355233786 hasConcept C2985584371 @default.
• W355233786 hasConcept C41008148 @default.
• W355233786 hasConcept C41895202 @default.
• W355233786 hasConcept C554936623 @default.
• W355233786 hasConcept C56666940 @default.
• W355233786 hasConcept C71924100 @default.
• W355233786 hasConcept C78519656 @default.
• W355233786 hasConceptScore W355233786C126838900 @default.
• W355233786 hasConceptScore W355233786C127413603 @default.
• W355233786 hasConceptScore W355233786C136764020 @default.
• W355233786 hasConceptScore W355233786C138885662 @default.
• W355233786 hasConceptScore W355233786C17744445 @default.
• W355233786 hasConceptScore W355233786C199360897 @default.
• W355233786 hasConceptScore W355233786C199539241 @default.
• W355233786 hasConceptScore W355233786C204321447 @default.
• W355233786 hasConceptScore W355233786C2777020290 @default.
• W355233786 hasConceptScore W355233786C2777601897 @default.
• W355233786 hasConceptScore W355233786C2777904410 @default.
• W355233786 hasConceptScore W355233786C2778184401 @default.
• W355233786 hasConceptScore W355233786C2983335612 @default.
• W355233786 hasConceptScore W355233786C2985584371 @default.
• W355233786 hasConceptScore W355233786C41008148 @default.
• W355233786 hasConceptScore W355233786C41895202 @default.
• W355233786 hasConceptScore W355233786C554936623 @default.
• W355233786 hasConceptScore W355233786C56666940 @default.
• W355233786 hasConceptScore W355233786C71924100 @default.
• W355233786 hasConceptScore W355233786C78519656 @default.
• W355233786 hasIssue "2" @default.
• W355233786 hasLocation W3552337861 @default.
• W355233786 hasOpenAccess W355233786 @default.
• W355233786 hasPrimaryLocation W3552337861 @default.
• W355233786 hasRelatedWork W158055347 @default.
• W355233786 hasRelatedWork W162526736 @default.
• W355233786 hasRelatedWork W2186868775 @default.
• W355233786 hasRelatedWork W2210497602 @default.
• W355233786 hasRelatedWork W2282415663 @default.
• W355233786 hasRelatedWork W2539853199 @default.
• W355233786 hasRelatedWork W2565555729 @default.
• W355233786 hasRelatedWork W2738491081 @default.
• W355233786 hasRelatedWork W279042893 @default.
• W355233786 hasRelatedWork W2913725148 @default.
• W355233786 hasRelatedWork W2914117804 @default.
• W355233786 hasRelatedWork W2924047037 @default.
• W355233786 hasRelatedWork W2991702053 @default.
• W355233786 hasRelatedWork W2993507244 @default.
• W355233786 hasRelatedWork W2994325639 @default.
• W355233786 hasRelatedWork W305573079 @default.
• W355233786 hasRelatedWork W348142183 @default.
• W355233786 hasRelatedWork W4375623 @default.
• W355233786 hasRelatedWork W633788186 @default.
• W355233786 hasRelatedWork W646215043 @default.
• W355233786 hasVolume "193" @default.
• W355233786 isParatext "false" @default.
• W355233786 isRetracted "false" @default.
• W355233786 magId "355233786" @default.
• W355233786 workType "article" @default.