The University of Southampton
iSolutions IT Training and Development
If you are working remotely, you can find out how to use Teams in our latest video and in the Office 365 support centre.
All our online courses and LinkedIn Learning content is still available to you wherever you are working.
For further information and ongoing updates please visit our COVID-19 page

PowerPoint 2016 - Data-Driven Presentations with Excel

Learn to create information-rich, visually compelling PowerPoint presentations driven by Excel data. The presentations you generate in this course are easy to use, easy to understand, and - best of all - easy to update. Gini von Courter begins with an example spreadsheet featuring typical business data. She uses conditional formatting to highlight important information, PivotTables to summarize data, and sparklines and charts to create illustrations. Next, she shows how to use several different methods, including copying and pasting, linking, and embedding, to import your work into PowerPoint. She then shows how to use PowerPoint animation features to animate Excel charts and tables and focus the viewer's attention. If you've wondered how to create expressive but low-maintenance presentations to showcase your data, this course is for you.

Topics include

  • Copying, pasting, linking, and embedding data
  • Creating charts in PowerPoint
  • Formatting ranges
  • Restoring missing data
  • Adding slicers
  • Building charters
  • Highlighting data
  • Summarizing data with PivotTables
  • Putting presentation elements together in PowerPoint

Duration: online

Launch the tutorial >

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your settings, we will assume that you are happy to receive cookies on the University of Southampton website.

×