The Excel-to-PowerPoint Connection

From the Excel Dashboard Toolkit and Excel+Design Free Newsletter

Tired of manually copy-pasting metrics from your Excel sheets into your PowerPoint slides? I know your pain.

I’ve had projects where I had to copy-paste 100+ metrics one-by-one into a new slide deck every single week. It. Was. A. Nightmare.

Luckily there is an easy solution.

You can link your Excel file to PowerPoint so that whenever you change your Excel calculations it automatically changes in your slides.
That’s right, you don’t have to do any more copy-pasting.

Here’s how you do it. Note: this will work for the PC version of Excel but not on mac.

How to put metrics and charts from your Excel sheet into PowerPoint

1 Open up your Excel sheet with your metrics, find the data or chart that you want in your PowerPoint file, select it and copy it.

2 In PowerPoint find the slide where you want to put your Excel data, navigate to the ‘Home’ tab, click the arrow beneath the ‘Paste’ section on the left and then hit ‘Paste Special’

3 In the box click ‘Paste link’ and then ‘As’ a Microsoft Worksheet Object.

4 Whenever you re-open the Excel doc you will get a dialogue box asking if you’d like to update the linked data and it will automatically update to match your Excel sheet.

If you like these tips and want to learn more about Excel then check out my newsletter and toolkit ↓

One of the templates I send out in my newsletter

1— I send out free sample templates every month in my newsletter: https://exceldashboardtemplate.com/newsletter

Some of the goodies included in my Excel toolkit — for sale here

2— I have a very detailed toolkit with 125 Excel designs (25 charts in 5 different color palettes) and more: https://exceldashboardtemplate.com/

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Josh Cottrell-Schloemer

Josh Cottrell-Schloemer

Building data-focused products. Startups acquired=1. Hobby = making Google Data Studio & Excel beautiful.