Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training uk - Excel from Powerpoint

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training uk - Excel from Powerpoint

Resolved · Low Priority · Version Standard

Reply Wed 10 Oct 2007, 15:39Delegate Damon said...

Damon has attended:
Excel Introduction course

Excel from Powerpoint

How can I link from Powerpoint from an Excel Spreadsheet?

For upcoming training course dates see: Pricing & availability

Reply Thu 11 Oct 2007, 10:22Trainer Pete said...

RE: Excel from Powerpoint

Hi Damon, Thanks for the post, I am assuming that you wish to place a link into your PowerPoint presentation that will display an Excel spreadsheet and give the latest update when you open the presentation. Follow these steps:
Menu command Insert, Object. In the dialog box choose Create from file, and press Browse button. Navigate to your chosen Excel Spreadsheet, click OK, and then click the "Link" check box to create your link. To edit the Spreadsheet double click on it to open the link. If changes are made in the spreadsheet you will notice the changes immediately if both are open, if they are not both open when you open PowerPoint presentation you will be asked if you wish to update the spreadsheet.

Excel articles

· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Learn How To Separate Text In Excel Into Separate Cells
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Copy And Paste In Excel
· Tips to Facilitate Printing of Excel worksheets

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips