banner



How To Import Excel Report Card To Powerschool

If y'all are using PowerPoint 2013 or a newer version, you tin can link data from a saved Excel worksheet to your PowerPoint presentation. That way, if information in the worksheet changes, you can hands update it in your PowerPoint presentation.

Link an unabridged Excel worksheet to PowerPoint

  1. In PowerPoint, on the Insert tab, click or tap Object.

    object selection on insert tab

  2. In the Insert Object dialog box, select Create from file.

    file browse dialog box

  3. Click or tap Browse, and in the Browse box, find the Excel workbook with the data you want to insert and link to.

  4. Before you shut the Insert Object box, select Link, and click OK.

    choosing link for inserting a file into powerpoint

    Of import:The linked object in your presentation displays all the information from the active, top worksheet in the linked Excel workbook. When you save the Excel workbook, make certain the worksheet y'all want in your presentation is the one you see when you commencement open up the workbook.

Link a section of data in Excel to PowerPoint

  1. In Excel, open the saved workbook with the data you desire to insert and link to.

  2. Elevate over the area of data you want to link to in PowerPoint, and on the Habitation tab, click or tap Copy.

  3. In PowerPoint, click the slide where you want to paste the copied worksheet data.

  4. On the Dwelling tab, click the arrow below Paste, and select Paste Special.

    show paste special option

  5. In the Paste Special box, click Paste link, and then, nether As, select Microsoft Excel Worksheet Object.

    shows pasting file as link dialog

Copy and paste (unlinked) Excel data in PowerPoint

In this instance, the Excel information volition not be linked to your PowerPoint presentation. You re-create the data from an Excel worksheet and paste it into your presentation. The worksheet does non send automatic updates to PowerPoint.

  1. In Excel, open the workbook with the information you lot desire to copy.

  2. Drag over the surface area of data you desire to copy, and on the Home tab, click or tap Copy.

  3. In PowerPoint, click the slide where you want to paste the copied worksheet data.

  4. On the Home tab, in the Clipboard group, click the arrow below Paste.

  5. Under Paste Options, pick one of the post-obit. Motility the mouse pointer over each Paste option to encounter a preview of what information technology would await like.

    Use Destination Styles

    Use Destination Styles to copy the data as a PowerPoint table, using the format of the presentation

    Keep Source Formatting

    Go along Source Formatting to re-create the Excel data as a PowerPoint table, using the format of the worksheet

    Embed

    Embed to copy the information equally information that tin exist edited in Excel later

    Moving-picture show to copy the information as a motion picture that can't exist edited in Excel

    Keep Text Only

    Go along Text Just to copy all the data as a single text box

See As well

Copy an Excel chart to another Function plan

Insert a linked worksheet

To insert and link a saved Excel worksheet onto your PowerPoint slide, do the post-obit:

Important:The linked object in your presentation displays all information from the active, top worksheet in the linked Excel workbook.

  1. In PowerPoint 2010, on the Insert tab, in the Text group, click Object.

  2. In the Insert Object dialog box, select Create from file.

  3. Click Browse, and in the Scan dialog box, scan to and so select the Excel workbook that contains the data that you want to insert, then click OK.

  4. In the Insert Object dialog box, select Link and and then click OK.

To edit a linked Excel worksheet, exercise one of the following:

  • To edit the data from within Excel, right-click the object on the slide, bespeak to Linked Worksheet Object, and select Edit.

  • To update the data on the slide to match the information in the original Excel file, right-click the object on the slide, and click Update Link.

Insert a linked choice from a worksheet

To insert and link a pick of information from a saved Excel worksheet, do the post-obit:

  1. In Excel, open the workbook containing that data that you lot want to insert.

  2. Select and copy the data that you want.

    Keyboard shortcut    You tin can press CTRL+C to copy the information.

  3. In PowerPoint 2010, click the slide where you lot want to paste the copied worksheet data.

  4. On the Home tab, in the Clipboard group, click the arrow below Paste, and select Paste Special.

  5. In the Paste Special dialog box, under As, select a Microsoft Excel Worksheet Object.

  6. Select the Paste link bank check box and click OK.

To edit a option of cells from a linked Excel worksheet, do one of the following:

  • To edit the data from within Excel, correct-click the object on the slide, betoken to Linked Worksheet Object, and select Edit.

  • To update the data on the slide to match the data in the original Excel file, correct-click the object on the slide, and click Update Link.

Copy a selection of cells onto a slide

To paste a copy a selection of Excel data onto your PowerPoint slide, do the following:

Note:Data copied and pasted onto a PowerPoint slide does non automatically update when the data is changed in the Excel workbook. To link the data on the PowerPoint slide to the original Excel data source, meet the "Insert a linked pick from a worksheet" section immediately above.

  1. In Excel, open the workbook that contains the information that you desire to copy.

  2. Select and copy the data that y'all want.

    Keyboard shortcut    You can press CTRL+C to copy the data.

  3. In PowerPoint 2010, click the slide where yous desire to paste the copied worksheet information.

  4. On the Home tab, in the Clipboard group, click the arrow below Paste.

  5. Under Paste Options, do ane of the following:

    1. Select Keep Source Formatting if you want to copy the data as a PowerPoint table, but desire it keep the appearance of the original Excel worksheet.

    2. Select Apply Destination Modes if you want to copy the data as a PowerPoint table, merely desire information technology to assume the appearance of the PowerPoint presentation.

    3. Select Embed if you want to copy the data as information that can be edited in PowerPoint.

    4. Select Picture if yous want to copy the information as an united nations-editable moving-picture show.

    5. Select Continue Text But if you lot want to copy all the information as a single text box.

See Likewise

Import content from other applications

Copy an Excel chart to another Office program

Need more help?

Source: https://support.microsoft.com/en-us/office/insert-excel-data-in-powerpoint-0690708a-5ce6-41b4-923f-11d57554138d

Posted by: shaffercohned.blogspot.com

0 Response to "How To Import Excel Report Card To Powerschool"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel