To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

We show you how to convert Excel spreadsheet to PowerPoint slide. Learn how to Convert Excel to PowerPoint & link Excel to PPT.

Excel has its own functions for simple layout, but if you are writing a report or similar and want to use data from large Excel tables, it’s easy to link the two Office programs.

I often make presentations based on last-minute sales data. It gets really wild when I have to copy last-minute numbers from the spreadsheet and quickly drop them into a Word document for the ...

Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here's how.

The link will allow users to build BI reports from within Excel and see accurate, up-to-date data when they open Excel, the company said.

An curved arrow pointing right. You can create reports in Word and PowerPoint that are linked to tables and charts in Excel. Produced by Sara Silverstein Follow BI Video: On Facebook More from ...